Abstract

A crosswalk matching US ZIP codes to corresponding CBSA (core-based statistical area)

Documentation

The denominators used to calculate the address ratios are the ZIP code totals. When a ZIP is split by any of the other geographies, that ZIP code is duplicated in the crosswalk file.

**Example: **ZIP code 03870 is split by two different Census tracts, 33015066000 and 33015071000, which appear in the tract column. The ratio of residential addresses in the first ZIP-Tract record to the total number of residential addresses in the ZIP code is .0042 (.42%). The remaining residential addresses in that ZIP (99.58%) fall into the second ZIP-Tract record.

So, for example, if one wanted to allocate data from ZIP code 03870 to each Census tract located in that ZIP code, one would multiply the number of observations in the ZIP code by the residential ratio for each tract associated with that ZIP code.

https://redivis.com/fileUploads/4ecb405e-f533-4a5b-8286-11e56bb93368%3E" alt="">(Note that the sum of each ratio column for each distinct ZIP code may not always equal 1.00 (or 100%) due to rounding issues.)

CBSA definition

A core-based statistical area (CBSA) is a U.S. geographic area defined by the Office of Management and Budget (OMB) that consists of one or more counties (or equivalents) anchored by an urban center of at least 10,000 people plus adjacent counties that are socioeconomically tied to the urban center by commuting. Areas defined on the basis of these standards applied to Census 2000 data were announced by OMB in June 2003. These standards are used to replace the definitions of metropolitan areas that were defined in 1990. The OMB released new standards based on the 2010 Census on July 15, 2015.

Further reading

The following article demonstrates how to more effectively use the U.S. Department of Housing and Urban Development (HUD) United States Postal Service ZIP Code Crosswalk Files when working with disparate geographies.

Wilson, Ron and Din, Alexander, 2018. “Understanding and Enhancing the U.S. Department of Housing and Urban Development’s ZIP Code Crosswalk Files,” Cityscape: A Journal of Policy Development and Research, Volume 20 Number 2, 277 – 294. URL: https://www.huduser.gov/portal/periodicals/cityscpe/vol20num2/ch16.pdf

Contact authors

Questions regarding these crosswalk files can be directed to Alex Din with the subject line HUD-Crosswalks.

Acknowledgement

This dataset is taken from the U.S. Department of Housing and Urban Development (HUD) office: https://www.huduser.gov/portal/datasets/usps_crosswalk.html#codebook

This system provides the user with a facility to select a state and county combination to determine if the selected county is part of an Office of Management and Budget (OMB) defined Core Based Statistical Area (CBSA). The system has been updated with OMB area definitions published for FY 2009.

One of the many challenges that social science researchers and practitioners face is the difficulty of relating data between census tracts which are re-delineated with each decennial census. While some methods of harmonizing or crosswalking data between census tracts exist, to provide additional avenues for merging these data, PD&R has released the HUD-USPS Census Tract Crosswalk Files. These unique files are derived from the USPS Vacancy Data which are regularly updated by the USPS which makes them uniquely positioned to describe human settlements patterns between census tract delineations. These data use the locations of ZIP+4 centroids, an extremely granular level of geography, the number of addresses of various types (residential, business, other, and total), and do not rely on ancillary data to map where population or households might be located.There are twelve types of crosswalk files available for download. The first six crosswalk files are used to allocate ZIP codes to Census Bureau geographies such as census tracts, counties, county subdivisions, Core Based Statistical Areas (CBSAs), CBSA Divisions, and Congressional Districts. The last six are used to allocate from those same Census Bureau geographies to ZIP Codes. It is important to note that the relationship between the two types of crosswalk files is not perfectly inverse. That is to say, the ZIP to Tract crosswalk file cannot be used to allocate data from census tract geographies to ZIP codes. Instead, the Tract to ZIP crosswalk file must be used in that specific scenario.In addition to the crosswalk files, this dataset also includes screenshots of HUDs documentation and FAQ pages.

The database includes ZIP code, city name, alias city name, state code, phone area code, city type, county name, country FIPS, time zone, day light saving flag, latitude, longitude, county elevation, Metropolitan Statistical Area (MSA), Primary Metropolitan Statistical Area (PMSA), Core Based Statistical Area (CBSA) and census 2000 data on population by race, average household income, and average house value.

