Introduction:
The goal of this lab was to learn how to download and map data from the U.S. Census Bureau. In doing this, I was also introduced to a number of new data tools and file formats.
Methods:
I first navigated to the US Census Bureau website. Here I searched for some data, choosing a total population dataset by county. I downloaded this, extracted it, and inspected the Excel files. I then returned to the US Census Bureau website, and found an available shape file of Wisconsin's counties. I downloaded this and extracted it, and put it on a blank map. I then added the Excel file, and joined it to the counties shape file. This essentially added the content from the Excel file to the counties shape file, based on a common field (that being county ID). I then returned once more to the Census Bureau website and downloaded a sex by age data file, and added it to the map following the same steps as above. I created a new data frame and joined this data to another counties shape file. I placed these two maps side by side, and edited their symbology settings so that I had two maps- one showing population per county, and another showing male population under 5 by county.
Results:
 |
| The pattern for the county population map is logical, as where there are larger metropolitan areas, the population is higher. The darkest county is Milwaukee county, which houses the largest city in the state. On the percent of males under age five map, there is no obvious pattern. However, the counties with lower percentages tended to be towards the North of the state. |
Sources:
http://factfinder2.census.gov/faces/nav/jsf/pages/searchresults.xhtml?refresh=t
No comments:
Post a Comment