thank’s. i think that are 20 new postal codes, remaining 321 al8 missings.
I’ve added AL9 to my analysis and now i got 381 missings.
why not? No data avaliable or do you need al8/al9 for that?
should i filter on med france at first? ignoring the oversee areas (polynesia, fr. guiane and other) ? I think that will make it easier to you.
My analysis was and is exactliy for that: Areas without addr:postcode AND without postal_code. So what are you missing?
one big question is: how do you want to tag postcode areas in france?
addr:postcode=* like the other 95% of frence admin borders or postal_code=* like in germany?
looking on other countries, there is a litte “trend” toi use addr:postcode, but germany will not change that.
I don’t care very much, i only want to be it unique in one country.
id | admin_level | ref:INSEE | name | addr:postcode | postal_code
---------+-------------+-----------+----------------------------+---------------+-------------------------
365717 | 8 | 04049 | Château-Arnoux-Saint-Auban | 04160 | 04160
365925 | 8 | 04244 | Volonne | 04290 | 04290
2084758 | 8 | 07083 | Dunière-sur-Eyrieux | 07360 | 07360
2003898 | 8 | 07167 | Les Ollières-sur-Eyrieux | 07360 | 07360
87515 | 8 | 07186 | Privas | 07000 | 07000
1314743 | 8 | 10014 | Assencières | 10220 | 10220
281004 | 8 | 14119 | Cagny | 14630 | 14630
172204 | 8 | 14287 | Frénouville | 14630 | 14630
116435 | 8 | 15267 | Ytrac | 15000 | 15000;15130
116767 | 8 | 17168 | Fouras | 17450 | 17450
386631 | 8 | 22157 | Le Moustoir | 22340 | 22340
68506 | 8 | 26070 | Chamaret | 26230 | 26230
68399 | 8 | 26099 | Colonzelle | 26230 | 26230
536176 | 8 | 27474 | Poses | 27740 | 27740
1400527 | 8 | 29024 | Carhaix-Plouguer | 29270 | 29270
1535547 | 8 | 29205 | Plounévézel | 29270 | 29270
105270 | 8 | 33063 | Bordeaux | 33000 | 33000;33100;33300;33800
525565 | 8 | 33293 | Montussan | 33450 | 33450
88799 | 8 | 33330 | Pompignac | 33370 | 33370
1270492 | 8 | 33516 | Soussac | 33790 | 33790
525577 | 8 | 33554 | Yvrac | 33370 | 33370
105058 | 8 | 37036 | Braye-sur-Maulne | 37330 | 37330
105070 | 8 | 37137 | Lublé | 37330 | 37330
105066 | 8 | 37146 | Marcilly-sur-Maulne | 37330 | 37330
104979 | 8 | 37279 | Villiers-au-Bouin | 37330 | 37330
276603 | 8 | 41020 | Bonneveau | 41800 | 41800
944996 | 8 | 42096 | Fontanès | 42140 | 42140
1902026 | 8 | 49052 | Broc | 49490 | 49490
1901826 | 8 | 49062 | Chalonnes-sous-le-Lude | 49490 | 49490
1782037 | 8 | 49197 | Meigné-le-Vicomte | 49490 | 49490
286388 | 8 | 62774 | Sangatte | 62231 | 62231
111758 | 8 | 63030 | Bas-et-Lezat | 63310 | 63310
125616 | 8 | 63459 | Villeneuve-les-Cerfs | 63310 | 63310
168236 | 8 | 64274 | Irouléguy | 64220 | 64220
78588 | 8 | 67016 | Avolsheim | 67120 | 67120
88855 | 8 | 67018 | Balbronn | 67310 | 67310
93338 | 8 | 67030 | Bergbieten | 67310 | 67310
89440 | 8 | 67077 | Cosswiller | 67310 | 67310
79372 | 8 | 67085 | Dangolsheim | 67310 | 67310
62749 | 8 | 67098 | Dinsheim-sur-Bruche | 67190 | 67190
93339 | 8 | 67139 | Flexbourg | 67310 | 67310
75457 | 8 | 67300 | Molsheim | 67120 | 67120
75456 | 8 | 67313 | Mutzig | 67190 | 67190
932979 | 8 | 67328 | Niedermodern | 67350 | 67350
1165170 | 8 | 67347 | Obermodern-Zutzendorf | 67330 | 67330
89013 | 8 | 67408 | Romanswiller | 67310 | 67310
78772 | 8 | 67473 | Soultz-les-Bains | 67120 | 67120
93467 | 8 | 67480 | Still | 67190 | 67190
88845 | 8 | 67492 | Traenheim | 67310 | 67310
88962 | 8 | 67517 | Wangen | 67520 | 67520
88868 | 8 | 67525 | Westhoffen | 67310 | 67310
77009 | 8 | 67554 | Wolxheim | 67120 | 67120
85665 | 8 | 68249 | Orbey | 68370 | 68370
161076 | 8 | 70120 | Champagney | 70290 | 70290
900621 | 8 | 70546 | Vereux | 70180 | 70180
107421 | 8 | 72034 | Bérus | 72610 | 72610
107441 | 8 | 72035 | Bessé-sur-Braye | 72310 | 72310
108450 | 8 | 72064 | La Chapelle-Huon | 72310 | 72310
216518 | 8 | 77333 | Nemours | 77140 | 77140
88790 | 8 | 77431 | Saint-Pierre-lès-Nemours | 77140 | 77140
444225 | 8 | 78502 | Le Port-Marly | 78560 | 78560
1550591 | 8 | 80043 | Authie | 80560 | 80560
1669044 | 8 | 80705 | Saint-Léger-lès-Authie | 80560 | 80560
144896 | 8 | 82109 | Merles | 82210 | 82210
145017 | 8 | 82166 | Saint-Michel | 82340 | 82340
102478 | 8 | 84007 | Avignon | 84000 | 84000
2646262 | 8 | 89001 | Accolay | 89460 | 89460
2078335 | 8 | 89100 | Chéroy | 89690 | 89690
2615470 | 8 | 89238 | Mailly-le-Château | 89660 | 89660
1950336 | 8 | 89314 | Prégilbert | 89460 | 89460
3333585 | 8 | 89394 | Sery | 89270 | 89270
3333569 | 8 | 89424 | Trucy-sur-Yonne | 89460 | 89460
129550 | 8 | 93006 | Bagnolet | 93170 | 93170
131240 | 8 | 93008 | Bobigny | 93000 | 93000
130544 | 8 | 93045 | Les Lilas | 93260 | 93260
67685 | 8 | 93055 | Pantin | 93500 | 93500
130632 | 8 | 93063 | Romainville | 93230 | 93230
104271 | 8 | 94002 | Alfortville | 94140 | 94140
104868 | 8 | 94018 | Charenton-le-Pont | 94220 | 94220
104268 | 8 | 94022 | Choisy-le-Roi | 94600 | 94600
105404 | 8 | 94046 | Maisons-Alfort | 94700 | 94700
3152851 | 9 | 27257 | Forêt-la-Folie | 27510 | 27510
(82 Zeilen)
walter