Latest posts for the topic "Postal Codes"

Postal Codes

john_es — GMT

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

Re:Postal Codes

geotree — GMT

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

Re:Postal Codes

john_es — GMT

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?

Re:Postal Codes

geotree — GMT

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

Re:Postal Codes

john_es — GMT

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?

Re:Postal Codes

geotree — GMT

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'

Re:Postal Codes

john_es — GMT

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?

Re:Postal Codes

geotree — GMT

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

Re:Postal Codes

phoenix — GMT

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

Re:Postal Codes

geotree — GMT

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 ?

Re:Postal Codes

phoenix — GMT

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.2958) * SIN(latitude/57.2958)) + (COS(40.5726013183594/57.2958) * COS(latitude/57.2958) * COS(longitude/57.2958 - (-74.6423034667969)/57.2958)))) * 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

Re:Postal Codes

marc — GMT

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