{"id":58,"date":"2013-01-16T17:26:53","date_gmt":"2013-01-16T17:26:53","guid":{"rendered":"http:\/\/doozer\/wordpress\/?page_id=58"},"modified":"2019-02-12T18:15:28","modified_gmt":"2019-02-12T23:15:28","slug":"census-data","status":"publish","type":"page","link":"https:\/\/jniemuth.hubns.net\/gis520\/census-data\/","title":{"rendered":"Working with US Census Data"},"content":{"rendered":"<p><strong>Problem:<\/strong> Create a thematic map using an attribute from the US census data for any geographic area.<\/p>\n<ul>\n<li><strong> Table &amp; attribute utilized:<\/strong>\n<ul>\n<li><a title=\"Average Household Size by Age - NY County, NY\" href=\"http:\/\/factfinder2.census.gov\/faces\/tableservices\/jsf\/pages\/productview.xhtml?pid=DEC_10_SF2_PCT7&amp;prodType=table\" target=\"_blank\" rel=\"noopener\">DEC_10_SF2_PCT7_with_ann<\/a>: PCT7, Average household size by age\n<ul>\n<li>New York County, NY<\/li>\n<\/ul>\n<\/li>\n<li>D002: Average household size, total<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>Analysis Procedures: <\/strong>US Census data is freely available to the public and can be used to create thematic maps for any area of the country (Fig. 1).\u00a0 Tabular data from the <a title=\"American Fact Finder\" href=\"http:\/\/factfinder2.census.gov\/faces\/nav\/jsf\/pages\/index.xhtml\" target=\"_blank\" rel=\"noopener\">American Fact Finder website<\/a> is selected by choosing the necessary dataset (e.g. 2010 census), geographic area (e.g. state, county, city, etc.), and topic of interest (e.g. education, income, ethnicity, etc.).\u00a0 Once this data is downloaded, the corresponding <a title=\"2010 Tiger\/Line Shapefiles\" href=\"http:\/\/www.census.gov\/cgi-bin\/geo\/shapefiles2010\/main\" target=\"_blank\" rel=\"noopener\">Tiger\/Line\u00ae shapefile<\/a> must be obtained from the US Census Bureau.\u00a0 The tabular data must be edited so that the headings are unique and descriptive and also so the unique ID (e.g. census tract number) matches the formatting found in the corresponding field in the shapefile.\u00a0 After the tabular data has been edited it can be joined to the shapefile using the unique ID.\u00a0 Finally, the symbology is adjusted and a thematic map created.\u00a0 A procedure log for this exercise is available <a title=\"Procedure Log\" href=\"http:\/\/jniemuth.hubns.net\/gis520\/files\/2013\/02\/Procedure-Log1.pdf\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<div id=\"attachment_264\" class=\"wp-caption aligncenter\" style=\"width: 920px\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-264\" src=\"http:\/\/jniemuth.hubns.net\/gis520\/files\/2013\/02\/Diagram1.png\" alt=\"General workflow diagram\" width=\"910\" height=\"469\" srcset=\"https:\/\/jniemuth.hubns.net\/gis520\/files\/2013\/02\/Diagram1.png 910w, https:\/\/jniemuth.hubns.net\/gis520\/files\/2013\/02\/Diagram1-300x154.png 300w, https:\/\/jniemuth.hubns.net\/gis520\/files\/2013\/02\/Diagram1-500x257.png 500w\" sizes=\"auto, (max-width: 910px) 100vw, 910px\" \/><p class=\"wp-caption-text\">Figure 1. General workflow diagram for obtaining and joining US Census data to create a thematic map in ArcMap.<\/p><\/div>\n<p><strong>Results:<\/strong><\/p>\n<div id=\"attachment_261\" class=\"wp-caption aligncenter\" style=\"width: 1285px\"><a href=\"http:\/\/jniemuth.hubns.net\/gis520\/files\/2013\/03\/niemuth_j_assignment7rev.jpg\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-261 \" src=\"http:\/\/jniemuth.hubns.net\/gis520\/files\/2013\/03\/niemuth_j_assignment7rev.jpg\" alt=\"Average total household size in Manhattan\" width=\"1275\" height=\"1650\" \/><\/a><p class=\"wp-caption-text\">Figure 2. Average total household size in New York County, NY (Manhattan) by census tract from the 2010 census. Click on map for enlarged image.<\/p><\/div>\n<p><strong>Application and Reflection:<\/strong> The skills and concepts from this exercise could be used in a wide variety of applications. Income or education status could be used to help direct efforts to obtain support or funds for the projects of a university, museum, etc. The ratio of vacant to occupied housing units may be useful for planning a new park or nature area.<\/p>\n<p>The US Census Bureau also collects an immense range of information beyond the decennial census. Specifically with regards to wildlife, there is a <a title=\"National Survey of Fishing, Hunting, and Wildlife-Associated Recreation (FHWAR)\" href=\"http:\/\/www.census.gov\/prod\/www\/abs\/fishing.html\" target=\"_blank\" rel=\"noopener\">National Survey of Fishing, Hunting, and Wildlife-Associated Recreation<\/a>. This includes activities such as observation, photography, and feeding and could be used to direct zoonotic disease education efforts. There is also data regarding trips and related expenses, which could be important when arguing legislation that impacts tourism and recreational uses of wildlife.<\/p>\n<p>In North Carolina, the Game Fish Bill (<a title=\"House Bill 353\" href=\"http:\/\/www.ncga.state.nc.us\/sessions\/2011\/bills\/house\/html\/h353v1.html\" target=\"_blank\" rel=\"noopener\">NC House Bill 353<\/a>) has sparked controversy for many reasons, one being the argument that designating certain species as game fish (i.e. no commercial fishing) would provide greater economic benefit for the state through tourism related expenses. To learn more, please view the interview below with Dr. Louis Daniels of the <a title=\"NC Division of Marine Fisheries\" href=\"http:\/\/portal.ncdenr.org\/web\/mf\/\" target=\"_blank\" rel=\"noopener\">NC Division of Marine Fisheries<\/a>.<\/p>\n<p>https:\/\/youtu.be\/VFeqLe4IgEs<\/p>\n<div class=\"alignleft\"><a href=\"https:\/\/jniemuth.hubns.net\/gis520\/data-cardinality-issues-in-arcgis\/\" title=\"Database Cardinality Issues in ArcGIS\">< Previous<\/a><\/div><div class=\"alignright\"><a href=\"https:\/\/jniemuth.hubns.net\/gis520\/linear-referencing\/\" title=\"Linear Referencing\">Next ><\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Problem: Create a thematic map using an attribute from the US census data for any geographic area. Table &amp; attribute utilized: DEC_10_SF2_PCT7_with_ann: PCT7, Average household size by age New York County, NY D002: Average household size, total Analysis Procedures: US &hellip; <a href=\"https:\/\/jniemuth.hubns.net\/gis520\/census-data\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":262,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"folder":[],"class_list":["post-58","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/jniemuth.hubns.net\/gis520\/wp-json\/wp\/v2\/pages\/58","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jniemuth.hubns.net\/gis520\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/jniemuth.hubns.net\/gis520\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/jniemuth.hubns.net\/gis520\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jniemuth.hubns.net\/gis520\/wp-json\/wp\/v2\/comments?post=58"}],"version-history":[{"count":8,"href":"https:\/\/jniemuth.hubns.net\/gis520\/wp-json\/wp\/v2\/pages\/58\/revisions"}],"predecessor-version":[{"id":560,"href":"https:\/\/jniemuth.hubns.net\/gis520\/wp-json\/wp\/v2\/pages\/58\/revisions\/560"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jniemuth.hubns.net\/gis520\/wp-json\/wp\/v2\/media\/262"}],"wp:attachment":[{"href":"https:\/\/jniemuth.hubns.net\/gis520\/wp-json\/wp\/v2\/media?parent=58"}],"wp:term":[{"taxonomy":"folder","embeddable":true,"href":"https:\/\/jniemuth.hubns.net\/gis520\/wp-json\/wp\/v2\/folder?post=58"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}