For many countries lat/lng are determined with an algorithm that searches the place names in the main geonames database using administrative divisions and numerical vicinity of the postal codes as factors in the disambiguation of place names. For postal codes and place name for which no corresponding toponym in the main geonames database could be found an average lat/lng of 'neighbouring' postal codes is calculated. Please let us know if you find any errors in the data set. ThanksFor Canada we have only the first letters of the full postal codes (for copyright reasons)For Ireland we have only the first letters of the full postal codes (for copyright reasons)For Malta we have only the first letters of the full postal codes (for copyright reasons)The Argentina data file contains 4-digit postal codes which were replaced with a new system in 1999.For Brazil only major postal codes are available (only the codes ending with -000 and the major code per municipality).For India the lat/lng accuracy is not yet comparable to other countries.Update frequency: 1 month

Comprehensive, weekly-updated postal and ZIP code datasets covering 247 countries...

Our United States zip code Database offers comprehensive postal code data for spatial analysis, including postal and administrative areas. This dataset contains accurate and up-to-date information on all administrative divisions, cities, and zip codes, making it an invaluable resource for various applications such as address capture and validation, map and visualization, reporting and business intelligence (BI), master data management, logistics and supply chain management, and sales and marketing. Our location data packages are available in various formats, including CSV, optimized for seamless integration with popular systems like Esri ArcGIS, Snowflake, QGIS, and more. Product features include fully and accurately geocoded data, multi-language support with address names in local and foreign languages, comprehensive city definitions, and the option to combine map data with UNLOCODE and IATA codes, time zones, and daylight saving times. Companies choose our location databases for their enterprise-grade service, reduction in integration time and cost by 30%, and weekly updates to ensure the highest quality.

Our Europe Zip Code Database offers comprehensive postal code data for spatial analysis, including postal and administrative areas for numerous European countries. This dataset contains accurate and up-to-date information on all administrative divisions, cities, and zip codes, making it an invaluable resource for various applications such as address capture and validation, map and visualization, reporting and business intelligence (BI), master data management, logistics and supply chain management, and sales and marketing. Our location data packages are available in various formats, including CSV, optimized for seamless integration with popular systems like Esri ArcGIS, Snowflake, QGIS, and more. Product features include fully and accurately geocoded data, multi-language support with address names in local and foreign languages, comprehensive city definitions, and the option to combine map data with UNLOCODE and IATA codes, time zones, and daylight saving times. Companies choose our location databases for their enterprise-grade service, reduction in integration time and cost by 30%, and weekly updates to ensure the highest quality.

A global self-hosted location dataset containing all administrative divisions, cities, and zip codes for 247 countries. All geospatial data is updated weekly to maintain the highest data quality, including challenging countries such as China, Brazil, Russia, and the United Kingdom.

Use cases for the Global Zip Code Database (Geospatial data)

• Address capture and validation

• Map and visualization

• Reporting and Business Intelligence (BI)

• Master Data Mangement

• Logistics and Supply Chain Management

• Sales and Marketing

Data export methodology

Our location data packages are offered in variable formats, including .csv. All geospatial data are optimized for seamless integration with popular systems like Esri ArcGIS, Snowflake, QGIS, and more.

Product Features

• Fully and accurately geocoded

• Administrative areas with a level range of 0-4

• Multi-language support including address names in local and foreign languages

• Comprehensive city definitions across countries

For additional insights, you can combine the map data with:

• UNLOCODE and IATA codes

• Time zones and Daylight Saving Times

Why do companies choose our location databases

• Enterprise-grade service

• Reduce integration time and cost by 30%

• Weekly updates for the highest quality

Note: Custom geospatial data packages are available. Please submit a request via the above contact button for more details.

This dataset is part of the Geographical repository maintained by Opendatasoft. It's been built from the ground up using authoritative sources including the U.S. Postal Service™, U.S. Census Bureau, National Weather Service, American Community Survey, and the IRS.Contains most USPS zip codes (lat/long).

