Postal code management.
Project description
A simple data model for storing postal codes with placenames and location.
Getting data
Postal code data is available from a number of sources, typically on a country by country basis. The United States Census Bureau maintains the Gazetteer database, including detailed zip code data. The GeoNames geographical database also provides postal code data for international postal codes (and other places).
Rather than include data files which may be of little to no use for many users, you can import data from the aformentioned sources, or use one of two SQL files I’ve made available based on the GeoNames data. Each file contains a multi-value insert and has been tested in PostgreSQL. The same queries should work in MySQL, although they will require modification to be of use with Sqlite.
International postal codes (9 MB)
The data is licensed under the Database Contents License.
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.