This lab will focus on building and using query expressions to highlight useful data of interest from a dataset. During the lab, understanding and skill of attribute and spatial queries and how to use these in combination with each other will be showcased. Multiple criteria queries will be built using Boolean expressions, operators, and parentheses and the resulting query data will then be successfully mapped.
Methods:
For part one of the lab I added a U.S. counties layer to the map and then used the select by attributes tool to create multiple criteria queries. When starting a query I kept the method to Create New Selection and then depending on what the next part of the query involved, I changed the method to either Add to Selected Features (if I wanted results including the selected features but outside of them as well) or Select from Selected Features (if I wanted results narrowed down inside the features that were already selected). Some of the criteria included county population and demographics. For part two of the lab I downloaded a Wisconsin Dataset and made a multiple criteria query for cities with certain qualities within 2 miles. For the next question of part two, I used a query to select the rivers assigned to select and then used the statistics option to find the total length of all the selected rivers.
Results:
Part One, Question 1:
Counties with population between 3000 and 4000 people in 2010 and also all counties in 2010 that had a population density of at least 1000 persons per square mile.
Part One, Question 2:
Counties in Wisconsin, Texas, New York, Minnesota, and California where male population is greater than female population and also for these states the number of seniors (age 65 and above) is over 6500.
Part One, Question 3:
Modified the query developed in question 2 to add all other seniors in Washington, Maryland, Illinois, Nebraska, District of Columbia and Michigan who reside in counties that have more than 30,000 housing units to the result obtained in query 2
Part 2, Question 4:
Cities in Wisconsin with population (2007 population) between 15,000 and 20,000 people, area of the city is at least 5 square miles in land area, and also female population is greater than males, and also the cities are within 2 miles of a lake.
Part 2, Question 5:
Rivers selected: CHIPPEWA R, EAU CLAIRE R, EMBARRASS R, FISHER R, HUNTING R, KINNICKINNIC R, MAUNESHA R, MILWAUKEE R, MOOSE R, NAMEKAGON R, PELICAN R, PLATTE R, and POTATO R. Total Length is 137937
Miles.
Sources:
Price, Maribeth. Mastering ArcGIS. 7th ed. N.p.: McGraw Hill, 2016. Web. 7 March. 2016.
Esri. Online Wisconsin data. Web. 28 March. 2016.
