2020 Urban Area (UA) Relationship File Record Layouts
2020 Urban Area (UA) Relationship File Record Layouts
Record layouts on this page:
- 2020 118th Congressional District to 2020 Urban Area Relationship File Layout (tab20_cd11820_ua20_natl.txt, tab20_cd11820_ua20_st<##>.txt)
- 2020 State Legislative District-Lower Chamber (SLDL) to 2020 Urban Area relationship file layout (tab20_sldl202220_ua20_natl.txt, tab20_sldl20_ua20_st<##>.txt)
- 2020 State Legislative District-Upper Chamber (SLDU) to 2020 Urban Area relationship file layout (tab20_sldu202220_ua20_natl.txt, tab20_sldu20_ua20_st<##>.txt)
- 2010 Urban Area to 2020 Urban Area relationship file layout (tab20_ua10_ua20_natl.txt)
- 2020 Urban Area to 2020 County relationship file layout (tab20_ua20_county20_natl.txt)
- 2020 Urban Area to 2020 County Subdivision relationship file layout (tab20_ua20_cousub20_natl.txt)
- 2020 Urban Area to 2020 Place relationship file layout (tab20_ua20_place20_natl.txt)
- 2020 Urban Area to 2020 ZIP Code Tabulation Area (ZCTA) relationship file layout (tab20_ua20_zcta520_natl.txt)
2020 118th Congressional District to 2020 Urban Area Relationship File layout (tab20_cd11820_ua20_natl.txt, tab20_cd11820_ua20_st<##>.txt)
| Column name |
Maximum length | Column definition |
|---|---|---|
| OID_CD118_20 | 22 | OID of 2020 CD118 |
| GEOID_CD118_20 | 4 | GEOID of the 2020 CD118 |
| NAMELSAD_CD118_20 | 100 | Name with translated Legal/Statistical Area Description of 2020 CD118 |
| AREALAND_CD118_20 | 14 | Total land area of 2020 CD118 in square meters |
| AREAWATER_CD118_20 | 14 | Total water area of 2020 CD118 in square meters |
| MTFCC_CD118_20 | 5 | MAFTIGER feature class code of 2020 CD118 |
| FUNCSTAT_CD118_20 | 1 | Functional status of 2020 CD118 |
| OID_UA_20 | 22 | OID of 2020 UA |
| GEOID_UA_20 | 5 | GEOID of the 2020 UA |
| NAMELSAD_UA_20 | 100 | Name with translated Legal/Statistical Area Description of 2020 UA |
| AREALAND_UA_20 | 14 | Land area of 2020 UA in square meters |
| AREAWATER_UA_20 | 14 | Water area of 2020 UA in square meters |
| MTFCC_UA_20 | 5 | MAFTIGER feature class code of 2020 UA |
| FUNCSTAT_UA_20 | 1 | Functional status of 2020 UA |
| AREALAND_PART | 14 | Calculated land area of the overlapping part in square meters |
| AREAWATER_PART | 14 | Calculated water area of the overlapping part in square meters |
2020 State Legislative District-Lower Chamber (SLDL) to 2020 Urban Area Relationship File layout (tab20_sldl202220_ua20_natl.txt, tab20_sldl20_ua20_st<##>.txt )
| Column name |
Maximum length | Column definition |
|---|---|---|
| OID_SLDL2022_20 | 22 | OID of 2020 SLDL |
| GEOID_SLDL2022_20 | 5 | GEOID of the 2020 SLDL |
| NAMELSAD_SLDL2022_20 | 100 | Name with translated Legal/Statistical Area Description of 2020 SLDL |
| AREALAND_SLDL2022_20 | 14 | Total land area of 2020 SLDL in square meters |
| AREAWATER_SLDL2022_20 | 14 | Total water area of 2020 SLDL in square meters |
| MTFCC_SLDL2022_20 | 5 | MAFTIGER feature class code of 2020 SLDL |
| FUNCSTAT_SLDL2022_20 | 1 | Functional status of 2020 SLDL |
| OID_UA_20 | 22 | OID of 2020 UA |
| GEOID_UA_20 | 5 | GEOID of the 2020 UA |
| NAMELSAD_UA_20 | 100 | Name with translated Legal/Statistical Area Description of 2020 UA |
| AREALAND_UA_20 | 14 | Land area of 2020 UA in square meters |
| AREAWATER_UA_20 | 14 | Water area of 2020 UA in square meters |
| MTFCC_UA_20 | 5 | MAFTIGER feature class code of 2020 UA |
| FUNCSTAT_UA_20 | 1 | Functional status of 2020 UA |
| AREALAND_PART | 14 | Calculated land area of the overlapping part in square meters |
| AREAWATER_PART | 14 | Calculated water area of the overlapping part in square meters |
2020 State Legislative District-Upper Chamber (SLDU) to 2020 Urban Area Relationship File layout (tab20_sldu202220_ua20_natl.txt, tab20_sldu20_ua20_st<##>.txt )
| Column name |
Maximum length | Column definition |
|---|---|---|
| OID_SLDU2022_20 | 22 | OID of 2020 SLDU |
| GEOID_SLDU2022_20 | 5 | GEOID of the 2020 SLDU |
| NAMELSAD_SLDU2022_20 | 100 | Name with translated Legal/Statistical Area Description of 2020 SLDU |
| AREALAND_SLDU2022_20 | 14 | Total land area of 2020 SLDU in square meters |
| AREAWATER_SLDU2022_20 | 14 | Total water area of 2020 SLDU in square meters |
| MTFCC_SLDU2022_20 | 5 | MAFTIGER feature class code of 2020 SLDU |
| FUNCSTAT_SLDU2022_20 | 1 | Functional status of 2020 SLDU |
| OID_UA_20 | 22 | OID of 2020 UA |
| GEOID_UA_20 | 5 | GEOID of the 2020 UA |
| NAMELSAD_UA_20 | 100 | Name with translated Legal/Statistical Area Description of 2020 UA |
| AREALAND_UA_20 | 14 | Land area of 2020 UA in square meters |
| AREAWATER_UA_20 | 14 | Water area of 2020 UA in square meters |
| MTFCC_UA_20 | 5 | MAFTIGER feature class code of 2020 UA |
| FUNCSTAT_UA_20 | 1 | Functional status of 2020 UA |
| AREALAND_PART | 14 | Calculated land area of the overlapping part in square meters |
| AREAWATER_PART | 14 | Calculated water area of the overlapping part in square meters |
2010 Urban Area to 2020 Urban Area Relationship File layout (tab20_ua10_ua20_natl.txt)
| Column name |
Maximum length | Column definition |
|---|---|---|
| OID_UA_10 | 22 | OID of 2010 UA |
| GEOID_UA_10 | 5 | GEOID of the 2010 UA |
| NAMELSAD_UA_10 | 100 | Name with translated Legal/Statistical Area Description of 2010 UA |
| AREALAND_UA_10 | 14 | Total land area of 2010 UA in square meters |
| AREAWATER_UA_10 | 14 | Total water area of 2010 UA in square meters |
| MTFCC_UA_10 | 5 | MAFTIGER feature class code of 2010 UA |
| FUNCSTAT_UA_10 | 1 | Functional status of 2010 UA |
| OID_UA_20 | 22 | OID of 2020 UA |
| GEOID_UA_20 | 5 | GEOID of the 2020 UA |
| NAMELSAD_UA_20 | 100 | Name with translated Legal/Statistical Area Description of 2020 UA |
| AREALAND_UA_20 | 14 | Land area of 2020 UA in square meters |
| AREAWATER_UA_20 | 14 | Water area of 2020 UA in square meters |
| MTFCC_UA_20 | 5 | MAFTIGER feature class code of 2020 UA |
| FUNCSTAT_UA_20 | 1 | Functional status of 2020 UA |
| AREALAND_PART | 14 | Calculated land area of the overlapping part in square meters |
| AREAWATER_PART | 14 | Calculated water area of the overlapping part in square meters |
2020 Urban Area to 2020 County Relationship File layout (tab20_ua20_county20_natl.txt)
| Column name |
Maximum length | Column definition |
|---|---|---|
| OID_UA_20 | 22 | OID of 2020 UA |
| GEOID_UA_20 | 5 | GEOID of the 2020 UA |
| NAMELSAD_UA_20 | 100 | Name with translated Legal/Statistical Area Description of 2020 UA |
| AREALAND_UA_20 | 14 | Total land area of 2020 UA in square meters |
| AREAWATER_UA_20 | 14 | Total water area of 2020 UA in square meters |
| MTFCC_UA_20 | 5 | MAFTIGER feature class code of 2020 UA |
| FUNCSTAT_UA_20 | 1 | Functional status of 2020 UA |
| OID_COUNTY_20 | 22 | OID of 2020 county |
| GEOID_COUNTY_20 | 5 | GEOID of the 2020 county |
| NAMELSAD_COUNTY_20 | 100 | Name with translated Legal/Statistical Area Description of 2020 county |
| AREALAND_COUNTY_20 | 14 | Land area of 2020 county in square meters |
| AREAWATER_COUNTY_20 | 14 | Water area of 2020 county in square meters |
| MTFCC_COUNTY_20 | 5 | MAFTIGER feature class code of 2020 county |
| CLASSFP_COUNTY_20 | 2 | FIPS class code of 2020 county |
| FUNCSTAT_COUNTY_20 | 1 | Functional status of 2020 county |
| AREALAND_PART | 14 | Calculated land area of the overlapping part in square meters |
| AREAWATER_PART | 14 | Calculated water area of the overlapping part in square meters |
2020 Urban Area to 2020 County Subdivision Relationship File layout (tab20_ua20_cousub20_natl.txt)
| Combines Incorporated Places and Census Designated Places (CDPs)* |
| Column name |
Maximum length | Column definition |
|---|---|---|
| OID_UA_20 | 22 | OID of 2020 UA |
| GEOID_UA_20 | 5 | GEOID of the 2020 UA |
| NAMELSAD_UA_20 | 100 | Name with translated Legal/Statistical Area Description of 2020 UA |
| AREALAND_UA_20 | 14 | Total land area of 2020 UA in square meters |
| AREAWATER_UA_20 | 14 | Total water area of 2020 UA in square meters |
| MTFCC_UA_20 | 5 | MAFTIGER feature class code of 2020 UA |
| FUNCSTAT_UA_20 | 1 | Functional status of 2020 UA |
| OID_PLACE_20 | 22 | OID of 2020 place |
| GEOID_PLACE_20 | 7 | GEOID of the 2020 place |
| NAMELSAD_PLACE_20 | 100 | Name with translated Legal/Statistical Area Description of 2020 place |
| AREALAND_PLACE_20 | 14 | Land area of 2020 place in square meters |
| AREAWATER_PLACE_20 | 14 | Water area of 2020 place in square meters |
| MTFCC_PLACE_20 | 5 | MAFTIGER feature class code of 2020 place* |
| CLASSFP_PLACE_20 | 2 | FIPS class code of 2020 place |
| FUNCSTAT_PLACE_20 | 1 | Functional status of 2020 place |
| AREALAND_PART | 14 | Calculated land area of the overlapping part in square meters |
| AREAWATER_PART | 14 | Calculated water area of the overlapping part in square meters |
2020 Urban Area to 2020 Place Relationship File layout (tab20_ua20_place20_natl.txt)
| Column name |
Maximum length | Column definition |
|---|---|---|
| OID_UA_20 | 22 | OID of 2020 UA |
| GEOID_UA_20 | 5 | GEOID of the 2020 UA |
| NAMELSAD_UA_20 | 100 | Name with translated Legal/Statistical Area Description of 2020 UA |
| AREALAND_UA_20 | 14 | Total land area of 2020 UA in square meters |
| AREAWATER_UA_20 | 14 | Total water area of 2020 UA in square meters |
| MTFCC_UA_20 | 5 | MAFTIGER feature class code of 2020 UA |
| FUNCSTAT_UA_20 | 1 | Functional status of 2020 UA |
| OID_COUSUB_20 | 22 | OID of 2020 county subdivision |
| GEOID_COUSUB_20 | 10 | GEOID of the 2020 county subdivision |
| NAMELSAD_COUSUB_20 | 100 | Name with translated Legal/Statistical Area Description of 2020 county subdivision |
| AREALAND_COUSUB_20 | 14 | Land area of 2020 county subdivision in square meters |
| AREAWATER_COUSUB_20 | 14 | Water area of 2020 county subdivision in square meters |
| MTFCC_COUSUB_20 | 5 | MAFTIGER feature class code of 2020 county subdivision |
| CLASSFP_COUSUB_20 | 2 | FIPS class code of 2020 county subdivision |
| FUNCSTAT_COUSUB_20 | 1 | Functional status of 2020 county subdivision |
| AREALAND_PART | 14 | Calculated land area of the overlapping part in square meters |
| AREAWATER_PART | 14 | Calculated water area of the overlapping part in square meters |
2020 Urban Area to 2020 ZIP Code Tabulation Area (ZCTA) Relationship File layout (tab20_ua20_zcta520_natl.txt)
| Column name |
Maximum length | Column definition |
|---|---|---|
| OID_UA_20 | 22 | OID of 2020 UA |
| GEOID_UA_20 | 5 | GEOID of the 2020 UA |
| NAMELSAD_UA_20 | 100 | Name with translated Legal/Statistical Area Description of 2020 UA |
| AREALAND_UA_20 | 14 | Total land area of 2020 UA in square meters |
| AREAWATER_UA_20 | 14 | Total water area of 2020 UA in square meters |
| MTFCC_UA_20 | 5 | MAFTIGER feature class code of 2020 UA |
| FUNCSTAT_UA_20 | 1 | Functional status of 2020 UA |
| OID_ZCTA5_20 | 22 | OID of 2020 ZCTA5 |
| GEOID_ZCTA5_20 | 5 | GEOID of the 2020 ZCTA5 |
| NAMELSAD_ZCTA5_20 | 100 | Name with translated Legal/Statistical Area Description of 2020 ZCTA5 |
| AREALAND_ZCTA5_20 | 14 | Land area of 2020 ZCTA5 in square meters |
| AREAWATER_ZCTA5_20 | 14 | Water area of 2020 ZCTA5 in square meters |
| MTFCC_ZCTA5_20 | 5 | MAFTIGER feature class code of 2020 ZCTA5 |
| CLASSFP_ZCTA5_20 | 2 | FIPS class code of 2020 ZCTA5 |
| FUNCSTAT_ZCTA5_20 | 1 | Functional status of 2020 ZCTA5 |
| AREALAND_PART | 14 | Calculated land area of the overlapping part in square meters |
| AREAWATER_PART | 14 | Calculated water area of the overlapping part in square meters |
Related Information
REFERENCE FILE
Relationship Files
TECHNICAL DOCUMENTATION
2020 Comparability Relationship File Record Layouts
Page Last Revised - November 1, 2024