Where can I get postal codes for all countries?

Question

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?

score 63 · Accepted Answer · answered Nov 21 '08 at 06:14

63

My guess is that your lost friend is GeoNames.

answered Nov 21 '08 at 06:14

activout.se

6,058
4
27
37

GeoNames is an excellent site, and Marc is incredibly helpful if you can't quite find what you want. I've just emailed him about some geodata I need and he replied quickly with exactly what I needed. – Andrew Nov 21 '08 at 07:19
3

You can download postal code to name,lat,lng from their site here: http://download.geonames.org/export/zip/ – slacy Oct 08 '09 at 19:31
geoNames is probably closest you can find of free worldwide postal codes and they are updated daily. The downside is that they are missing for alot of countries. GeoNames accomodates for 91 countries, but omits about 160+ other countries found at https://www.geopostcodes.com/resources#countries . Also be aware that each country classifies areas within differently, Cities are mostly under "place_name" but also sometimes found under admin_name2 and 3. – Dec 06 '19 at 01:34
There is also a very good and complete database (paid) at https://mapanet.eu – user2033838 Apr 07 '22 at 02:17

Zon · Answer 2 · 2020-11-02T04:51:25.130

8

Find all countries at GeoNames or run a ready-parsed MySQL script (INSERTs):

Download delivery_zip.zip (11 Mb)

edited Nov 02 '20 at 04:51

answered Aug 16 '13 at 09:51

Zon

18,610
7
91
99

4

Thanks for the efforts you made. You could also zip this 286 MB file that makes it just 11.5MB, hence easy to download. Get the [same file here 11.6 MB](https://www.dropbox.com/s/mj95fbx6uk6hstf/delivery_zip.sql.zip?dl=0) – Izhar Aazmi Apr 23 '16 at 06:36
2

Hello, was anyone able to check if the attached sql file is clean, it is a huge file, my editor Notepad++ cannot even go to the end of the file, – hazimdikenli Sep 28 '17 at 07:25
1

You can open it using HeidiSQL in a safe testing environment inside a testing database. Use VirtualBox or Docker to create an environment you're not feared to damage. Or even a linux booting from a usb flash-card. – Zon Sep 30 '17 at 18:54
1

You can also use my [Big Text Browser](http://blog.gio.palacino.com/big-text-browser/) for opening massive text files, it's totally free. – Gio Dec 25 '17 at 18:43

score 6 · Answer 3 · answered Nov 21 '08 at 06:27

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:

score 4 · Answer 4 · answered Oct 21 '20 at 15:58

4

I'm currently using this one: https://www.back4app.com/database/back4app/zip-codes-all-countries-in-the-world it's free and very useful!

It's also possible to collaborate with this dataset, in order to improve it even more. :)

answered Oct 21 '20 at 15:58

Charles

531
2
11

1

Amazing solution! – Federico Navarrete Mar 31 '22 at 09:22

score 0 · Answer 5 · answered Feb 12 '20 at 18:58

0

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.

answered Feb 12 '20 at 18:58

searain

3,143
6
28
60

score 0 · Answer 6 · answered Nov 02 '22 at 08:19

0

Checkout postal code database . Its low cost,free updates as well for over a year. Video demonstration of the database and supported fields on youtube https://www.youtube.com/watch?v=PzjHzMDKyYw

answered Nov 02 '22 at 08:19

Ganesh S

371
6
26

Where can I get postal codes for all countries?

6 Answers6

Linked