HUD’s Office of Policy Development and Research (PD&R) announced that HUD-USPS ZIP Code Crosswalk data are now available via an application programming interface (API). With this API, developers can easily access and customize crosswalk data for use in existing applications or to create new applications. To create an account and get an access token, please visit the API page here: https://www.huduser.gov/portal/dataset/uspszip-api.html.

Abstract

A crosswalk dataset matching US ZIP codes to corresponding census tracts

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.)

Census tract definition

A census tract, census area, census district or meshblock is a geographic region defined for the purpose of taking a census. Sometimes these coincide with the limits of cities, towns or other administrative areas and several tracts commonly exist within a county. In unincorporated areas of the United States these are often arbitrary, except for coinciding with political lines.

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 information

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.

One of the many challenges that social science researchers and practitioners face is the difficulty of relating United States Postal Service (USPS) ZIP codes to Census Bureau geographies. There are valuable data available only at the ZIP code level that, when combined with demographic data tabulated at various Census geography levels, could open up new avenues of exploration.While some acceptable methods of combining ZIP codes and Census geography exist, they have limitations. To provide additional avenues for merging these data, PD&R has released the HUD-USPS Crosswalk Files. These unique files are derived from data in the quarterly USPS Vacancy Data. They originate directly from the USPS; are updated quarterly, making them highly responsive to changes in ZIP code configurations; and reflect the locations of both business and residential addresses. The latter feature is of particular interest to housing researchers because many of the phenomena that they study are based on housing unit or address. By using an allocation method based on residential addresses rather than by area or by population, analysts can take into account not only the spatial distribution of population, but also the spatial distribution of residences. This enables a slightly more nuanced approach to allocating data between disparate geographies. Please note that the USPS Vacancy Data is constructed from ZIP+4 data that contains records of addresses, it does not contain ZIP+4 data that are associated with ZIP codes that exclusively serve Postal Office Boxes (PO Boxes). As a result, ZIP codes that only serve PO Boxes will not appear in the files.In addition to the crosswalk files, this dataset also includes screenshots of HUDs documentation and FAQ pages.Understanding ZIP Code Crosswalk FilesThough often used for mapping, spatial analysis, and data aggregation careful attention is required when interpreting ZIP Code data relative to other administrative geographies. 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. https://www.huduser.gov/portal/periodicals/cityscpe/vol20num2/ch16.pdfUsing a GIS to Geoprocess ZIP Code Crosswalk FilesThis article demonstrates how to use a GIS to process ZIP Code Crosswalk Files. In this article, calls for service from New York City's Open Data Portal are estimated at the county-level and census tract-level. This article also includes an accuracy analysis.Din, Alexander and Wilson, Ron, 2020. "Crosswalking ZIP Codes to Census Geographies: Geoprocessing the U.S. Department of Housing & Urban Development’s ZIP Code Crosswalk Files," Cityscape: A Journal of Policy Development and Research, Volume 22, Number 1, https://www.huduser.gov/portal/periodicals/cityscpe/vol22num1/ch12.pdf

Context

Dataset created to link between County - State Name, State-County FIPS, and ZIP Code.

Acknowledgements

Data Sources

• US HUD

https://www.huduser.gov/portal/datasets/usps.html

• Census Bureau

https://www2.census.gov/geo/docs/reference/codes/files/national_county.txt https://www.census.gov/geo/reference/codes/cou.html

Data cleaned by Data4Democracy and hosted originally on Data.World: https://github.com/Data4Democracy/zip-code-to-county https://data.world/niccolley/us-zipcode-to-county-state

ZCTA data from USPS 6.2017 release.

Image from Reddit.

Analysis of ‘US Zipcodes to County State to FIPS Crosswalk’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/danofer/zipcodes-county-fips-crosswalk on 28 January 2022.

--- Dataset description provided by original source is as follows ---

Context

Dataset created to link between County - State Name, State-County FIPS, and ZIP Code.

Acknowledgements

Data Sources

• US HUD

https://www.huduser.gov/portal/datasets/usps.html

• Census Bureau

https://www2.census.gov/geo/docs/reference/codes/files/national_county.txt https://www.census.gov/geo/reference/codes/cou.html