Summary File 1 (SF1) Urban/Rural Update contains summary statistics on population and housing subjects derived from the responses to the 2010 Census questionnaire. Population items include sex, age, race, Hispanic or Latino origin, household relationship, household type, household size, family type, family size, and group quarters. Housing items include occupancy status, vacancy status, and tenure (whether a housing unit is owner-occupied or renter-occupied). The summary statistics are presented in 333 tables, which are tabulated for multiple levels of observation (called "summary levels" in the Census Bureau's nomenclature), including, but not limited to, regions, divisions, states, metropolitan/micropolitan statistical areas, counties, county subdivisions, places, congressional districts, American Indian Areas, Alaska Native Areas, Hawaiian Home Lands, ZIP Code tabulation areas, census tracts, block groups, and blocks. There are 177 population tables and 58 housing tables shown down to the block level; 84 population tables and 4 housing tables shown down to the census tract level; and 10 population tables shown down to the county level. Some of the summary areas are iterated for "geographic components" or portions of geographic areas, e.g., the principal city of a metropolitan statistical area (MSA) or the urban and rural portions of a MSA. With one variable per table cell and additional variables with geographic information, the collection comprises 2,597 data files, 49 per state, the District of Columbia, Puerto Rico, and the National File. The Census Bureau released SF1 in three stages: initial release, National Update, and Urban/Rural Update. The National Update added summary levels for the United States, regions, divisions, and geographic areas that cross state lines such as Combined Statistical Areas. This update adds urban and rural population and housing unit counts, summary levels for urban areas and the urban/rural components of census tracts and block groups, geographic components involving urbanized areas and urban clusters, and two new tables (household type by relationship for the population 65 years and over and a new tabulation of the total population by race). The initial release and National Update is available as ICPSR 33461. ICPSR supplies this data collection in 54 ZIP archives. There is a separate archive for each state, the District of Columbia, Puerto Rico, and the National File. The last archive contains a Microsoft Access database shell and additional documentation files besides the codebook.

The TIGER/Line shapefiles and related database files (.dbf) are an extract of selected geographic and cartographic information from the U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTDB). The MTDB represents a seamless national file with no overlaps or gaps between parts, however, each TIGER/Line shapefile is designed to stand alone as an independent data set, or they can be combined to cover the entire nation. ZIP Code Tabulation Areas (ZCTAs) are approximate area representations of U.S. Postal Service (USPS) ZIP Code service areas that the Census Bureau creates to present statistical data for each decennial census. The Census Bureau delineates ZCTA boundaries for the United States, Puerto Rico, American Samoa, Guam, the Commonwealth of the Northern Mariana Islands, and the U.S. Virgin Islands once each decade following the decennial census. Data users should not use ZCTAs to identify the official USPS ZIP Code for mail delivery. The USPS makes periodic changes to ZIP Codes to support more efficient mail delivery. The Census Bureau uses tabulation blocks as the basis for defining each ZCTA. Tabulation blocks are assigned to a ZCTA based on the most frequently occurring ZIP Code for the addresses contained within that block. The most frequently occurring ZIP Code also becomes the five-digit numeric code of the ZCTA. These codes may contain leading zeros. Blocks that do not contain addresses but are surrounded by a single ZCTA (enclaves) are assigned to the surrounding ZCTA. Because the Census Bureau only uses the most frequently occurring ZIP Code to assign blocks, a ZCTA may not exist for every USPS ZIP Code. Some ZIP Codes may not have a matching ZCTA because too few addresses were associated with the specific ZIP Code or the ZIP Code was not the most frequently occurring ZIP Code within any of the blocks where it exists. The ZCTA boundaries in this release are those delineated following the 2020 Census.

Characteristics of the ZIP Codes (N = 968), Counties (N = 51), and Metropolitan Statistical Areas (MSAs; N = 19) where the 9,077 participants of the 2009 Centers for Disease Control and Prevention’s National HIV Behavioral Surveillance Lived, by Racial/Ethnic Group1.

NAME: MSA2010tiger DESCRIPTION: Major Statistical Areas (derived from raw 2010 TIGER census tracts) FEATURE TYPE: Polygon EXTENT: San Diego region DATE OF DATA: 2010 NUMBER OF RECORDS: 7 MAPPING SOURCE: SANDAG; U.S. Department of Commerce, U.S. Census Bureau, Geography Division, TIGER/Line Shapefile Notes: The TIGER/Line Files are shapefiles and related database files (.dbf) that are an extract of selected geographic and cartographic information from the U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTDB). Census Tracts nest within Subregional Areas (SRAs) which nest within Major Statistical Areas (MSAs). There are only minor differences between the 1980, 1990, 2000, and 2010 SRA and MSA boundaries due to some census tract boundary realignments. Original TIGER Shapefiles can be obtained at http://www.census.gov/geo/www/tiger Code Documentation: Attribute Description MSA Major Statistical Area Code NAME Major Statistical Area Name MSA Name 0 Central 1 North City 2 South Suburban 3 East Suburban 4 North County West 5 North County East 6 East County Last revised: March 2011

