I once read about an open source database for postal codes with geolocation data but now I can't remember its name. Can someone help?
相关问题
- NOT DISTINCT query in mySQL
- Flush single app django 1.9
- keeping one connection to DB or opening closing pe
- Mysql-installer showing error : Memoy could not be
- Android Room Fetch data with dynamic table name
相关文章
- Connection pooling vs persist connection mysqli
- Speed up sqlFetch()
- How Do I Seed My Database in the setupBeforeClass
- I set a MySQL column to “NOT NULL” but still I can
- Where in Django can I run startup code that requir
- Google OAuth 2.0 User id datatype for MYSQL
- Restore deleted records in PostgreSQL
- SQLSTATE[HY000] [2002] Permission denied
My guess is that your lost friend is GeoNames.
You're looking for an Open GIS database - the main keyword being "GIS". This will help you find results.
The information you're looking for is usually Commercial grade (i.e. you need to pay for the data), but you can see what's available on the open-source GIS websites:
Find all countries at GeoNames or run a ready-parsed MySQL script (INSERTs):
Download delivery_zip.sql (11 Mb)
Yes Geonames is the place. To be more specific as slacy said
https://download.geonames.org/export/zip/
It has a list of countries' postal codes and it has an allCountries zip file.
And the data is updated daily.