Data cleaned by Data4Democracy and hosted originally on Data.World: https://github.com/Data4Democracy/zip-code-to-county https://data.world/niccolley/us-zipcode-to-county-state

ZCTA data from USPS 6.2017 release.

Image from Reddit.

--- Original source retains full ownership of the source dataset ---

A. SUMMARY This dataset contains the list of intersecting Analysis Neighborhoods and ZIP Codes for the City and County of San Francisco. It can be used to identify which ZIP codes overlap with Analysis Neighborhoods and vice verse. B. HOW THE DATASET IS CREATED The dataset was created with a spatial join between the Analysis Neighborhoods and ZIP codes. C. UPDATE PROCESS This is a static dataset D. HOW TO USE THIS DATASET This dataset is a many-to-many relationship between analysis neighborhoods and ZIP codes. A single neighborhood can contain or intersect with multiple ZIP codes and similarly, a single ZIP code can be in multiple neighborhoods. This dataset does not contain geographic boundary data (i.e. shapefiles/ GEOMs). The datasets below containing geographic boundary data should be used for analysis of data with geographic coordinates. E. RELATED DATASETS Analysis Neighborhoods San Francisco ZIP Codes Supervisor District (2022) to ZIP Code Crosswalk Analysis Neighborhoods - 2020 census tracts assigned to neighborhoods

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

A. SUMMARY This dataset contains the list of intersecting 2022 Supervisor Districts and ZIP Codes for the City and County of San Francisco. It can be used to identify which ZIP codes overlap with Supervisor Districts (2022) and vice verse. B. HOW THE DATASET IS CREATED The dataset was created with a spatial join between the 2022 Supervisor districts and ZIP codes. C. UPDATE PROCESS This is a static dataset D. HOW TO USE THIS DATASET This dataset is a many-to-many relationship between supervisor districts and ZIP codes. A single supervisor district can contain or intersect with multiple ZIP codes and similarly, a single ZIP code can be in multiple supervisor districts. This dataset does not contain geographic boundary data (i.e. shapefiles/ GEOMs). The datasets below containing geographic boundary data should be used for analysis of data with geographic coordinates. E. RELATED DATASETS Supervisor Districts (2022) San Francisco ZIP Codes Supervisor District (2012) to ZIP Code Crosswalk Analysis Neighborhoods - 2020 census tracts assigned to neighborhoods

A listing of NYS counties with accompanying Federal Information Processing System (FIPS) and US Postal Service ZIP codes sourced from the NYS GIS Clearinghouse.

View the 2022 Zip Code to Supervisor District Crosswalk: https://data.sfgov.org/Geographic-Locations-and-Boundaries/Supervisor-District-2022-to-ZIP-Code-Crosswalk/2x22-z5j6 Lists intersecting Supervisor Districts and ZIP Codes for City and County of San Francisco.

The Plan ID Crosswalk PUF (CW-PUF) is one of the files that make up the Marketplace PUF. The purpose of the CW-PUF is to map QHPs and SADPs offered through the Marketplaces in 2014 to plans that will be offered through the Marketplaces in 2015. These data either originate from the Plan Crosswalk template (i.e., template field), an Excel-based form used by issuers to describe their plans in the QHP application process, or were generated by CCIIO for use in data processing (i.e., system-generated).This data dictionary describes the variables contained in the CW-PUF. Each record relates to a mapping between a plan offered in 2014 and a plan offered in 2015 at the county or county-zip code level.

The Plan ID Crosswalk PUF (CW-PUF) is one of the files that make up the Marketplace PUF. The purpose of the CW-PUF is to map QHPs and SADPs offered through the Marketplaces in 2018 to plans that will be offered through the Marketplaces in 2019. These data either originate from the Plan Crosswalk template (i.e., template field), an Excel-based form used by issuers to describe their plans in the QHP application process, or were generated by CCIIO for use in data processing (i.e., system-generated).This data dictionary describes the variables contained in the CW-PUF. Each record relates to a mapping between a plan offered in 2018 and a plan offered in 2019 at the county or county-zip code level.