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