We have two different tables for the GeoNames main database and the postal codes. For France the postal code data in the main database is now better than the postal codes data in the postal code database.
It would make sense to replace the postal code data in the postal code table with the data from the GeoNames main tables. I wanted to do this yesterday, but found some problems.
1. Some postal codes are missing in the main GeoNames database (like 69003 Lyon)
2. We have a lot more postal code placename combination in the main tables (>60000) wheres we have < 40000 in the postal code table. In this respect I wonder whether we should have a featurecode PPLA4 for seat of a fourth order administration to flag the main place of a postal code. Sometimes the same postal code is used by villages around the main city and I think it would be useful to know which one is the main city.
Marc
Postal codes from the postal code table, missing in the main database :
Code:
zip | placename
-------+----------------------------
13123 | L Albaron
13661 | Salon De Provence Air
13898 | Aix En Provence Armees
13900 | Marseille Cheques
13968 | Carpiagne Armees
13998 | Marseille Armees
16109 | Cognac Air
17135 | Rochefort Fourriers Marine
20223 | Solenzara Air
20900 | Ajaccio Cheques
21900 | Dijon Cheques
29240 | Brest Naval
30998 | Nimes Armees
31900 | Toulouse Cheques
31998 | Toulouse Armees
31999 | Andorre
33164 | Cazaux Air
33970 | Cap Ferret
33998 | Bordeaux Armees
34900 | Montpellier Cheques
35900 | Rennes Cheques
35910 | Rennes Cne
35998 | Rennes Armees
36630 | La Martinerie Terre
38900 | Grenoble Cheques
38998 | Grenoble Varces Armees
40115 | Biscarrosse Air
44900 | Nantes Cheques
50115 | Cherbourg Naval
51900 | Chalons Sur Marne Cheques
54900 | Nancy Cheques
56998 | Lorient Naval
57645 | Montoy Flanville
57998 | Metz Armees
59076 | Retours 3 Suisses
59081 | Retours Redoute
59140 | Dunkerque
59493 | Villeneuve D Ascq
59650 | Villeneuve D Ascq
59900 | Lille Cheques
59998 | Lille Armees
60149 | St Crepin Ibouvillers
63900 | Clermont Ferrand Cheques
67900 | Strasbourg Cheques
68126 | Bennwihr Gare
69001 | Lyon 01
69002 | Lyon 02
69003 | Lyon 03
69004 | Lyon 04
69005 | Lyon 05
69006 | Lyon 06
69007 | Lyon 07
69008 | Lyon 08
69009 | Lyon 09
69125 | Lyon Satolas Aeroport
69125 | Satolas Aeroport
69900 | Lyon Cheques
69998 | Lyon Armees
70301 | Luxeuil Air
74480 | Guebriant
74480 | Plateau D Assy
74730 | Martel De Janville
74780 | Praz Coutant
74790 | Sancellemoz
74810 | Mont Blanc Assy
75055 | Paris Rp
75056 | Paris Rp
75057 | Paris Rp
75058 | Paris Rp
75059 | Paris Rp
75100 | Paris Rp
75195 | Paris Rp
75196 | Paris Rp
75197 | Paris Rp
75198 | Paris Rp
75199 | Paris Rp
75348 | Paris 07 Sp
75349 | Paris 07 Sp
75350 | Paris 07 Sp
75351 | Paris 07 Sp
75352 | Paris 07 Sp
75353 | Paris 07 Sp
75354 | Paris 07 Sp
75355 | Paris 07 Sp
75356 | Paris 07 Sp
75357 | Paris 07 Sp
75358 | Paris 07 Sp
75359 | Paris 07 Sp
75700 | Paris 07 Sp
75800 | Paris
75900 | Paris Cheques
75919 | Paris Concours
76900 | Rouen Cheques
78129 | Velizy Villacoublay Air
80100 | Abbeville
80117 | Bouvaincourt Sur Bresle
83380 | Les Issambres
83800 | Toulon Naval
83898 | Draguignan Armees
83998 | Canjuers Armees
84998 | Apt Armees
86900 | Poitiers Cheques
87900 | Limoges Cheques
93210 | La Plaine Depot Du Landy
93210 | La Plaine St Denis
94390 | Aeroport D Orly
95707 | Roissy Aeroport
95707 | Sagatrans Cooperation
98000 | Monaco
(109 rows)