Spatial Data Catalog

Internal feature number.

Sequential unique whole numbers that are automatically generated.

2010 Census Tract full Geographic Identifier, including US, State and County designators

20 character string such as 1400000US53033031100

2010 Census Tract Geographic Identifier, excluding the US portion, used as the primary key in the join to TRACTS10_AREA identifier

11 character string such as 53033031100

Narrative Census Tract Identifier

Variable length characters string, such as Census Tract 316.06, King County, Washington

E1418 - Total:

0.0 to 1454.0 by 1

M1418 - Total:

2.0 to 563.0 by 1

E1418 - Income in the past 12 months below poverty level:

0.0 to 551.0 by 1

M1418 - Income in the past 12 months below poverty level:

3.0 to 427.0 by 1

E1418 - Income in the past 12 months below poverty level:Under 6 years

0.0 to 247.0 by 1

M1418 - Income in the past 12 months below poverty level:Under 6 years

4.0 to 345.0 by 1

E1418 - Income in the past 12 months below poverty level:6 to 11 years

0.0 to 141.0 by 1

M1418 - Income in the past 12 months below poverty level:6 to 11 years

6.0 to 195.0 by 1

E1418 - Income in the past 12 months below poverty level:12 to 17 years

0.0 to 262.0 by 1

M1418 - Income in the past 12 months below poverty level:12 to 17 years

9.0 to 271.0 by 1

E1418 - Income in the past 12 months below poverty level:18 to 59 years

0.0 to 294.0 by 1

M1418 - Income in the past 12 months below poverty level:18 to 59 years

3.0 to 240.0 by 1

E1418 - Income in the past 12 months below poverty level:60 to 74 years

0.0 to 53.0 by 1

M1418 - Income in the past 12 months below poverty level:60 to 74 years

2.0 to 64.0 by 1

E1418 - Income in the past 12 months below poverty level:75 to 84 years

0.0 to 55.0 by 1

M1418 - Income in the past 12 months below poverty level:75 to 84 years

4.0 to 86.0 by 1

E1418 - Income in the past 12 months below poverty level:85 years and over

0.0 to 20.0 by 1

M1418 - Income in the past 12 months below poverty level:85 years and over

12.0 to 34.0 by 1

E1418 - Income in the past 12 months at or above poverty level:

0.0 to 1454.0 by 1

M1418 - Income in the past 12 months at or above poverty level:

2.0 to 562.0 by 1

E1418 - Income in the past 12 months at or above poverty level:Under 6 years

0.0 to 237.0 by 1

M1418 - Income in the past 12 months at or above poverty level:Under 6 years

5.0 to 242.0 by 1

E1418 - Income in the past 12 months at or above poverty level:6 to 11 years

0.0 to 480.0 by 1

M1418 - Income in the past 12 months at or above poverty level:6 to 11 years

5.0 to 274.0 by 1

E1418 - Income in the past 12 months at or above poverty level:12 to 17 years

0.0 to 293.0 by 1

M1418 - Income in the past 12 months at or above poverty level:12 to 17 years

9.0 to 262.0 by 1

E1418 - Income in the past 12 months at or above poverty level:18 to 59 years

0.0 to 520.0 by 1

M1418 - Income in the past 12 months at or above poverty level:18 to 59 years

2.0 to 323.0 by 1

E1418 - Income in the past 12 months at or above poverty level:60 to 74 years

0.0 to 132.0 by 1

M1418 - Income in the past 12 months at or above poverty level:60 to 74 years

3.0 to 127.0 by 1

E1418 - Income in the past 12 months at or above poverty level:75 to 84 years

0.0 to 52.0 by 1

M1418 - Income in the past 12 months at or above poverty level:75 to 84 years

3.0 to 66.0 by 1

E1418 - Income in the past 12 months at or above poverty level:85 years and over

0.0 to 52.0 by 1

M1418 - Income in the past 12 months at or above poverty level:85 years and over

2.0 to 80.0 by 1

9. Spot-check completed tables against random FactFinder queries: Random spot-checks are executed comparing individual values in selected completed tables against queries generated for the same tract and attribute from the Census ACS website FactFinder.

2. Raw data table content inspected for non-integer values and floating point items: Script: ReviewRawDataContent.py Analyze raw data table and produce report. Inspect raw data tables and remove/modify to eliminate non-integer values.

1. Raw data tables downloaded from Census ACS site: Maintenance plan (in Documentation folder) provides details on how to download and store the extracted files.

8. Create and publish FGDC metadata from Data Dictionary for layer files: Script: BuildACSLYRFileMetadata.py Script is used to query Data Dictionary for attributes to create an FDGC document for each layer file which is then published to the SDW.

7. Create layer files joining tables to Census tracts: From the production data new layer files are created by joining the 2010 Census tract geometry with each table (on GEOID) to create a unique layer file for each table.

6. Final QA, then register and post tables to Spatial Data Warehouse (SDW): Each table is inspected for completness -i.e., all tables have the correct number of rows and columns and each table has completed metadata attached. Each table name is registered with Steward Tool and posted to the SDW. New table names are advertised to users using the GIS Data Digest.

4. Build new tables, import data and QA Data Dictionary to raw data alignment: Script: BuildACSProductionTables.py Script creates gdb table header from Data Dictionary entries, loads from raw data files. Simultaneoulsy, a separate QualityAssement report for each table merges the headers from the Data Dictionary with the headers from the raw data tables. These files are visually inspected to ensure that the sequences from the Data Dictionary have remained the same from the previous ACS cycle, and that the correct data is loaded on the correct table header.

3. Update Data Dictionary as necessary for new tables to be published: Script: UpdateACSDataDictionary.py Corrections or updates to Data Dictionary are made to master xls in Documentation folder, and new records are imported into master Data Dictionary gdb table.

5. Create FGDC metadata from Data Dictionary and import/upgrade to tables: Script: Build ACSTableMetadata.py Script uses the Data Dictionary to build an FGDC document for each table.