U.S. flag

An official website of the United States government

Skip Header


2020 ZIP Code Tabulation Area (ZCTA) Relationship File Record Layouts

2010 Zip Code Tabulation Area (ZCTA5) to 2020 ZCTA5 Relationship File Layout (tab20_zcta510_zcta520_natl.txt)

Relationship File Column Name Maximum Length Column Definition
OID_ZCTA5_10 22 OID of 2010 ZCTA5
GEOID_ZCTA5_10 5 GEOID of the 2010 ZCTA5
NAMELSAD_ZCTA5_10 100 Name with translated Legal/Statistical Area Description of 2010 ZCTA5
AREALAND_ZCTA5_10 14 Total land area of 2010 ZCTA5 in square meters
AREAWATER_ZCTA5_10 14 Total water area of 2010 ZCTA5 in square meters
MTFCC_ZCTA5_10 5 MAFTIGER feature class code of 2010 ZCTA5
CLASSFP_ZCTA5_10 2 FIPS class code of 2010 ZCTA5
FUNCSTAT_ZCTA5_10 1 Functional status of 2010 ZCTA5
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

2020 Zip Code Tabulation Area (ZCTA5) to 2020 County Relationship File Layout (tab20_zcta520_county20_natl.txt)

Relationship File Column Name Maximum Length Column Definition
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 Total land area of 2020 ZCTA5 in square meters
AREAWATER_ZCTA5_20 14 Total 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
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 Zip Code Tabulation Area (ZCTA5) to 2020 County Subdivision Relationship File Layout (tab20_zcta520_cousub20_natl.txt)

Relationship File Column Name Maximum Length Column Definition
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 Total land area of 2020 ZCTA5 in square meters
AREAWATER_ZCTA5_20 14 Total 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
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 Zip Code Tabulation Area (ZCTA5) to 2020 Place Relationship File Layout (tab20_zcta520_place20_natl.txt)

Relationship File Column Name Maximum Length Column Definition
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 Total land area of 2020 ZCTA5 in square meters
AREAWATER_ZCTA5_20 14 Total 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
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 Zip Code Tabulation Area (ZCTA5) to 2020 Census Tract Relationship File Layout (tab20_zcta520_tract20_natl.txt)

Relationship File Column Name Maximum Length Column Definition
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 Total land area of 2020 ZCTA5 in square meters
AREAWATER_ZCTA5_20 14 Total 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
OID_TRACT_20 22 OID of 2020 tract
GEOID_TRACT_20 11 GEOID of the 2020 tract
NAMELSAD_TRACT_20 100 Name with translated Legal/Statistical Area Description of 2020 tract
AREALAND_TRACT_20 14 Land area of 2020 tract in square meters
AREAWATER_TRACT_20 14 Water area of 2020 tract in square meters
MTFCC_TRACT_20 5 MAFTIGER feature class code of 2020 tract
CLASSFP_TRACT_20 2 FIPS class code of 2020 tract
FUNCSTAT_TRACT_20 1 Functional status of 2020 tract
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 Zip Code Tabulation Area (ZCTA5) to 2020 Census Tabblock Relationship File Layout (tab20_zcta520_tabblock20_natl.txt)

Relationship File Column Name Maximum Length Column Definition
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 Total land area of 2020 ZCTA5 in square meters
AREAWATER_ZCTA5_20 14 Total 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
OID_TABBLOCK_20 22 OID of 2020 tabulation block
GEOID_TABBLOCK_20 15 GEOID of the 2020 tabulation block
NAMELSAD_TABBLOCK_20 100 Name with translated Legal/Statistical Area Description of 2020 tabulation block
AREALAND_TABBLOCK_20 14 Land area of 2020 tabulation block in square meters
AREAWATER_TABBLOCK_20 14 Water area of 2020 tabulation block in square meters
MTFCC_TABBLOCK_20 5 MAFTIGER feature class code of 2020 tabulation block
CLASSFP_TABBLOCK_20 2 FIPS class code of 2020 tabulation block
FUNCSTAT_TABBLOCK_20 1 Functional status of 2020 tabulation block
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

Page Last Revised - June 22, 2024
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