U.S. flag

An official website of the United States government

Skip Header


2020 Urban Area (UA) Relationship Files Record Layouts

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
CLASSFP_cd118_20 2 FIPS 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
CLASSFP_ua_20 2 FIPS 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
CLASSFP_sldl2022_20 2 FIPS 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
CLASSFP_ua_20 2 FIPS 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
CLASSFP_sldu2022_20 2 FIPS 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
CLASSFP_ua_20 2 FIPS 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
CLASSFP_ua_10 2 FIPS 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
CLASSFP_ua_20 2 FIPS 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
CLASSFP_ua_20 2 FIPS 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
CLASSFP_ua_20 2 FIPS 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
    *MTFCC = 'G4110' for Incorporated Places
    *MTFCC = 'G4210' for CDPs

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
CLASSFP_ua_20 2 FIPS class code of 2020 ua
FUNCSTAT_ua_20 1 Functional status of 2020 ua
OID_cousub_20 22 OID of 2020 cousub
GEOID_cousub_20 10 GEOID of the 2020 cousub 
NAMELSAD_cousub_20 100 Name with translated Legal/Statistical Area Description of 2020 cousub
AREALAND_cousub_20 14 Land area of 2020 cousub in square meters
AREAWATER_cousub_20 14 Water area of 2020 cousub in square meters
MTFCC_cousub_20 5 MAFTIGER feature class code of 2020 cousub
CLASSFP_cousub_20 2 FIPS class code of 2020 cousub
FUNCSTAT_cousub_20 1 Functional status of 2020 cousub
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
CLASSFP_ua_20 2 FIPS 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


Page Last Revised - May 1, 2023
Is this page helpful?
Thumbs Up Image Yes Thumbs Down Image No
NO THANKS
255 characters maximum 255 characters maximum reached
Thank you for your feedback.
Comments or suggestions?

Top

Back to Header