Our Canada zip code Database offers comprehensive postal code data for spatial analysis, including postal and administrative areas. This dataset contains accurate and up-to-date information on all administrative divisions, cities, and zip codes, making it an invaluable resource for various applications such as address capture and validation, map and visualization, reporting and business intelligence (BI), master data management, logistics and supply chain management, and sales and marketing. Our location data packages are available in various formats, including CSV, optimized for seamless integration with popular systems like Esri ArcGIS, Snowflake, QGIS, and more. Product features include fully and accurately geocoded data, multi-language support with address names in local and foreign languages, comprehensive city definitions, and the option to combine map data with UNLOCODE and IATA codes, time zones, and daylight saving times. Companies choose our location databases for their enterprise-grade service, reduction in integration time and cost by 30%, and weekly updates to ensure the highest quality.

Abstract

A crosswalk table from US postal ZIP codes to geo-points (latitude, longitude)

Documentation

Data source: public.opendatasoft.

The ZIP code database contained in 'zipcode.csv' contains 43204 ZIP codes for the continental United States, Alaska, Hawaii, Puerto Rico, and American Samoa. The database is in comma separated value format, with columns for ZIP code, city, state, latitude, longitude, timezone (offset from GMT), and daylight savings time flag (1 if DST is observed in this ZIP code and 0 if not).

This database was composed using ZIP code gazetteers from the US Census Bureau from 1999 and 2000, augmented with additional ZIP code information The database is believed to contain over 98% of the ZIP Codes in current use in the United States. The remaining ZIP Codes absent from this database are entirely PO Box or Firm ZIP codes added in the last five years, which are no longer published by the Census Bureau, but in any event serve a very small minority of the population (probably on the order of .1% or less). Although every attempt has been made to filter them out, this data set may contain up to .5% false positives, that is, ZIP codes that do not exist or are no longer in use but are included due to erroneous data sources. The latitude and longitude given for each ZIP code is typically (though not always) the geographic centroid of the ZIP code; in any event, the location given can generally be expected to lie somewhere within the ZIP code's "boundaries".The ZIP code database contained in 'zipcode.csv' contains 43204 ZIP codes for the continental United States, Alaska, Hawaii, Puerto Rico, and American Samoa. The database is in comma separated value format, with columns for ZIP code, city, state, latitude, longitude, timezone (offset from GMT), and daylight savings time flag (1 if DST is observed in this ZIP code and 0 if not). This database was composed using ZIP code gazetteers from the US Census Bureau from 1999 and 2000, augmented with additional ZIP code information The database is believed to contain over 98% of the ZIP Codes in current use in the United States. The remaining ZIP Codes absent from this database are entirely PO Box or Firm ZIP codes added in the last five years, which are no longer published by the Census Bureau, but in any event serve a very small minority of the population (probably on the order of .1% or less). Although every attempt has been made to filter them out, this data set may contain up to .5% false positives, that is, ZIP codes that do not exist or are no longer in use but are included due to erroneous data sources. The latitude and longitude given for each ZIP code is typically (though not always) the geographic centroid of the ZIP code; in any event, the location given can generally be expected to lie somewhere within the ZIP code's "boundaries".

The database and this README are copyright 2004 CivicSpace Labs, Inc., and are published under a Creative Commons Attribution-ShareAlike license, which requires that all updates must be released under the same license. See http://creativecommons.org/licenses/by-sa/2.0/ for more details. Please contact schuyler@geocoder.us if you are interested in receiving updates to this database as they become available.The database and this README are copyright 2004 CivicSpace Labs, Inc., and are published under a Creative Commons Attribution-ShareAlike license, which requires that all updates must be released under the same license. See http://creativecommons.org/licenses/by-sa/2.0/ for more details. Please contact schuyler@geocoder.us if you are interested in receiving updates to this database as they become available.

The official postal code database is a data set that provides the correspondence between the postal codes and the INSEE codes of the municipalities, of France (metropolis and DOM), of the TOMs, as well as of MONACO. This data set includes:- The name of the municipality- The INSEE code of the municipality- Line 5 of the postal address: precision of the associated locality or the name of the associated delegated municipality- The postal code of the municipality - The routing label

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.

