{"id":320,"date":"2016-04-06T15:35:55","date_gmt":"2016-04-06T19:35:55","guid":{"rendered":"http:\/\/pages.vassar.edu\/gis\/?p=320"},"modified":"2016-04-08T14:30:15","modified_gmt":"2016-04-08T18:30:15","slug":"got-demographic-and-socioeconomic-data","status":"publish","type":"post","link":"https:\/\/pages.vassar.edu\/gis\/2016\/04\/06\/got-demographic-and-socioeconomic-data\/","title":{"rendered":"Got demographic and socioeconomic data?"},"content":{"rendered":"<script>fsg_json['fsg_post_320'] = [\n{id: 326, image: 'http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/ACS_Estimates.png', extlink: '', thumb: 'https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/ACS_Estimates-290x290.png', permalink: '<div class=\"galleria-layeritem\"><a title=\"Permalink\" href=\"https:\/\/pages.vassar.edu\/gis\/2016\/04\/06\/got-demographic-and-socioeconomic-data\/acs_estimates\/#0\"><div class=\"galleria-link-bookmark\"><\/div><\/a><\/div>', layer: '<div class=\"galleria-infolayer\"><div class=\"galleria-layeritem\" style=\"padding-right: 20px;\"><h1>ACS_Estimates<\/h1><\/div><div class=\"galleria-layeritem\"><a title=\"Permalink\" href=\"https:\/\/pages.vassar.edu\/gis\/2016\/04\/06\/got-demographic-and-socioeconomic-data\/acs_estimates\/#0\"><div class=\"galleria-link-bookmark\"><\/div><\/a><\/div><div class=\"galleria-layeritem\" style=\"padding-right: 20px;\"><\/div>'},\n{id: 324, image: 'http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/TIGER_Line_with_Demographic_Economic_Data.png', extlink: '', thumb: 'https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/TIGER_Line_with_Demographic_Economic_Data-290x290.png', permalink: '<div class=\"galleria-layeritem\"><a title=\"Permalink\" href=\"https:\/\/pages.vassar.edu\/gis\/2016\/04\/06\/got-demographic-and-socioeconomic-data\/tiger_line_with_demographic_economic_data\/#0\"><div class=\"galleria-link-bookmark\"><\/div><\/a><\/div>', layer: '<div class=\"galleria-infolayer\"><div class=\"galleria-layeritem\" style=\"padding-right: 20px;\"><h1>TIGER_Line_with_Demographic_Economic_Data<\/h1><\/div><div class=\"galleria-layeritem\"><a title=\"Permalink\" href=\"https:\/\/pages.vassar.edu\/gis\/2016\/04\/06\/got-demographic-and-socioeconomic-data\/tiger_line_with_demographic_economic_data\/#0\"><div class=\"galleria-link-bookmark\"><\/div><\/a><\/div><div class=\"galleria-layeritem\" style=\"padding-right: 20px;\"><\/div>'},\n{id: 322, image: 'http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/CensusShapefileTable.png', extlink: '', thumb: 'https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/CensusShapefileTable-290x290.png', permalink: '<div class=\"galleria-layeritem\"><a title=\"Permalink\" href=\"https:\/\/pages.vassar.edu\/gis\/2016\/04\/06\/got-demographic-and-socioeconomic-data\/censusshapefiletable\/#0\"><div class=\"galleria-link-bookmark\"><\/div><\/a><\/div>', layer: '<div class=\"galleria-infolayer\"><div class=\"galleria-layeritem\" style=\"padding-right: 20px;\"><h1>CensusShapefileTable<\/h1><\/div><div class=\"galleria-layeritem\"><a title=\"Permalink\" href=\"https:\/\/pages.vassar.edu\/gis\/2016\/04\/06\/got-demographic-and-socioeconomic-data\/censusshapefiletable\/#0\"><div class=\"galleria-link-bookmark\"><\/div><\/a><\/div><div class=\"galleria-layeritem\" style=\"padding-right: 20px;\"><\/div>'},\n{id: 321, image: 'http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/CensusShapefileColumnDescriptions.png', extlink: '', thumb: 'https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/CensusShapefileColumnDescriptions-290x290.png', permalink: '<div class=\"galleria-layeritem\"><a title=\"Permalink\" href=\"https:\/\/pages.vassar.edu\/gis\/2016\/04\/06\/got-demographic-and-socioeconomic-data\/censusshapefilecolumndescriptions\/#0\"><div class=\"galleria-link-bookmark\"><\/div><\/a><\/div>', layer: '<div class=\"galleria-infolayer\"><div class=\"galleria-layeritem\" style=\"padding-right: 20px;\"><h1>CensusShapefileColumnDescriptions<\/h1><\/div><div class=\"galleria-layeritem\"><a title=\"Permalink\" href=\"https:\/\/pages.vassar.edu\/gis\/2016\/04\/06\/got-demographic-and-socioeconomic-data\/censusshapefilecolumndescriptions\/#0\"><div class=\"galleria-link-bookmark\"><\/div><\/a><\/div><div class=\"galleria-layeritem\" style=\"padding-right: 20px;\"><\/div>'},\n{id: 329, image: 'http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/CatalogACSGeoDB.png', extlink: '', thumb: 'https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/CatalogACSGeoDB-290x290.png', permalink: '<div class=\"galleria-layeritem\"><a title=\"Permalink\" href=\"https:\/\/pages.vassar.edu\/gis\/2016\/04\/06\/got-demographic-and-socioeconomic-data\/catalogacsgeodb\/#0\"><div class=\"galleria-link-bookmark\"><\/div><\/a><\/div>', layer: '<div class=\"galleria-infolayer\"><div class=\"galleria-layeritem\" style=\"padding-right: 20px;\"><h1>CatalogACSGeoDB<\/h1><\/div><div class=\"galleria-layeritem\"><a title=\"Permalink\" href=\"https:\/\/pages.vassar.edu\/gis\/2016\/04\/06\/got-demographic-and-socioeconomic-data\/catalogacsgeodb\/#0\"><div class=\"galleria-link-bookmark\"><\/div><\/a><\/div><div class=\"galleria-layeritem\" style=\"padding-right: 20px;\"><\/div>'},\n{id: 330, image: 'http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/JoinHealthInsuranceTableToBlockGroupLayer.png', extlink: '', thumb: 'https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/JoinHealthInsuranceTableToBlockGroupLayer-290x290.png', permalink: '<div class=\"galleria-layeritem\"><a title=\"Permalink\" href=\"https:\/\/pages.vassar.edu\/gis\/2016\/04\/06\/got-demographic-and-socioeconomic-data\/joinhealthinsurancetabletoblockgrouplayer\/#0\"><div class=\"galleria-link-bookmark\"><\/div><\/a><\/div>', layer: '<div class=\"galleria-infolayer\"><div class=\"galleria-layeritem\" style=\"padding-right: 20px;\"><h1>JoinHealthInsuranceTableToBlockGroupLayer<\/h1><\/div><div class=\"galleria-layeritem\"><a title=\"Permalink\" href=\"https:\/\/pages.vassar.edu\/gis\/2016\/04\/06\/got-demographic-and-socioeconomic-data\/joinhealthinsurancetabletoblockgrouplayer\/#0\"><div class=\"galleria-link-bookmark\"><\/div><\/a><\/div><div class=\"galleria-layeritem\" style=\"padding-right: 20px;\"><\/div>'},\n{id: 328, image: 'http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/BlocksHealthInsuranceJoined.png', extlink: '', thumb: 'https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/BlocksHealthInsuranceJoined-290x290.png', permalink: '<div class=\"galleria-layeritem\"><a title=\"Permalink\" href=\"https:\/\/pages.vassar.edu\/gis\/2016\/04\/06\/got-demographic-and-socioeconomic-data\/blockshealthinsurancejoined\/#0\"><div class=\"galleria-link-bookmark\"><\/div><\/a><\/div>', layer: '<div class=\"galleria-infolayer\"><div class=\"galleria-layeritem\" style=\"padding-right: 20px;\"><h1>BlocksHealthInsuranceJoined<\/h1><\/div><div class=\"galleria-layeritem\"><a title=\"Permalink\" href=\"https:\/\/pages.vassar.edu\/gis\/2016\/04\/06\/got-demographic-and-socioeconomic-data\/blockshealthinsurancejoined\/#0\"><div class=\"galleria-link-bookmark\"><\/div><\/a><\/div><div class=\"galleria-layeritem\" style=\"padding-right: 20px;\"><\/div>'},\n{id: 325, image: 'http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/YouthWithoutHealthInsurance.png', extlink: '', thumb: 'https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/YouthWithoutHealthInsurance-290x281.png', permalink: '<div class=\"galleria-layeritem\"><a title=\"Permalink\" href=\"https:\/\/pages.vassar.edu\/gis\/2016\/04\/06\/got-demographic-and-socioeconomic-data\/youthwithouthealthinsurance\/#0\"><div class=\"galleria-link-bookmark\"><\/div><\/a><\/div>', layer: '<div class=\"galleria-infolayer\"><div class=\"galleria-layeritem\" style=\"padding-right: 20px;\"><h1>YouthWithoutHealthInsurance<\/h1><\/div><div class=\"galleria-layeritem\"><a title=\"Permalink\" href=\"https:\/\/pages.vassar.edu\/gis\/2016\/04\/06\/got-demographic-and-socioeconomic-data\/youthwithouthealthinsurance\/#0\"><div class=\"galleria-link-bookmark\"><\/div><\/a><\/div><div class=\"galleria-layeritem\" style=\"padding-right: 20px;\"><\/div>'}\n];<\/script>\n<p>At this point in the Spring semester students in <a href=\"http:\/\/catalog.vassar.edu\/preview_course_nopop.php?catoid=2&amp;coid=2887\">Geog\/Esci 224: GIS<\/a> begin to ramp-up work on their final projects, and many of them are looking for data related to a topic or question they will be mapping and analyzing in GIS. While there\u2019s a lot of data to be found, getting familiar with it once you have it \u2013 enough to make some useful and interesting maps \u2013 can take some time. Different data providers create and organize their data in different ways, which can be difficult to understand at first. Users should also understand something about the methods used to collect and assemble the data. This may have important implications for how the data could and should be used.<\/p>\n<p>Students often want to work with demographic and socioeconomic data, and one of the richest sources of this type of data (at least, in the US) is the U.S. Census and American Community Survey (ACS) data. The purpose of this article is to provide students with a brief introduction to the U.S. Census and ACS GIS data available, and how and where to get it.<!--more--><\/p>\n<p>Various pieces of information in this post is borrowed from <a href=\"http:\/\/www.pbcgis.com\/census\/\">pbc Goegraphic Information Services<\/a>. Other sources are credited where appropriate. As always, if you need help with this data or any other GIS and mapping help, feel free to contact me at <a href=\"mailto:necurri@vassar.edu\">necurri@vassar.edu<\/a>.<\/p>\n<p><strong>Census data basics<\/strong><\/p>\n<p>The U.S. Census provides information on sex, age, date of birth, race, ethnicity, relationship and housing tenure. The ACS provides more detailed socioeconomic information. In order to protect the confidentiality of individuals, the <a href=\"http:\/\/www.census.gov\/\">U.S. Census Bureau<\/a> releases only summary statistics from the U.S. Census and ACS for geographic areas, such as blocks, block-groups and tracts.<\/p>\n<ul>\n<li><u>Census Blocks<\/u> &#8211; In urban areas, census blocks conform approximately to what we think of as city blocks. At this fine level of geography, the U.S. census only releases a subset of the data short-form questionnaire.<\/li>\n<li><u>Block Groups<\/u> &#8211; These areas are supposed to contain approximately 1200 people, but the actual count of people per block group varies widely. All of the short and long-form data is summarized at the block-group and tract level. \u00a0Between 1970 and 2000, the U.S. Census Bureau used two questionnaires. Most households received the short-form questionnaire asking a minimum number of questions. A sample of households received a long-form questionnaire that included additional questions about the household. The 2010 Census had just one questionnaire consisting of ten questions. (View\u00a0questionnaires from past years\u00a0in the wonderful History section of the U.S. Census Bureau&#8217;s website &gt; through the decades\u00a0&gt; <a href=\"https:\/\/www.census.gov\/history\/www\/through_the_decades\/questionnaires\/\">questionnaires<\/a>.)<\/li>\n<li><u>Tracts<\/u> &#8211; Tracts are larger than block groups.<\/li>\n<\/ul>\n<p>Census and ACS information is also aggregated at the County and State level (though not every statistic is provided at every level). Here\u2019s an illustration from <a href=\"https:\/\/learn.arcgis.com\/en\/concepts\/united-states-census-geography\">Esri <\/a>about the relationship between the geographies at which census and ACS data is aggregated:<\/p>\n<div style=\"width: 589px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/learn.arcgis.com\/en\/concepts\/united-states-census-geography\/\"><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/learn.arcgis.com\/en\/concepts\/united-states-census-geography\/img\/census-geography.png\" alt=\"Census geographies\" width=\"579\" height=\"477\" \/><\/a><p class=\"wp-caption-text\">Census geographies: blocks, block groups, tracts, counties, and states. Source: Esri<\/p><\/div>\n<p>Census and ACS data is also aggregated at other geographies, such as zip code, congressional districts, tribal areas, school districts, and others. You\u2019ll see that later on in the download page (link below). Whether or not you should map or analyze data at these geographies depends on your research question. Consult with your professor or me (<a href=\"mailto:necurri@vassar.edu\">necurri@vassar.edu<\/a>) for guidance if needed.<\/p>\n<p>Previously, the only way to map and analyze Census data in GIS software was to download the TIGER shapefiles for the different geographies at which the data was tabulated (block, block group, county, state\u2026), then navigate the American <a href=\"http:\/\/factfinder.census.gov\/\">Factfinder<\/a> website to find and download the demographic data you want\u00a0in tabular format, then modify the tabular data so that it is ArcMap-friendly and can be joined to the TIGER shapefiles, then join and export the data for your area(s) of interest to new shapefiles or geodatabase feature classes.\u00a0You can still do this if you know exactly the statistic you&#8217;re looking for. This <a href=\"https:\/\/sites.tufts.edu\/gis\/files\/2013\/11\/CensusTutorial_DownloadingAndMappingAmericanFactfinderCensusData_10.3.11.pdf\">excellent tutorial<\/a> from the <a href=\"https:\/\/sites.tufts.edu\/gis\/gis-center\/overview\/\">Tufts Data Lab GIS Center<\/a> will guide you through this process.<\/p>\n<p>However, if you want to just get your hands on some data quickly and start exploring some of the different demographic variables you can map and analyze, there&#8217;s an alternative. Pre-staged data sets are now available\u00a0at various Census geographies (block, block group, tract\u2026 etc.) with much of the demographic data collected in the U.S. Census and ACS. These are provided as GIS data sets with\u00a0\u201cready to join\u201d tables, aggregated at the same geography as the GIS data. The only caveat is that you get almost ALL of the data aggregated at each geography. That\u2019s a LOT of columns to sift through to find what it is you want to map or analyze. But, this is a potentially useful data set to use to explore what demographic and socioeconomic data is available, and to try mapping several different statistics in your study area before deciding on what variables you want to work with.<\/p>\n<p>Before\u00a0jumping head-first into that data, though,\u00a0let\u2019s take a minute to get a little background on the ACS data.<\/p>\n<p><strong>American Community Survey (ACS) basics<\/strong><\/p>\n<p>The <a href=\"http:\/\/www.census.gov\/\">U.S. Bureau of the Census<\/a> has been collecting demographic information since 1790, when it was stipulated by the <a href=\"http:\/\/www.archives.gov\/exhibits\/charters\/constitution_transcript.html\">U.S. constitution<\/a> that information about households be collected every decade from then on. (This is why it is often referred to in the documentation as the Decennial Census.) The most recent census was taken in 2010. Prior censuses were taken in 2000, 1990, 1980, and so on back to the first census in 1790. The information collected in the Decennial Census questionnaire (a.k.a. <a href=\"https:\/\/www.census.gov\/dmd\/www\/pdf\/d61a.pdf\">short form<\/a>) is used to determine allotments of governmental resources, including congressional representatives and education funding. Between the years 1940 and 2000, the U.S. Census Bureau also sent out a longer form questionnaire (a.k.a. <a href=\"https:\/\/www.census.gov\/dmd\/www\/pdf\/d-61b.pdf\">long form<\/a>) to a smaller sample of households (1 in 6). The long form survey collected information such as Income, Occupation, Housing Stock, Rent and Mortgage, Commuting behavior and many others. This long form survey was discontinued for the 2010 census and replaced with the <a href=\"https:\/\/www.census.gov\/programs-surveys\/acs\/\">American Community Survey<\/a>, which is collected every year but with a much smaller sample size.<\/p>\n<p>ACS provides estimates based on 12 months of collected data (1-year estimates), 36 months (3-year estimates), or 60 months (50-year estimates). This sampling method leads to a certain amount of error. In general, the precision of the estimates increases with increasing periods of sample data. The table below outlines the distinguishing features of the 1-year, 3- year, and 5-year ACS estimates, and why you might choose to use one over the other. \u00a0(Note: ACS 3-year estimates have been discontinued, but estimates for previous years will remain available.)<\/p>\n<div id=\"attachment_326\" style=\"width: 842px\" class=\"wp-caption aligncenter\"><a data-postid=\"fsg_post_320\" data-imgid=\"326\" href=\"http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/ACS_Estimates.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-326\" class=\"wp-image-326 size-full\" src=\"http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/ACS_Estimates.png\" alt=\"Distinguishing features of ACS 1-year, 3-year, and 5-year estimates. Source: U.S. Census Bureau\" width=\"832\" height=\"553\" srcset=\"https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/ACS_Estimates.png 832w, https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/ACS_Estimates-300x199.png 300w\" sizes=\"auto, (max-width: 832px) 100vw, 832px\" \/><\/a><p id=\"caption-attachment-326\" class=\"wp-caption-text\">Distinguishing features of ACS 1-year, 3-year, and 5-year estimates. Source: <a href=\"https:\/\/www.census.gov\/programs-surveys\/acs\/guidance\/estimates.html\">U.S. Census Bureau<\/a><\/p><\/div>\n<p><strong>How to get the data<\/strong><\/p>\n<p>The pre-staged\u00a0data sets\u00a0are available on this page of Census website: <a href=\"https:\/\/www.census.gov\/geo\/maps-data\/data\/tiger-data.html\">TIGER\/Line with Selected Demographic and Economic Data<\/a>.\u00a0 Note that the ACS data is provided separately from the Census data. Note also that only 5-year ACS data is provided, and only in geodatabase format. If you want 1 or 3-year ACS data, you\u2019ll have to do it the other way (see the aforementioned <a href=\"https:\/\/sites.tufts.edu\/gis\/files\/2013\/11\/CensusTutorial_DownloadingAndMappingAmericanFactfinderCensusData_10.3.11.pdf\">Tufts tutorial<\/a>).\u00a0The Census data is provided in either shapefile or geodatabase format.<\/p>\n<div id=\"attachment_324\" style=\"width: 710px\" class=\"wp-caption aligncenter\"><a data-postid=\"fsg_post_320\" data-imgid=\"324\" href=\"http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/TIGER_Line_with_Demographic_Economic_Data.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-324\" class=\"wp-image-324 size-full\" src=\"http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/TIGER_Line_with_Demographic_Economic_Data.png\" alt=\"TIGER_Line_with_Demographic_Economic_Data\" width=\"700\" height=\"561\" srcset=\"https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/TIGER_Line_with_Demographic_Economic_Data.png 700w, https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/TIGER_Line_with_Demographic_Economic_Data-300x240.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><p id=\"caption-attachment-324\" class=\"wp-caption-text\"><a href=\"https:\/\/www.census.gov\/geo\/maps-data\/data\/tiger-data.html\">Download page<\/a>: TIGER\/Line with Selected Demographic and Economic Data<\/p><\/div>\n<p>Here\u2019s a brief overview of the datasets available:<\/p>\n<p><u>2010 Census<\/u><\/p>\n<p><em>Population &amp; Housing Unit Counts<\/em> \u2013 Provided at the block level geography as state-wide datasets. This is the most basic data to look at: a simple tally of the number of individuals and households in each block.<\/p>\n<p><em>Demographic Profile 1<\/em> (shapefile or geodatabase format) \u2013 Provides more detailed information, and is available at various geographies.\u00a0 After downloading and viewing the data in ArcMap or ArcCatalog, you\u2019ll notice the attribute column names are a little cryptic. Here\u2019s a look at the county-level shapefile attribute table. (I\u2019ve hidden some of the columns and can only show a few within the space of a screenshot.)<\/p>\n<p><a data-postid=\"fsg_post_320\" data-imgid=\"322\" href=\"http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/CensusShapefileTable.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-322 size-full\" src=\"http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/CensusShapefileTable.png\" alt=\"CensusShapefileTable\" width=\"659\" height=\"356\" srcset=\"https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/CensusShapefileTable.png 659w, https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/CensusShapefileTable-300x162.png 300w\" sizes=\"auto, (max-width: 659px) 100vw, 659px\" \/><\/a><\/p>\n<p>The demographic data columns start at DP0010001 and continue to the right. An Excel table is provided along with each downloaded shapefile, which provides descriptions for each column name. For example, the column \u201cDP0010023\u201d contains the number of males from 10 to 14 years old:<\/p>\n<p><a data-postid=\"fsg_post_320\" data-imgid=\"321\" href=\"http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/CensusShapefileColumnDescriptions.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-321 aligncenter\" src=\"http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/CensusShapefileColumnDescriptions-189x300.png\" alt=\"CensusShapefileColumnDescriptions\" width=\"189\" height=\"300\" srcset=\"https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/CensusShapefileColumnDescriptions-189x300.png 189w, https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/CensusShapefileColumnDescriptions.png 298w\" sizes=\"auto, (max-width: 189px) 100vw, 189px\" \/><\/a><\/p>\n<p><u>American Community Survey 5-Year Estimates <\/u><\/p>\n<p><em>Detailed Tables<\/em> (2008-2012, 2009-2013, 2010-2014) &#8211;\u00a0 Data can be downloaded for several different geographies, but probably the most useful to you will be the Block Group, Census Tract, or County geographies by state. After downloading the data, view the contents of the geodatabase in the ArcCatalog (or the Catalog window in ArcMap) and note that it contains a feature class and several tables. This is a look at the geodatabase I downloaded containing the ACS 2014 5-year \u00a0estimates (under \u201cDetailed Tables\u201d) at the block group level for New York State:<\/p>\n<p><a data-postid=\"fsg_post_320\" data-imgid=\"329\" href=\"http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/CatalogACSGeoDB.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-329 size-full\" src=\"http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/CatalogACSGeoDB.png\" alt=\"CatalogACSGeoDB\" width=\"331\" height=\"514\" srcset=\"https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/CatalogACSGeoDB.png 331w, https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/CatalogACSGeoDB-193x300.png 193w\" sizes=\"auto, (max-width: 331px) 100vw, 331px\" \/><\/a><\/p>\n<p>The tables contain the demographic and socioeconomic data, which can be joined to the feature class in ArcMap on the GEOID_Data column in the feature class and the GEOID field in any of the tables. Again, like the Demographic Profile 1 data, you\u2019ll notice that the field names are a little cryptic. A key with descriptions for all the columns is provided in the BG_METADATA_2014 table.<\/p>\n<p><em>Block Group Data<\/em> (2006-2010, 2007-2011) \u2013 Detailed block group level data provided by state. The data is structured similarly to the Detailed Tables above.<\/p>\n<p><em>Data Profiles<\/em> (2006-2010, 2007-2011) \u2013 These data sets contain selected social, economic, housing, and demographic\u00a0 characteristics and are available only at the County, Census, and Metropolitan and Micropolitan Statistical Areas geographies.<\/p>\n<p><strong>Mapping the data<\/strong><\/p>\n<p>You still have to join the tables in the geodatabases provided to the feature class layers, but at least it\u2019s all there for you in one dataset. You don\u2019t have to navigate the <a href=\"http:\/\/factfinder.census.gov\/\">American Factfinder<\/a>, and there\u2019s no table manipulation needed to join the data. Just add the feature class to your ArcMap layout, and then perform the table join.<\/p>\n<p><u>Joining the statistical tables to the feature class <\/u><\/p>\n<p>Make sure you join with the GEOID_Data column in the feature class attribute table on the GEOID column in any of the statistical tables. Here, I\u2019m joining the Health Insurance statistics table to the feature class from the geodatabase I downloaded containing the ACS 2014 5-year \u00a0estimates (under \u201cDetailed Tables\u201d) at the block group level for New York State.<\/p>\n<p><a data-postid=\"fsg_post_320\" data-imgid=\"330\" href=\"http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/JoinHealthInsuranceTableToBlockGroupLayer.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-330 size-full\" src=\"http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/JoinHealthInsuranceTableToBlockGroupLayer.png\" alt=\"JoinHealthInsuranceTableToBlockGroupLayer\" width=\"416\" height=\"603\" srcset=\"https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/JoinHealthInsuranceTableToBlockGroupLayer.png 416w, https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/JoinHealthInsuranceTableToBlockGroupLayer-207x300.png 207w\" sizes=\"auto, (max-width: 416px) 100vw, 416px\" \/><\/a><\/p>\n<p><u>Finding a column to map <\/u><\/p>\n<p>With the X27_HEALTH_INSURANCE table joined to the blocks layer, I could then see all the health insurance statistics in the attribute table.\u00a0Exploring the table, I found that all the column names began with B27010\u2026<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-328 size-full\" src=\"http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/BlocksHealthInsuranceJoined.png\" alt=\"BlocksHealthInsuranceJoined\" width=\"843\" height=\"339\" srcset=\"https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/BlocksHealthInsuranceJoined.png 843w, https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/BlocksHealthInsuranceJoined-300x121.png 300w\" sizes=\"auto, (max-width: 843px) 100vw, 843px\" \/><\/p>\n<p>A look at the BG_METADATA_2014 table in the geodatabase confirmed that all the statistics in this table are related to health insurance coverage.<\/p>\n<p><a data-postid=\"fsg_post_320\" data-imgid=\"328\" href=\"http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/BlocksHealthInsuranceJoined.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-327 size-full\" src=\"http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/BG_Metadata_2014_table.png\" alt=\"BG_Metadata_2014_table\" width=\"843\" height=\"339\" srcset=\"https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/BG_Metadata_2014_table.png 843w, https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/BG_Metadata_2014_table-300x121.png 300w\" sizes=\"auto, (max-width: 843px) 100vw, 843px\" \/><\/a>Seeing that data included health insurance coverage statistics by age group, I decided I wanted to map the proportion of youth\u00a0(population &lt; 18 years old) without health insurance. To do so, I had to <em>normalize<\/em> the data \u2013 i.e., divide the number of youth without health insurance (column \u2018B27010e17\u2019) by the total number of youth (column \u2018B27010e2\u2019). The BG_METADATA_2014 table provides the descriptions for these two fields:<\/p>\n<ul>\n<li>B27010e17: <em>TYPES OF HEALTH INSURANCE COVERAGE BY AGE: Under 18 years: No health insurance coverage: Civilian noninstitutionalized population &#8212; (Estimate)<\/em><\/li>\n<li>B27010e2: <em>TYPES OF HEALTH INSURANCE COVERAGE BY AGE: Under 18 years: Civilian noninstitutionalized population &#8212; (Estimate)<\/em><\/li>\n<\/ul>\n<p>If you took Geog\/Esci 220: Cartography, recall that when mapping quantities represented by shaded polygons of different sizes, it is appropriate to base the shading on fractions or proportions\/percentages of a population rather than total values. \u00a0There\u2019s two ways to do this:<\/p>\n<ol>\n<li>Use the Symbology tab in the layer properties to select &#8216;B27010e17&#8217; as the Value and select \u2018B27010e2\u2019 as the Normalization data.<\/li>\n<li>Add a new column to hold the proportional or percentage values, then populate the column using the <a href=\"http:\/\/desktop.arcgis.com\/en\/arcmap\/10.3\/manage-data\/tables\/making-field-calculations-making-simple-field-calc.htm\">Field Calculator<\/a>.<\/li>\n<\/ol>\n<p style=\"text-align: left\">I chose the second method. So, I created a new floating point decimal field called PercYouthUninsured and used the Field Calculator to calculate the proportion of uninsured youth by dividing the two columns: B27010e17\/ B27010e2 (then multiplying the product by 100 so that the proportion of youth without health insurance was expressed as a percentage).<\/p>\n<p>I then used the PercYouthUninsured column to symbolize the quantities. Here&#8217;s what it looked like, zoomed in to the mid-Hudson Valley region:<\/p>\n<p><a data-postid=\"fsg_post_320\" data-imgid=\"325\" href=\"http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/YouthWithoutHealthInsurance.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-325 size-full\" src=\"http:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/YouthWithoutHealthInsurance.png\" alt=\"YouthWithoutHealthInsurance\" width=\"467\" height=\"281\" srcset=\"https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/YouthWithoutHealthInsurance.png 467w, https:\/\/pages.vassar.edu\/gis\/files\/2016\/04\/YouthWithoutHealthInsurance-300x181.png 300w\" sizes=\"auto, (max-width: 467px) 100vw, 467px\" \/><\/a><\/p>\n<p><strong>A final note on \u201cmargin of error\u201d<\/strong><\/p>\n<p>It was mentioned earlier in this post that the statistics tabulated in the ACS are estimates based on a sample, not the entire population, and that this method produces some error. Notice in the statistical tables in any of the ACS statistical tables\u00a0provided in these data sets that\u00a0the columns are paired \u2013 i.e., for each statistic there is an \u201cestimate\u201d of the value for that variable, and a \u201cmargin of error\u201d number provided as well.<\/p>\n<p>In the example above, the column B27010e17 is the estimate and the column B27010m17 is the margin of error. (Note the \u201ce\u201d for &#8220;estimate&#8221; and \u201cm\u201d for &#8220;margin of error&#8221; in the column name.) The error can be quite large in some cases. For example, in the block group just north of Vassar\u2019s main campus the total estimated youth (&lt;18) without health insurance is 26 and the margin of error is 41. ACS estimates should therefore be taken with a grain of salt\u2026 how much of a grain of salt is something I will research and attempt to\u00a0answer in a subsequent post.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>At this point in the Spring semester students in Geog\/Esci 224: GIS begin to ramp-up work on their final projects, and many of them are looking for data related to a topic or question they will be mapping and analyzing &hellip; <a href=\"https:\/\/pages.vassar.edu\/gis\/2016\/04\/06\/got-demographic-and-socioeconomic-data\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":5039,"featured_media":326,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-320","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/pages.vassar.edu\/gis\/wp-json\/wp\/v2\/posts\/320","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pages.vassar.edu\/gis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pages.vassar.edu\/gis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pages.vassar.edu\/gis\/wp-json\/wp\/v2\/users\/5039"}],"replies":[{"embeddable":true,"href":"https:\/\/pages.vassar.edu\/gis\/wp-json\/wp\/v2\/comments?post=320"}],"version-history":[{"count":6,"href":"https:\/\/pages.vassar.edu\/gis\/wp-json\/wp\/v2\/posts\/320\/revisions"}],"predecessor-version":[{"id":337,"href":"https:\/\/pages.vassar.edu\/gis\/wp-json\/wp\/v2\/posts\/320\/revisions\/337"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pages.vassar.edu\/gis\/wp-json\/wp\/v2\/media\/326"}],"wp:attachment":[{"href":"https:\/\/pages.vassar.edu\/gis\/wp-json\/wp\/v2\/media?parent=320"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pages.vassar.edu\/gis\/wp-json\/wp\/v2\/categories?post=320"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pages.vassar.edu\/gis\/wp-json\/wp\/v2\/tags?post=320"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}