Completely tuned with Ryan on this, I have to cope those days with data
where places (in france) are "identified" by Name + Postal code, that
have to be attached to cities identified by insee codes or geonames id
(we have the mapping). What happens in France is roughly as following
- Big cities have several postal codes.
- Some small-to-middle cities can be uniquely identified by a single
postal code.
- Many small villages share a postal code with their neighbours and a
local city.
Only in the second case the use of postal code as alternate name can
make sense, but I agree it should be stored in a specific field.
Bernard
--
*Bernard Vatant
*Senior Consultant
Vocabulary & Data Engineering
Tel: +33 (0) 971 488 459
Mail: bernard...@mondeca.com <mailto:bernard...@mondeca.com>
----------------------------------------------------
*Mondeca**
*3, cité Nollez 75018 Paris France
Web: www.mondeca.com <http://www.mondeca.com>
Blog: Leçons de Choses <http://mondeca.wordpress.com/>
----------------------------------------------------**
Do you have concrete examples where it does not work? For Paris as far
as I know each postal codes also has a proper name and if it is only the
number of the Arrondissement. (Ex 75013= 13e Arrondissement,13eme
Arr,13ème Arr,Arrondissement des Gobelins,Gobelins,Paris 13e,XIIIe)
In the third case where several villages share the same postal code the
code is just added to each of the villages sharing the code.