Zip Codes dataset current as of 2006. Green Co Zip Codes.

The TIGER/Line Shapefiles and related database files (.dbf) are an extract of selected geographic and cartographic information from the U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) System. The MAF/TIGER System represents a seamless national file with no overlaps or gaps between parts, however, each TIGER/Line Shapefile is designed to stand alone as an independent data set, or they can be combined to cover the entire nation. The TIGERweb REST Services allows users to integrate the Census Bureau's Topologically Integrated Geographic Encoding and Referencing database (TIGER) data into their own GIS or custom web-based applications.For a more detailed description of the areas listed or terms below, refer to TIGER/Line documentation or the Geographic Areas Reference Manual, (GARM).This REST service contains Combined New England City and Town Area (CNECTA), Combined Statistical Area (CSA), Metropolitan Division, Core Based Statistical Areas (CBSA), and New England City and Town Area (NECTA) boundaries.Combined New England City and Town Areas (CNECTAs) consist of two or more adjacent NECTAs that have significant employment interchanges. The NECTAs that combine to create a CNECTA retain separate identities within the larger combined statistical areas.

Combined Statistical Areas (CSAs) consist of two or more adjacent CBSAs that have significant employment interchanges. The CBSAs that combine to create a CSA retain separate identities within the larger CSAs.

Metropolitan Divisions are smaller groupings of counties or equivalent entities within a metropolitan statistical area that contains a single core with 2.5 million inhabitants.

Core Based Statistical Area Codes (CBSA) are the metropolitan statistical areas, micropolitan statistical areas, NECTAs, metropolitan divisions, and NECTA divisions use a 5-character code. Each metropolitan statistical area must have one urbanized area of 50,000 or more inhabitants. Each micropolitan statistical area must have one urban cluster of 10,000 to 49,999 inhabitants.

New England City and Town Area (NECTA) Divisions are smaller groupings of cities and towns within a NECTA that contains a single core with 2.5 million inhabitants. A NECTA Division consists of a main city or town that represents an employment center, as well as adjacent cities and towns associated with the main city or town through commuting ties. Each NECTA Division must contain a total population of 100,000 or more.

Additional resources to obtain Metropolitan and Micropolitan Statistical Areas and Related Statistical Areas are listed below.

Combined New England City and Town Area (CNECTA) Shapefile - https://www2.census.gov/geo/tiger/TIGER2020/CNECTA/

Combined Statistical Area (CSA) Shapefile – https://www2.census.gov/geo/tiger/TIGER2020/CSA/

Metropolitan Division Shapefile – https://www2.census.gov/geo/tiger/TIGER2020/METDIV/

Core Based Statistical Areas (CBSA) Shapefile – https://www2.census.gov/geo/tiger/TIGER2020/CBSA/

New England City and Town Area (NECTA) Shapefile- https://www2.census.gov/geo/tiger/TIGER2020/NECTA/.

The TIGER/Line shapefiles and related database files (.dbf) are an extract of selected geographic and cartographic information from the U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTDB). The MTDB represents a seamless national file with no overlaps or gaps between parts, however, each TIGER/Line shapefile is designed to stand alone as an independent data set, or they can be combined to cover the entire nation. Metropolitan and Micropolitan Statistical Areas are together termed Core Based Statistical Areas (CBSAs) and are defined by the Office of Management and Budget (OMB) and consist of the county or counties or equivalent entities associated with at least one urban core (urbanized area or urban cluster) of at least 10,000 population, plus adjacent counties having a high degree of social and economic integration with the core as measured through commuting ties with the counties containing the core. Categories of CBSAs are: Metropolitan Statistical Areas, based on urbanized areas of 50,000 or more population; and Micropolitan Statistical Areas, based on urban clusters of at least 10,000 population but less than 50,000 population. The CBSA boundaries are those defined by OMB based on the 2010 Census, published in 2013, and updated in 2018.

