GIS 1 Lab 4

Goals and Background

The primary goal of Lab 4 was to gain skills in using and implementing the search query on ArcGIS maps to extract components of data from a database. The lab helped to assess how we understand attribute and spatial queries. Lab 4 was completed using Boolean expressions, operators, parenthesis, etc.. to help create multiple criteria queries that allowed us to extract the data we were interested in. Along with the attribute queries, spatial queries were used to execute specific tasks in extracting data. Once the queries were completed, the data that was extracted was mapped for viewing.

Methods

United States County Queries

The county data from the US database within the Price mgisdata was added to the map to create the query from. Once added, a multiple criteria query was completed to extract data that allowed one to view counties with a population between 3000 and 4000, as well as counties that had a population density greater than 1000.

(Specific Query Used to extract data.)


Once that was completed, the data was used to find specific pieces of information, such as: the amount of counties that met the criteria (194), how many states were in the selection (35), which state had the highest amount of selections (Virginia), which state had 8 counties that met the criteria (California), and the selection was also used to find the mean (554924) and standard deviation(1014847) of the population of the counties. 
 
The second activity was to write another multiple criteria query for the US county data. This query involved writing an expression where the male population is greater than the female population and the population of seniors (greater than 65) is over 6500. This query was all within the states: Wisconsin, Texas, New York, Minnesota, and California.

(Query used to extract data on counties.)

Once the data had been extracted, questions were answered to further explore the results of the data. These questions were: how many counties met the above criteria in the five states (46) , which state had the highest counties that met the above criteria and how many counties (Texas with 14), and to list the counties in Wisconsin that fulfilled the criteria (Grant, Waupaca, Sheboygan, Columbia, Dodge).

After this query had been completed, another set of conditions were added to the multiple criteria query. This addition was to find counties in Washington, Maryland, Illinois, Nebraska, District of Columbia, and Michigan who live in counties where there is over 30,000 housing units. This was used to find the new amount for the counties that had been fulfilled by the query (128).

(Multiple Criteria Query to add additional counties.)

Wisconsin Queries

The second part of the lab was an activity that allows one to return cities within a Wisconsin dataset that has data collected from 2007 (Wilson). The purpose was to find what cities in the state have a population between 15000 and 20000, the area is at least 5 square miles, the female population is greater than the male population, and the cities are within 2 miles of a lake. To do this a multiple criteria query and a location search needs to be done.

(Multiple Criteria Query)

(Select by Location)

After this was completed, the results are used to determine how many cities in Wisconsin met the criteria above (3), and which cities they were (Middleton, Beaver Dam, Menasha). The total population of these cities was 48,914.


Another multiple criteria query was used to search for a set of rivers within Wisconsin.
(Multiple Criteria Query which lists the rivers searched for.)


The goal of this query was to determine the amount of rivers found with these names in the state of Wisconsin (80), and the total length of the rivers, which amounted to 137,937 miles. 

Results

(Counties with population between 3000 and 4000, and counties with pop. density greater than 1000.)

(Counties within Wisconsin, Texas, New York, Minnesota, and California that has a male population greater than females, and a senior citizen population over 6500.)

(Counties within Wisconsin, Texas, New York, Minnesota, and California that has a male population greater than females, and a senior citizen population over 6500. As well as counties within Washington, Maryland, Illinois, Nebraska, District of Columbia, and Michigan where there are more than 30,000 housing units.)

 

 

 

Part 2

 

 

(Cities in Wisconsin that have a population between 15,000 and 20,000, an area greater than 5 square miles and a female population greater than a male.)

 

 

 

 

( Rivers in Wisconsin: Chippewa, Eau Claire, Embarrass, Fisher, Hunting, Kinnickinnic, Maunesha, Milwaukee, Moose, Namekagon, Pelican, Platter, Potato.)

 

 

Sources

Price, Maribeth H.. (2016). Mastering ArcGIS. Mcgraw Hill Higher Education.

 

ESRI - Wisconsin Cities, Interstates, Rivers, Roads, County Shapefiles.

 

Dr. Wilson. -Wisconsin Lakes.