GeoNames Forum

Hi All,

Thank you for your best work ^^

I need to make diff between real "postal code" and cedex

Example with my town :
3062520 3024035 post 29189 Concarneau
3062519 3024035 post 29187 Concarneau
3062518 3024035 post 29186 Concarneau
3062517 3024035 post 29185 Concarneau
3062516 3024035 post 29184 Concarneau
3062515 3024035 post 29183 Concarneau
3062514 3024035 post 29182 Concarneau
3062513 3024035 post 29181 Concarneau
2097457 3024035 post 29900 Concarneau

29900 is the postal of this town, the others are named CEDEX
cedex is a postal box address used by enterprise only

you can see this at this link : http://www.laposte.fr/sna/rubrique.php3?id_rubrique=59

So, do you think that is possible to have this difference in your database ?

Thank in advance

Rico

Hello,
I do n't want to speculate in answering your question (because I'm a recent user of the geonames service, in particular for the postal codes) but the CEDEX postal codes are a particularity of the french postal system.
I would be surprised that the geonames team accept to make such a change in the database.

Why do you want to make difference between postal code and CEDEX ?
If you want we can discuss this subject in private (It will be easier in french

)

MP sent

Change in database is just change isolanguage of table alternate names to post2 for CEDEX by example

I don't know if you have french customers for your web service, but actually your postal codes are not efficient in many case.

by example for the town "Paris" you have 823 postal codes in the database and only 21 are "real", 802 are only CEDEX (not need to explain why it doesn't work ^^)

I can help you if you want to make this difference.
I don't know the source of these codes, but I'am sure it's possible to do this.

Rico

We plan to add the word CEDEX to those special postcodes :
"29182 CEDEX", etc...

Thank you Christophe,

It's a good news ^^

When have you plan to do this ?

PS : don't forget that some CEDEX have this format CEDEX 01, CEDEX 02 ...

Not sure to have time before end of january

Hello,
If I give to Marc the list of CEDEX Postal code (in a text file), is it possible to make and execute a script that quickly do what you propose Geotree ?

As my datas will be certainly more recent than the geonames ones, the algorithm can be the following :

For each CEDEX postal code :
if there is an alternate name of a french place equals to this code
then update the alternate name to : $CODE + " CEDEX"
else no action

I think this should be quick to make such a php script.
What do you think about my proposition ?

(in my mind, it's not very important at this time to specify "CEDEX 01", "CEDEX 02"...etc. it will be more difficult for me and It will take me much longer to do the list)