GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Postal code dump for Germany  XML
Forum Index -> Postal Codes
Author Message
yankee2d



Joined: 10/10/2008 22:14:56
Messages: 1
Offline

Hi all
If you want to have consistent adm1codes in german postcode datatabase, you can use the following script


Code:
 update postcode set adm1code='01' where country='DE' and adm1code='BW';
 update postcode set adm1code='02' where country='DE' and adm1code='BY';
 update postcode set adm1code='03' where country='DE' and adm1code='HB';  
 update postcode set adm1code='04' where country='DE' and adm1code='HH';  
 update postcode set adm1code='05' where country='DE' and adm1code='HE'; 
 update postcode set adm1code='06' where country='DE' and adm1code='NI';  
 update postcode set adm1code='07' where country='DE' and adm1code='NW';
 update postcode set adm1code='08' where country='DE' and adm1code='RP';
 update postcode set adm1code='09' where country='DE' and adm1code='SL';
 update postcode set adm1code='10' where country='DE' and adm1code='SH';  
 update postcode set adm1code='11' where country='DE' and adm1code='BB'; 
 update postcode set adm1code='12' where country='DE' and adm1code='MV';
 update postcode set adm1code='13' where country='DE' and adm1code='SN';  
 update postcode set adm1code='14' where country='DE' and adm1code='ST'; 
 update postcode set adm1code='15' where country='DE' and adm1code='TH';
 update postcode set adm1code='16' where country='DE' and adm1code='BE'; 
 


Then optionally if you want to have german names by default in admin1codes table

Code:
 update admin1codes set name='Hessen' where code='DE.05';
 update admin1codes set name='Nordrhein-Westfalen' where code='DE.07';
 update admin1codes set name='Sachsen-Anhalt' where code='DE.14';
 update admin1codes set name='Thüringen' where code='DE.15';
 update admin1codes set name='Bayern' where code='DE.02';
 update admin1codes set name='Niedersachsen' where code='DE.06';
 update admin1codes set name='Rheinland-Pfalz' where code='DE.08';
 update admin1codes set name='Sachsen-Anhalt' where code='DE.14';
 update admin1codes set name='Sachsen' where code='DE.13';
 



BTW, Marc, according to

http://en.wikipedia.org/wiki/States_of_Germany

english name for Sachsen is Saxony

if it is intended to have english names in admin1code, then to be consistent with wikipeidia

Code:
 update admin1codes set name='Saxony' where code='DE.13';
 


Thnx for your greate job
Dmitry
marc



Joined: 08/12/2005 07:39:47
Messages: 4486
Offline

Thanks, Dmitry.

I have added the English alternate name for Saxony here, it was missing indeed:
http://www.geonames.org/2842566/freistaat-sachsen.html

Best

Marc

[WWW]
 
Forum Index -> Postal Codes
Go to:   
Powered by JForum 2.1.5 © JForum Team