RSEI Data Dictionary: Census Crosswalks
The following tables provide descriptions for each field in each table. Note that for the Microdata, "Other Geographies" includes block groups, census tracts, and ZIP code files. For more information, see the RSEI methodology document and the RSEI Microdata documentation.
Each set of crosswalk files links the RSEI grid cell geography to a different US decennial census year. There is one crosswalk for each area and decennial census year for census years 1990, 2000, and 2010. For census year 2020, additional crosswalks for grid cell to block group, census tract and ZIP code are provided, and the fields are slightly different. Crosswalk files are named by area (Alaska, Con(terminous) US, etc.).
The last three fields in each file contain percent values that can be used to adjust the block or cell contents when performing the crosswalk. PCT_B_C and PCT_C_B are area-weighted and can be used for metrics that do not involve population, such as concentration and toxicity-weighted concentration. PCT_PC_B is population weighted, and can be used to crosswalk fields that involve population, like score and pop.
Note that the "PCT_CP_B" field is not available for the territories (VI, PR, GU, AS, MP). The Northern Mariana Islands are in the Guam file and the Virgin Islands are in the Puerto Rico file. There are no crosswalks for Puerto Rico, the Virgin Islands, Mariana Islands, Guam, or American Samoa for 1990. For these areas, RSEI uses 2000 block boundaries and scales each cell’s population by the overall ratio of 1990/2000 population for each area.
Census Crosswalk Table (1990, 2000, 2010) |
||
---|---|---|
Field Number | Name | Description |
1 | Grid | Identifies grid.
|
2 | X | X coordinate of the cell address |
3 | Y | Y coordinate of the cell address |
4 | Block_ID00 | US census block ID |
5 | UR | Internal |
6 | PCT_B_C | Percent of the census block that is within the cell (Block to Cell) |
7 | PCT_C_B | Percent of the cell that is within the census block (Cell to Block) |
8 | PCT_PC_B | Percent of the cell’s population that is within the census block (Population-Cell to Block) |
Census Crosswalk Table (2020) |
||
---|---|---|
Field Number | Name | Description |
1 | Grid | Identifies grid.
|
2 | X | X coordinate of the cell address |
3 | Y | Y coordinate of the cell address |
4 | ID | Identifier (GeoID) for the geographic unit: US census block, block group, tract or ZIP code. |
5 | IntArea | Interaction area of the cell and the census geographic unit (m2). |
6 | PCT_T_C | Percent of the geographic unit that is within the cell (Target to Cell). |
7 | PCT_C_T | Percent of the cell that is within the geographic unit (Cell to Target). |
8 | PCT_CP_T |
Percent of the cell’s total population that is within the geographic unit (Population-Cell to Target). Not available for ZIP codes. |
9 | PCT_CHH_T | Percent of the cell’s total occupied households that is within the geographic unit (Households-Cell to Target). Not available for ZIP codes. |