GeoNames Forum

In which download are the Postal Codes?
I'd like to be able to search based on Postal Code and return City, State, Country...

Just have a look to download page :
http://www.geonames.org/export/

There is a link to Postal Codes download :
http://download.geonames.org/export/zip

Thanks for the quick reply... I saw that but I wonder if I download the 800MB all countries list, that is a super set of what you pasted in above, right?

There is one file per country
and a file allCountries containing ... all countries

Yep... let me be more specific.... what I was asking is,

is: http://download.geonames.org/export/dump/allCountries.zip
a super set of:
http://download.geonames.org/export/zip/allCountries.zip

or is there data in: http://download.geonames.org/export/zip/allCountries.zip that is not in the other?

http://download.geonames.org/export/zip/
contains ONLY postal codes

when
http://download.geonames.org/export/dump/
contains all GeoNames records

For some countries like France, postal codes can also be found in
http://download.geonames.org/export/dump/alternateNames.zip
with language code = 'post'

OK, that makes sense... and I guess I have just one more question.

If I import the giant geonames database, i I follow the steps at:
http://forum.geonames.org/gforum/posts/list/732.page
to populate the other tables, have I duplicated work?

What would be the point of these extra tables if I have the giant geonames table?

Read this thread :
http://forum.geonames.org/gforum/posts/list/2033.page
to get everything (except postal codes) in your local MySQL database.

Hi,
How i can use postal codes in my local database ?

Thx

phoenix wrote:

How i can use postal codes in my local database ?

May you explain what you want to do with postal codes (form pre-filling ? form validation ? etc) and for which countries ?

I wont to write function that return the same information of " findNearbyPostalCodes "

I used this SQL query for latitude:40.5720500 and longitude: -74.6412700

mysql> SELECT *, (ACOS((SIN(40.5726013183594/57.295

* SIN(latitude/57.295

) + (COS(40.5726013183594/57.295

* COS(latitude/57.295

* COS(longitude/57.2958 - (-74.6423034667969)/57.295

))) * 3963 AS distance FROM geoname WHERE (latitude >= 40.5726013183594 - (10/111)) AND (latitude <= 40.5726013183594 + (10/111)) AND (longitude >= (-74.6423034667969) - (10/111))AND (longitude <= (-74.6423034667969) + (10/111)) ORDER BY distance ASC limit 5 \G
*************************** 1. row ***************************
geonameid: 5103137
name: Borough of Raritan
asciiname: Borough of Raritan
alternatenames:
latitude: 40.5720500
longitude: -74.6412700
fclass: A
fcode: ADMD
country: US
cc2:
admin1: NJ
admin2: 035
admin3:
admin4:
population: 0
elevation: 29
gtopo30: 27
timezone: America/New_York
moddate: 2007-02-14
distance: 0.0663497418948286

I used the webservice for the same data ( http://ws.geonames.org/findNearbyPostalCodes?lat=40.5726013183594&lng=-74.6423034667969 ) and i find the postal code, but in local i can't find this information, my question is in any table i found the postal code ?

Thx

you have to download the data from the postal code directory (see link above). You are currently using the toponym files, which have postal codes for some countries in the alternatename table.

Marc