GeoNames Forum

Hello,

We have downloaded the postal code, latitude and longitude information from geoname for some cities in our database.

You can see in the file attached to this ticket, the list of cities not found in geonames.

There is about 146 cities, most of them come from the Corse island or from the DOM-TOM.

Here is an extract of the attached CSV file :
Code:

 "Code INSEE (AdminCode4)"	"city"	"zipcode"
 "03068"	"Châtelus"	"03640"
 "04191"	"Saint-Martin-lès-Seyne"	"04460"
 "2A011"	"Altagène"	"\N"
 "2B156"	"Mausoléo"	"\N"
 "2B161"	"Moïta"	"\N"
 "2B230"	"Piève"	"\N"
 "50520"	"Saint-Martin-le-Hébert"	"\N"
 "55239"	"Haumont-près-Samogneux"	"\N"
 "55307"	"Louvemont-Côte-du-Poivre"	"\N"
 "65141"	"Cazaux-Fréchet-Anéran-Camors"	"65510"
 "65195"	"Génos"	"65510"
 "65307"	"Mazères-de-Neste"	"65660"
 "80463"	"Lamotte-Warfusée"	"80720"
 "97101"	"Les Abymes"	"97139"
 "97102"	"Anse-Bertrand"	"97121"

Like you can see, sometime we also have the postal code, but even if we search on GeoName with this postal code, it's not found.

Any help will be appreciated

Thanks

Where do your data come from ?
Please check your "list of cities not found in geonames"

Ex: La Membrolle-sur-Longuenée
can be found in geonames :
http://www.geonames.org/search.html?q=membrolle,49
with correct zipcode : 49770

Hello,

The list of cities is the official list, from the INSEE database.

But, the INSEE list of cities doesn't include postal codes, it's a different code, named INSEE code (alias AdminCode4).

After, I have used the Galichon.com database to associate postal code, latitude and longitude of an INSEE code. (matching about 90% of the cities).

And then, I have make a script that connecting to GeoNames to resolve the 3000 incomplete cities. Most of them have been updated correctly, but I have theses 146 cities where I can't find the data.

In your example, the standard search with the name "La Membrolle-sur-Longuenée" is not found, but if we search with the word "membrolle", this seems to works.

So, I'll try to adapt my script to split composed name into individual research.

Thanks

galichon.com is out of date
I can send you a csv file with all postalcodes recent changes from LaPoste :
geonameid, name, insee, postalcode

and for searching names such as "La Membrolle-sur-Longuenée", don't forget to use UTF-8 encoding.

I just found where is the problem.

The most part of theses cities are not associated to the country "FR", and my script used "country=FR".

It's now resolved.

Thanks

@geotree: Can you send me your csv file please ?

I think this could help us !

Thanks

Greetings Geotree -

Could you please post or send me the csv file?

Thanks In Advance.

Kindest Regards,

Dump file is here :
http://geotree.geonames.org/download/FR-postcode-dump-2010-03-30.zip

Thanks a lots geotree !

Is it possible to have the zipcode of DOM-TOM too please ?

Hello,

There is about 226 cities in your CSV file where you have 2 differents zipcode for the same city.

For example, look the line 78 :
01190 BOISSEY 01050 Boissey 3031928

and the line 254 :
01380 BOISSEY 01050 Boissey 3031928

So.. which one is the good one ?

A lot of cities have more than one postal code depending on the street.

Check BOISSEY here :
http://www.laposte.fr/Particulier/Utilisez-nos-outils-pratiques/Outils-et-documents/Trouvez-un-code-postal

noovea wrote:

Is it possible to have the zipcode of DOM-TOM too please ?

Not sure they are up-to-date in GeoNames.
I will check and let you know.

Ok, I understood now.

Thanks again for your help !

Hi Christophe,

Have you found the time to check the zipcode of DOM-TOM ?
This will be really appreciate if you can help us with a similar CSV file with DOM-TOM zipcodes.

Thanks !

noovea wrote:

Have you found the time to check the zipcode of DOM-TOM ?
Thanks !

Not yet

geotree wrote:

Dump file is here :
http://geotree.geonames.org/download/FR-postcode-dump-2010-03-30.zip

Christophe, I can not download this file, could you kindly advise?

Thanks in advance!

Due to recent server crash, the download folder was missing.
Now it is back again

http://geotree.geonames.org/download/FR-postcode-dump-2010-03-30.zip

Christophe,

Can you tell me the source where you have retrieved theses postal codes ?
Because, may be I can directly search at this source for the DOM-TOM postal codes, to prevent you to spent time for this ?

Thanks

geotree wrote:

Due to recent server crash, the download folder was missing.
Now it is back again
http://geotree.geonames.org/download/FR-postcode-dump-2010-03-30.zip

Christophe,
Thanks for the quick reply and fix.

Hi,
Time zone for Les Abymes (6690387) seems "Europe/Berlin", shouldn't it be "America/Guadeloupe" ?