TIGER road data for the MSA. When compared to high-resolution imagery and other transportation datasets positional inaccuracies were observed. As a result caution should be taken when using this dataset. TIGER, TIGER/Line, and Census TIGER are registered trademarks of the U.S. Census Bureau. ZCTA is a trademark of the U.S. Census Bureau. The Census 2000 TIGER/Line files are an extract of selected geographic and cartographic information from the Census TIGER data base. The geographic coverage for a single TIGER/Line file is a county or statistical equivalent entity, with the coverage area based on January 1, 2000 legal boundaries. A complete set of census 2000 TIGER/Line files includes all counties and statistically equivalent entities in the United States, Puerto Rico, and the Island Areas. The Census TIGER data base represents a seamless national file with no overlaps or gaps between parts. However, each county-based TIGER/Line file is designed to stand alone as an independent data set or the files can be combined to cover the whole Nation. The Census 2000 TIGER/Line files consist of line segments representing physical features and governmental and statistical boundaries. The boundary information in the TIGER/Line files are for statistical data collection and tabulation purposes only; their depiction and designation for statistical purposes does not constitute a determination of jurisdictional authority or rights of ownership or entitlement. The Census 2000 TIGER/Line files do NOT contain the Census 2000 urban areas which have not yet been delineated. The files contain information distributed over a series of record types for the spatial objects of a county. There are 17 record types, including the basic data record, the shape coordinate points, and geographic codes that can be used with appropriate software to prepare maps. Other geographic information contained in the files includes attributes such as feature identifiers/census feature class codes (CFCC) used to differentiate feature types, address ranges and ZIP Codes, codes for legal and statistical entities, latitude/longitude coordinates of linear and point features, landmark point features, area landmarks, key geographic features, and area boundaries. The Census 2000 TIGER/Line data dictionary contains a complete list of all the fields in the 17 record types. This is part of a collection of 221 Baltimore Ecosystem Study metadata records that point to a geodatabase. The geodatabase is available online and is considerably large. Upon request, and under certain arrangements, it can be shipped on media, such as a usb hard drive. The geodatabase is roughly 51.4 Gb in size, consisting of 4,914 files in 160 folders. Although this metadata record and the others like it are not rich with attributes, it is nonetheless made available because the data that it represents could be indeed useful. This is part of a collection of 221 Baltimore Ecosystem Study metadata records that point to a geodatabase. The geodatabase is available online and is considerably large. Upon request, and under certain arrangements, it can be shipped on media, such as a usb hard drive. The geodatabase is roughly 51.4 Gb in size, consisting of 4,914 files in 160 folders. Although this metadata record and the others like it are not rich with attributes, it is nonetheless made available because the data that it represents could be indeed useful.

