Latest posts for the topic "Missing 146 french cities"

Missing 146 french cities

noovea — GMT

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

Missing 146 french cities

geotree — GMT

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

Re:Missing 146 french cities

noovea — GMT

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

Missing 146 french cities

geotree — GMT

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.

[RESOLVED] Re:Missing 146 french cities

noovea — GMT

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

Re:Missing 146 french cities

noovea — GMT

@geotree: Can you send me your csv file please ? I think this could help us ! Thanks

Re:Missing 146 french cities

artigas — GMT

Greetings Geotree - Could you please post or send me the csv file? Thanks In Advance. Kindest Regards,

Missing 146 french cities

geotree — GMT

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

Re:Missing 146 french cities

noovea — GMT

Thanks a lots geotree ! Is it possible to have the zipcode of DOM-TOM too please ?

Re:Missing 146 french cities

noovea — GMT

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 ? :-)

Re:Missing 146 french cities

geotree — GMT

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

Re:Missing 146 french cities

geotree — GMT

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.

Re:Missing 146 french cities

noovea — GMT

Ok, I understood now. Thanks again for your help ! :-)

Re:Missing 146 french cities

noovea — GMT

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 !

Re:Missing 146 french cities

geotree — GMT

noovea wrote:

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

Not yet ;-)

Missing 146 french cities

Vegard — GMT

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!

Re:Missing 146 french cities

geotree — GMT

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

Re:Missing 146 french cities

noovea — GMT

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

Re:Missing 146 french cities

Vegard — GMT

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.

Re:Missing 146 french cities

smg — GMT

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

Re:Missing 146 french cities

marc — GMT

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

You are right. This will be fixed. Marc

Re:Missing 146 french cities

IanPure — GMT

Hello Does anyone have a D/Base of: Region>Department>Town>INSEE>Postcode? Is this available? Would save a few hours/nights of work :) Many Thanks in Advance Ian[i]