Includes Maryland Zip Codes and their corresponding cities/towns, and counties.

Our Egypt zip code Database offers comprehensive postal code data for spatial analysis, including postal and administrative areas. This dataset contains accurate and up-to-date information on all administrative divisions, cities, and zip codes, making it an invaluable resource for various applications such as address capture and validation, map and visualization, reporting and business intelligence (BI), master data management, logistics and supply chain management, and sales and marketing. Our location data packages are available in various formats, including CSV, optimized for seamless integration with popular systems like Esri ArcGIS, Snowflake, QGIS, and more. Product features include fully and accurately geocoded data, multi-language support with address names in local and foreign languages, comprehensive city definitions, and the option to combine map data with UNLOCODE and IATA codes, time zones, and daylight saving times. Companies choose our location databases for their enterprise-grade service, reduction in integration time and cost by 30%, and weekly updates to ensure the highest quality.

This dataset is part of the Geographical repository maintained by Opendatasoft.This dataset contains data for zip codes 5 digits in United States of America.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.Processors and tools are using this data.EnhancementsAdd ISO 3166-3 codes.Simplify geometries to provide better performance across the services.Add administrative hierarchy.

This dataset mainly provides a matching table of 3-digit postal codes and the coordinates of administrative district centers.

ZIP Code Tabulation Areas (ZCTAs)ZIP Code Tabulation Areas (ZCTAs) are generalized areal representations of United States Postal Service (USPS) ZIP Code service areas.The USPS ZIP Codes identify the individual post office or metropolitan area delivery station associated with mailing addresses. USPS ZIP Codes are not areal features but a collection of mail delivery routes.The term ZCTA was created to differentiate between this entity and true USPS ZIP Codes. ZCTA is a trademark of the U.S. Census Bureau; ZIP Code is a trademark of the U.S. Postal Service.How ZCTAs are CreatedThe Census Bureau first examined all of the addresses within each census block to define the list of ZIP Codes by block. Next, the most frequently occurring ZIP Code within each block was assigned to the entire census block as a preliminary ZCTA code. After all of the census blocks with addresses were assigned a preliminary ZCTA code, blocks were aggregated by code to create larger areas.The Census Bureau assigned blocks that contained addresses, but did not have a single most frequently occurring ZIP Code to the ZCTA with which the blocks had the longest shared boundary.If the area of an unassigned enclave was less than two square miles, it was assigned to the surrounding ZCTA. The Census Bureau used block group boundaries to identify and group unassigned blocks. These unassigned blocks were merged into an adjacent ZCTA based on the length of shared boundary.For the Census 2000 ZCTAs the Census Bureau created ZCTAs that ended in "XX" to represent large areas of land without ZIP Codes or "HH" to represent large areas of water without ZIP Codes. For the 2010 Census, large water bodies and large unpopulated land areas do not have ZCTAs.ZCTAs were created using residential and nonresidential ZIP Codes that are available in the Census Bureau’s MAF/TIGER database. ZIP Codes assigned to businesses only or single delivery point address will not necessarily appear as ZCTAs.In most instances the ZCTA code is the same as the ZIP Code for an area.In creating ZCTAs, the Census Bureau took the most frequently occurring ZIP Code in an area for the ZCTA code. Some addresses will end up with a ZCTA code different from their ZIP Code.Some ZIP Codes represent very few addresses (sometimes only one) and therefore will not appear in the ZCTA universe.Key Differences between Census 2000 and 2010 Census ZCTAsCensus 2000Includes the U.S. and Puerto RicoCover the full extent of the nation - "wall-to-wall" coverage3-digit and 5-digit ZCTA's available"XX" suffix used to represent large land areas such as national parks"HH" suffix used to represent large water bodies2010 CensusIncludes the U.S., Puerto Rico, and the Island AreasDo not cover the full extent of the nation - "holes" exist5-digit ZCTA's only"XX" retired - Large land areas such as national parks do not have ZCTA coverage"HH" retired - Large water bodies do not have ZCTA coverage

