Lab 4 Multiple Criteria Query

Goal and Background
The primary goal of this lab was to familiarize oneself with the use of multiple criteria query equations. Using this knowledge of query equations to properly extract components of data from a database and show understanding of attribute and spatial queries.
Methods
Each of the different questions asked throughout the lab started with the same basic process, breaking apart the question into its different aspects to then be turned into a query.
Results
Question 1 Results

Question 2 Results

Question 3 Results



Question 4 Results

Question 5 Results

Sources
ESRI Data and Maps [Download]. (2013) Redlands, CA: ESRI [October, 2014].
UWEC Lab 4 Part 2 Data

Lab 3 Static and Dynamic Mapping

Goal and Background
The main goal of this lab was to explore the options for finding GIS data, downloading the data, mapping the data and then analysis. With this data I also was able to create two static maps displaying different data for Wisconsin and one dynamic map also displaying data for Wisconsin.
Methods

1. I started out with exploring the Factfinder website of the U.S. Census and learning the ins and outs of its functions and data.
2. Once i found the data and the shapefile needed for my first map i downloaded it and then converted it in Excel so that i would be able to join the tables together in ArcMap.
3. I then joined the data to create a new shapefile with both spatial data and the data needed to show the population of Wisconsin by County.
4. Finally i then mapped the data and added all the extra fixings to create an aesthetically pleasing display. See map #1 below in the Results section.
5. For the second map is was the same basic steps except this time the data i downloaded was for renter occupied housing in Wisconsin. See map #2 below in the Results section.

Results
Map #1 Wisconsin Population
This map displays the population of Wisconsin via county.

Map #2 Wisconsin Renter Occupied Housing
This map displays the amount of renter occupied housing per county in Wisconsin.

Sources
ESRI Data and Maps [Download]. (2013) Redlands, CA: ESRI [October, 2014]
U.S. Census Bureau, 2010 Census

Lab 1 Coordinate Systems

Goal and Background
The goal of this lab is to evaluate the understanding and use of geographic coordinate systems and projected coordinate systems and the ability to apply these skills. Another goal is also the ability to troubleshoot issues involving coordinate systems, fix these issues and then create aesthetically pleasing maps.
Methods

1. I started with creating the five data frames i would need for the world projections.
2. Once i had the data frames i added the country shapefile and the geogrid shapefile to these five individual data frames.
3. I then proceeded to assign each of these five data frames a different coordinate system based on the given instruction and the last one being the projection of my choosing.
4. These five coordinate systems were: WGS_1984, Mercator Projection, Sinusoidal Projection, Equidistant Conic Projection, and the one of my choosing Azimuthal Equidistant Projection.
5. After this i added another data frame and then worked on setting up the Wisconsin UTM map by exporting the data from the States shapefile.
6. Once i had the data exported in the set the Wisconsin shapefile to UTM, NAD 1983 Zone 16N projected coordinate system.
7. The final data frame i added was for the states shapefile with a Michigan Roads overlay.
8. First i added the states and stroads_miv5a shapefiles and observed how ArcMap did an "On the Fly Projection".
9. After this i then had to designate the stroads_miv5a shapefile's projection by using the Project Tool from the ArcToolbox.
10. Once i had the new projected data i imported it into the map and removed the old stroads_miv5a shapefile and set the data frame to North American Lambert Conformal Conic projection.
11. The final part for the first map was going through and adjusting the data frames to create a more aesthetically pleasing final product. This took adjusting the sizes of the data frames, labeling them, adding North Arrows where they applied, titling the product and adding in a neat line.
12. The finished Map One can be viewed below in the results section titled Geographic Information Systems Lab 1 Coordinate Systems Examples.
13. The second map made for this lab involved fixing issues related to coordinate systems.
14. I started out by assigning the Central_WI_Cts shapefile the proper projection based on the metadata provided. NAD_1983_StatePlane_Wisconsin_Central_FIPS_4802 was the proper projection needed.
15. I also had to overlay the Central_WI_rvs shapefile which showed the many rivers running through these selected central Wisconsin counties. 
16. This shapefile did not have the proper projection and required me to assign it the same projection that I had previously assigned to the Central WI Cts shapefile. This fixed the overlay problem.
17. Finally i added county labels and gave them a 2 point Halo around them, added in a North Arrow, created a legend for the rivers and titled the final product. This can be viewed below in the results section as Central Wisconsin Rivers.

Results

Sources
 Michigan Department of Transportation
 Price, M. H. (2012). Mastering ArcGIS. Dubuque, IA: McGraw-Hill.