http://forum.geonames.org/gforum/posts/list/9.page JForum - http://www.jforum.net http://forum.geonames.org/gforum/posts/list/538.page#2499 http://forum.geonames.org/gforum/posts/list/538.page#2499 GMT Etat Regierungsbezirk => District Landkreis => Arrondissement Stadtkreis => Ville-arrondissement Gemeinde => Municipalité Any comments ?]]> http://forum.geonames.org/gforum/posts/list/538.page#2570 http://forum.geonames.org/gforum/posts/list/538.page#2570 GMT http://forum.geonames.org/gforum/posts/list/538.page#4776 http://forum.geonames.org/gforum/posts/list/538.page#4776 GMT http://forum.geonames.org/gforum/posts/list/538.page#4777 http://forum.geonames.org/gforum/posts/list/538.page#4777 GMT http://de.wikipedia.org/wiki/ISO_3166-2: DE (remove the last space in the URL between the ":" and the DE) This maps the German State Names to the correct ISO_3166-2 Codes and the old ADM1-Codes for Germany in admin1Codes.txt from your database. Baden-Württemberg DE.BW DE.01 Bayern DE.BY DE.02 Berlin DE.BE DE.16 Brandenburg DE.BB DE.11 Bremen DE.HB DE.03 Hamburg DE.HH DE.04 Hessen DE.HE DE.05 Mecklenburg-Vorpommern DE.MV DE.12 Niedersachsen DE.NI DE.06 Nordrhein-Westfalen DE.NW DE.07 Rheinland-Pfalz DE.RP DE.08 Saarland DE.SL DE.09 Sachsen DE.SN DE.13 Sachsen-Anhalt DE.ST DE.14 Schleswig-Holstein DE.SH DE.10 Thüringen DE.TH DE.15 All you need to do is to replace the third column with the second. :-) Thanks Guys![/url][url]]]> http://forum.geonames.org/gforum/posts/list/538.page#7084 http://forum.geonames.org/gforum/posts/list/538.page#7084 GMT http://forum.geonames.org/gforum/posts/list/538.page#7177 http://forum.geonames.org/gforum/posts/list/538.page#7177 GMT