1 / 43

The 2010 Census and GIS Framework

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

keelty
Download Presentation

The 2010 Census and GIS Framework

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. H-GAC’s BROWN BAG LUNCHEON SERIES September 15, 2011 The 2010 Census and GIS Framework Dallas Regional Office Jon Barlett, Geographer

  2. 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

  3. 2010 Census TIGER/Line Shapefiles

  4. 2010 Census TIGER/Line Shapefiles

  5. 2010 Census TIGER/Line Shapefiles

  6. 2010 Census TIGER/Line Shapefiles

  7. 2010 Census TIGER/Line Shapefiles

  8. 2010 Census TIGER/Line Shapefiles

  9. 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

  10. 2010 Census Data Products

  11. 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)

  12. 2010 Census Data Tables

  13. 2010 Census Data Tables

  14. 2010 Census Data Tables

  15. 2010 Census Data Tables

  16. 2010 Census Data Tables

  17. 2010 Census Data Tables Census Blocks

  18. 2010 Census Data Tables BlockGroups

  19. 2010 Census Data Tables Census Tracts

  20. American FactFinder 2

  21. American FactFinder 2

  22. American FactFinder 2

  23. American FactFinder 2

  24. American FactFinder 2 3 – Close 2 – Add 1 – Check

  25. American FactFinder 2

  26. American FactFinder 2

  27. American FactFinder 2 1 2

  28. Harris County Tract Example Open the downloaded CSV file in Excel

  29. Harris County Tract Example Delete unnecessary fields and columns Delete red areas

  30. Harris County Tract Example

  31. Harris County Tract Example Create meaningful field names

  32. Harris County Tract Example Insert 2 columns after GEOID Fill the first blank column (b in this case) with apostrophes

  33. Harris County Tract Example Calculate the 2nd blank column as the apostrophe (column B) Truncated with the GEOID (column A)

  34. Harris County Tract Example Add meaningful field names and save as an XLS file

  35. Harris County Tract Example

  36. Harris County Tract Example

  37. Harris County Tract Example Join the Excel file to the shapefile Based on the GEOID and the GEOID_str fields

  38. Harris County Tract Example

  39. Tomball City Block Example

  40. 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

  41. Regional Office Transition Dallas Office Closes – January 2013 Denver will take over Texas Stay tuned! Jon Barlett, Geographer • Jon.M.Barlett@census.gov

More Related