Additional Resources for Using the 2010 SF 1 Census Data Tables

Project Metadata and Data Dictionaries

SF1_2010 (pdf) 7 mb: Full Census Project discussion and appendices

SF1_2010_DATA_FIELD_DESCRIPTORS (xls) 360 kb: Data Dictionary as provided by Census Bureau

SF1_2010_TableItemRelationship (xls) 4.6 mb: Normalized Data Dictionary based on ‘DATA_FIELD_DESCRIPTORS’. Extended to create more sortable/searchable relationships.

SF1_2010_CROSSWALK (xls) 102 kb: Shows relationship between 2000 Census tables and 2010 Census tables. Also shows relationship between 47 physical tables and 331 logic tables (subject areas). Includes ranking as to whether high priority (thus has a lyr file) or lower priority and posted to SDW only as a table.

SF1_phystabXgeometry (xls) 31 kb: Shows relationship between tables, priority level, and lyr file names for each geography

Project Data Table Import and Processing

SF1_2010_HowToUseMSAccessWithSummaryFile1 (pdf) 1.3 mb: Procedures for importing data tables using Microsoft Access

SF1_2010_GEOID_Construction_for_Matching (pdf) 61 kb: Procedures for creating GEOID for each geography level so tabular data can be joined to census geography layers

SF1_README_SF1_v2 (pdf) 467 kb: Documentation regarding accessing data on FTP site

SF1_wa2010.sf1.prd.packinglist (txt) 8 kb: Contents list for data downloaded from FTP site