The TIGER/Line shapefiles and related database files (.dbf) are an extract of selected geographic and cartographic information from the U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTDB). The MTDB represents a seamless national file with no overlaps or gaps between parts, however, each TIGER/Line shapefile is designed to stand alone as an independent data set, or they can be combined to cover the entire nation.Metropolitan and Micropolitan Statistical Areas are together termed Core Based Statistical Areas (CBSAs) and are defined by the Office of Management and Budget (OMB) and consist of the county or counties or equivalent entities associated with at least one urban core (urbanized area or urban cluster) of at least 10,000 population, plus adjacent counties having a high degree of social and economic integration with the core as measured through commuting ties with the counties containing the core. Categories of CBSAs are: Metropolitan Statistical Areas, based on urbanized areas of 50,000 or more population; and Micropolitan Statistical Areas, based on urban clusters of at least 10,000 population but less than 50,000 population.Fields (https://www2.census.gov/geo/pdfs/maps-data/data/tiger/tgrshp2013/TGRSHP2013_TechDoc_A.pdf, p. A-85)Field

Length

Type

Description

CSAFP

3

String

Current combined statistical area code, if applicable

CBSAFP

5

String

Current metropolitan statistical area/micropolitan statistical area code

GEOID

5

String

Metropolitan statistical area/micropolitan statistical area identifier, metropolitan statistical area/micropolitan statistical area code

NAME

100

String

Current metropolitan statistical area/micropolitan statistical area name

NAMELSAD

100

String

Current name and the translated legal/statistical area description for metropolitan statistical area/micropolitan statistical area

LSAD

2

String

Current legal/statistical area description code for metropolitan statistical area/micropolitan statistical area

MEMI

1

String

Current metropolitan/micropolitan status indicator

MTFCC

5 String MAF/TIGER feature class code (G3110)

ALAND

14

Number

Current land area

AWATER

14 Number Current water area

INTPTLAT

11

String

Current latitude of the internal point

INTPTLON

12

String

Current longitude of the internal point

The TIGER/Line shapefiles and related database files (.dbf) are an extract of selected geographic and cartographic information from the U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTDB). The MTDB represents a seamless national file with no overlaps or gaps between parts, however, each TIGER/Line shapefile is designed to stand alone as an independent data set, or they can be combined to cover the entire nation.Metropolitan and Micropolitan Statistical Areas are together termed Core Based Statistical Areas (CBSAs) and are defined by the Office of Management and Budget (OMB) and consist of the county or counties or equivalent entities associated with at least one urban core (urbanized area or urban cluster) of at least 10,000 population, plus adjacent counties having a high degree of social and economic integration with the core as measured through commuting ties with the counties containing the core. Categories of CBSAs are: Metropolitan Statistical Areas, based on urbanized areas of 50,000 or more population; and Micropolitan Statistical Areas, based on urban clusters of at least 10,000 population but less than 50,000 population.Fields (https://www2.census.gov/geo/pdfs/maps-data/data/tiger/tgrshp2013/TGRSHP2013_TechDoc_A.pdf, p. A-85)Field

Length

Type

Description

CSAFP

3

String

Current combined statistical area code, if applicable

CBSAFP

5

String

Current metropolitan statistical area/micropolitan statistical area code

GEOID

5

String

Metropolitan statistical area/micropolitan statistical area identifier, metropolitan statistical area/micropolitan statistical area code

NAME

100

String

Current metropolitan statistical area/micropolitan statistical area name

NAMELSAD

100

String

Current name and the translated legal/statistical area description for metropolitan statistical area/micropolitan statistical area

LSAD

2

String

Current legal/statistical area description code for metropolitan statistical area/micropolitan statistical area

MEMI

1

String

Current metropolitan/micropolitan status indicator

MTFCC

5 String MAF/TIGER feature class code (G3110)

ALAND

14

Number

Current land area

AWATER

14 Number Current water area

INTPTLAT

11

String

Current latitude of the internal point

INTPTLON

12

String

Current longitude of the internal point

The TIGER/Line shapefiles and related database files (.dbf) are an extract of selected geographic and cartographic information from the U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTDB). The MTDB represents a seamless national file with no overlaps or gaps between parts, however, each TIGER/Line shapefile is designed to stand alone as an independent data set, or they can be combined to cover the entire nation. Metropolitan and Micropolitan Statistical Areas are together termed Core Based Statistical Areas (CBSAs) and are defined by the Office of Management and Budget (OMB) and consist of the county or counties or equivalent entities associated with at least one urban core (urbanized area or urban cluster) of at least 10,000 population, plus adjacent counties having a high degree of social and economic integration with the core as measured through commuting ties with the counties containing the core. Categories of CBSAs are: Metropolitan Statistical Areas, based on urbanized areas of 50,000 or more population; and Micropolitan Statistical Areas, based on urban clusters of at least 10,000 population but less than 50,000 population. The CBSA boundaries are those defined by OMB based on the 2010 Census, published in 2013, and updated in 2018.

File provides the capability of assigning geographic codes (State, County, and Place) to records containing ZIP Code, post office name, and State abbreviation

This version has been updated to include codes for metropolitan statistical areas (MSA's) defined as of 6/30/87, and codes for counties and places in existence as of 1/1/87

Fifty states, the District of Columbia, and Puerto Rico

The 1990 Census Block Statistics portion of the Archive of Census Related Products (ACRP) contains population and housing data from the U.S. Census Bureau's 1990 Summary Tape File (STF1B). The population data includes total population, age, race, and hispanic origin, while the housing data comprises number of housing Units, tenure, room density, mean contract rent, mean value, and mean number of rooms. Additional data includes land area, water area, centroids, Metropolitan Statistical Area (MSA) codes, place codes, and special area codes. This portion of the ACRP is produced by the Columbia University Center for International Earth Science Information Network (CIESIN).

The 1990 Census Block Statistics portion of the Archive of Census Related Products (ACRP) contains population and housing data from the U.S. Census Bureau's 1990 Summary Tape File (STF1B). The population data includes total population, age, race, and hispanic origin, while the housing data comprises number of housing Units, tenure, room density, mean contract rent, mean value, and mean number of rooms. Additional data includes land area, water area, centroids, Metropolitan Statistical Area (MSA) codes, place codes, and special area codes. This portion of the ACRP is produced by the Columbia University Center for International Earth Science Information Network (CIESIN).

The table CBSA area and code is part of the dataset National Household Level Travel Survey (NHTS) ***, available at https://redivis.com/datasets/gn73-86n9xfyyr. It contains 929 rows across 3 variables.

Place-based Constructs, Variables, and Data Sources.