430 likes | 618 Views
H-GAC’s BROWN BAG LUNCHEON SERIES September 15, 2011. The 2010 Census and GIS Framework. Dallas Regional Office Jon Barlett, Geographer. 2010 Census GIS Data 2010 Census TIGER/Line Shapefiles Download Harris County Census Tract Shapefile Obtaining 2010 Census Data
E N D
H-GAC’s BROWN BAG LUNCHEON SERIES September 15, 2011 The 2010 Census and GIS Framework Dallas Regional Office Jon Barlett, Geographer
2010 Census GIS Data • 2010 Census TIGER/Line Shapefiles • Download Harris County Census Tract Shapefile • Obtaining 2010 Census Data • 2010 Census data tables • American FactFinder 2 • Download Harris County Census Tract table • Integrating 2010 Census Data with GIS • Harris County Census Tract example Presentation Topics
2010 Census Data Products • 2010 Census Data Products • http://www.census.gov/population/www/cen2010/glance/ • (handout) • Dallas Partnership and Data Services • Questions about data products • Help with American Factfinder • Contact: (214)253-4481
Obtaining 2010 Census Data • Two Methods • Download and process raw data tables • Pros • - Can manage large datasets • - Contains all geographies within one database • Cons • - Large files • - Requires relational database software • - Heavy processing time • American FactFinder • Pros • - Quick query and download • Cons • - Cannot download large datasets (Harris County Census Blocks)
2010 Census Data Tables Census Blocks
2010 Census Data Tables BlockGroups
2010 Census Data Tables Census Tracts
American FactFinder 2 3 – Close 2 – Add 1 – Check
Harris County Tract Example Open the downloaded CSV file in Excel
Harris County Tract Example Delete unnecessary fields and columns Delete red areas
Harris County Tract Example Create meaningful field names
Harris County Tract Example Insert 2 columns after GEOID Fill the first blank column (b in this case) with apostrophes
Harris County Tract Example Calculate the 2nd blank column as the apostrophe (column B) Truncated with the GEOID (column A)
Harris County Tract Example Add meaningful field names and save as an XLS file
Harris County Tract Example Join the Excel file to the shapefile Based on the GEOID and the GEOID_str fields
Thank You! Questions? Dallas Regional Office Partnership and Data 214-253-4481 Dallas Regional Office Geography 214-253-4490 Jon Barlett, Geographer • Jon.M.Barlett@census.gov
Regional Office Transition Dallas Office Closes – January 2013 Denver will take over Texas Stay tuned! Jon Barlett, Geographer • Jon.M.Barlett@census.gov