The official postal code database is a dataset that provides the correspondence between the postal codes and the INSEE codes of the communes of the territory of Grand PoitiersThis dataset includes:- The name of the commune- The INSEE code of the commune- The line 5 of the postal address: precision of the associated locality or the name of the associated delegated municipality - The postal code of the municipality - The delivery label

Our Iran zip code Database offers comprehensive postal code data for spatial analysis, including postal and administrative areas. This dataset contains accurate and up-to-date information on all administrative divisions, cities, and zip codes, making it an invaluable resource for various applications such as address capture and validation, map and visualization, reporting and business intelligence (BI), master data management, logistics and supply chain management, and sales and marketing. Our location data packages are available in various formats, including CSV, optimized for seamless integration with popular systems like Esri ArcGIS, Snowflake, QGIS, and more. Product features include fully and accurately geocoded data, multi-language support with address names in local and foreign languages, comprehensive city definitions, and the option to combine map data with UNLOCODE and IATA codes, time zones, and daylight saving times. Companies choose our location databases for their enterprise-grade service, reduction in integration time and cost by 30%, and weekly updates to ensure the highest quality.

The official database of postal codes is a dataset which provides the correspondence between postal codes and the INSEE codes of municipalities.

This dataset includes:

< li>The name of the municipality
• The INSEE code of the municipality
• Line 5 of the postal address: precision of the associated locality or the name of the associated delegated municipality
• The postal code of the municipality
• The delivery wording

This dataset was created to help users to go between County - State Name, State-County FIPS, City, or to ZIP Code. Most importantly, this dataset was created because we shouldn't have to pay for free & public data.

Assumptions - HUD uses the most up to date Zip Code boundaries from the USPS when they post their new Quarterly data. *ZIP Codes are updated on a regular basis. Here is an example announcement from the USPS. - City data only available from 2018 onward.

Data Sources

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

Census Bureau The table data, direct link. This data is only updated once every census, 10 years. The details of the National County text file can be found here

USPS Zip to City Lookup More information can be found here. It's a free API from the USPS. Need to create a username to pull the data.

Data Dictionary

Files 2018 -> Newer - ZIP ZIP Code - STCOUNTFP US State & County FIPS ID - CITY City for that Zip/Fips Code - STATE US State - COUNTYNAME US County Name - CLASSFP FIPS Class Code, as defined by the Census

Files 2010-2017 - ZIP ZIP Code - COUNTYNAME US County Name - STATE US State - STCOUNTFP US State & County FIPS ID - CLASSFP FIPS Class Code, as defined by the Census

FIPS Class Code Details Source Copied 7/29/17

• H1 identifies an active county or statistically equivalent entity that does not qualify under subclass C7 or H6.
• H4 identifies a legally defined inactive or nonfunctioning county or statistically equivalent entity that does not qualify under subclass H6.
• H5 identifies census areas in Alaska, a statistical county equivalent entity.
• H6 identifies a county or statistically equivalent entity that is a really coextensive or governmentally consolidated with an incorporated place, part of an incorporated place, or a consolidated city.
• C7 identifies an incorporated place that is an independent city; that is, it also serves as a county equivalent because it is not part of any county, and a minor civil division (MCD) equivalent because it is not part of any MCD.

Acknowlegement

Foto von Annie Spratt auf Unsplash

From Statistics Canada release email 16 June 2022 The Postal Code Project is responsible for linking the approximately 900,000 single postal codes in Canada to Statistics Canada’s Census dissemination geography (presently 2021 Census geographic areas). The term population centre will replace the term urban area. A population centre will be defined as an area with a population of at least 1,000 and a density of 400 or more people per square kilometre. All areas outside population centres will continue to be defined as rural area. This new terminology will be implemented consistently across the Agency. Population centres will be divided into three groups based on the size of their population to reflect the existence of an urban-rural continuum: small population centres, with a population of between 1,000 and 29,999; medium population centres, with a population of between 30,000 and 99,999; large urban population centres, consisting of a population of 100,000 and over. Population centre and rural area classification has been added to the file.