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

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.

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.

The tables and interactive maps below allow users to explore the ratio of debt to income by state, metropolitan statistical area, and county for each year since 1999. Household debt is calculated from Federal Reserve Bank of New York (FRBNY) Consumer Credit Panel/Equifax Data, and household income is reported by the Bureau of Labor Statistics.