Goal:
The goal of this lab is to use multiply queries to obtain answers from arcmaps.
Methods:
Part 1: United States
Question 1: First add the counties layer from the USA geodatabase. Write a multiple query to find that will return counties that show a 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. Do a select by attributes query that will look like this:
This will tell you how many counties were selected. Next you can build a summarize table of state fips and state name first to yield how many counties were in each state. From the table you will be able to figure out which state hat the most and which state had 8 counties. Then use a statistics function to figure out the mean and standard deviation of the counties in the criteria. Your map should look like this
Question 2: Write a multiple criteria query to show the records for counties in ( Wisconsin, Texas, New York, Minnesota, California) where male population is greater than female population and has population of greater then 6500 for seniors over 65. Your query should look like this:
You will repeat the steps from problem one to figure out how many counties were selected, which state had the highest, and which counties were only in Wisconsin. Your map should look like this:
Question 3:
Next create query that will add the state of Washington, Maryland, Illinois, Nebraska, District of Columbia, and Michigan who reside in counties with more then 30000 housing units and includes all seniors citizens. Your query table and map will look like this:
Part 2: Wisconsin
Question 4.
Develop a query that will show cities in Wisconsin with a population between 15000 and 20000in city that is at least 5 square miles in land, and has more females then males and are within 2 miles of a lake. This will tell you how many cities are in the search and their names. You can then do a statistics function to figure out the total population. Your map and query will look like this:
Question 5.
You will make a query that will yield the total length of the following rivers: Chippewa R, Eau Claire R, Embrarrass R, fisher R, Hunting R, Kinnickinnic R, Maunesha R, Milwaukee R, Moose R, Namekagon R, Pelican R, Platte R, and Potato R. This will select all the rivers and then you can perform a statistics tool to find the total length of the rivers. Your query and map will look like this:
