U.S. Census Grids

1. The 2000 SF1 files for each state are loaded into Microsoft Access and queries are used to extract the records pertaining to census blocks and the fields being used for gridding.<BR> 2. The SF1 fields are combined as specified in the variable documentation to create the variables being gridded. 3. The SF1 variables are joined to the tiger coverages and the census blocks in a given metropolitan statistical area are selected. The density of each variable is calculated for each census block. 4. A 30 arc-second fishnet is created and unioned with the census block coverage. 5. The area in square kilometers is calculated for each area of intersection. The total count for each variable is calculated by multiplying the area in square kilometers in each area of intersection by the density of that variable in the underlying census block. 6. The total count for each grid cell is calculated by aggregating the variable counts for each area of intersection that falls within that grid cell. 7. The fishnet grid for each variable is converted to raster format.

Age, under 1 year

U.S. Census 2000, summary file 1, table P14, sum of fields P014003 and P014024

Age, 1 to 4 years

U.S. Census 2000, summary file 1, table P14, sum of fields P014004, P014005, P014006, P014007, P014025, P014026, P014027, P014028

Age, 5 to 17 years

U.S. Census 2000, summary file 1, table P12, sum of fields P012004, P012005, P012006, P012028, P012029, P012030

Age, 18 to 24 years

U.S. Census 2000, summary file 1, table P12, sum of fields P012007, P012008, P012009, P012010, P012031, P012032, P012033, P012034

Age, 25 to 64 years

U.S. Census 2000, summary file 1, table P12, sum of fields P012011, P012012, P012013, P012014, P012015, P012016, P012017, P012018, P012019, P012035, P012036, P012037, P012038, P012039, P012040, P012041, P012042, P012043

Age, 65 to 79 years

U.S. Census 2000, summary file 1, table P12, sum of fields P012020, P012021, P012022, P012023, P012044, P012045, P012046, P012047

Age, 80 years and over

U.S. Census 2000, summary file 1, table P12, sum of fields P012024, P012025, P012048, P012049

Race, American Indian and Alaska Native alone

U.S. Census 2000, summary file 1, table P7, field P007004

Area of the grid cell in square meters

Race, Asian alone

U.S. Census 2000, summary file 1, table P7, field P007005

Race, Black or African American alone

U.S. Census 2000, summary file 1, table P7, field P007003

2 or more person households: Female householder, no husband, with own children under 18 years

U.S. Census 2000, summary file 1, table P18, field P018015

Households

U.S. Census 2000, summary file 1, table P15, field P015001

Population in households

U.S. Census 2000, summary file 1, table P16, field P016001

Hispanic or Latino

U.S. Census 2000, summary file 1, table P8, field P008010

Housing units

U.S. Census 2000, summary file 1, table geo, field hu100

Occupied housing units: 1-person household

U.S. Census 2000, summary file 1, table H13, field H013002

Not Hispanic or Latino, Black or African American alone

U.S. Census 2000, summary file 1, table P8, field P008004

Not Hispanic or Latino, White alone

U.S. Census 2000, summary file 1, table P8, field P008003

Occupied housing units

U.S. Census 2000, summary file 1, table H4, field H004001

Occupied housing units: owner occupied

U.S. Census 2000, summary file 1, table H4, field H004002

Race, Native Hawaiian and Other Pacific Islander alone

U.S. Census 2000, summary file 1, table P7, field P007006

Population

U.S. Census 2000, summary file 1, table geo, field pop100

Vacant housing units: For seasonal, recreational, or occasional use

U.S. Census 2000, summary file 1, table H5, field H005005

Race, White alone

U.S. Census 2000, summary file 1, table P7, field P007002