number of errors=228
number of warnings=0
country=DE
Group=chkGrpPostalCode
select 'http://qa.geonames.org/qa/kml/' || zip_code.countrycode || zip_code.zip || zip_code.placename || '.kml' as kml,zip_code.countrycode,admincode1,placename,zip, zip_code.geonameid,st_distance(wkb_geometry,st_GeomFromText('Point(' || estlonglat[0] || ' ' || estlonglat[1] || ')',4326)) as distance,st_within(st_GeomFromText('Point(' || estlonglat[0] || ' ' || estlonglat[1] || ')',4326),st_envelope(wkb_geometry)) as inbbox from zip_code,postalcode_shape where zip_code.countrycode=postalcode_shape.countrycode and zip=postalcode and not st_within(st_GeomFromText('Point(' || estlonglat[0] || ' ' || estlonglat[1] || ')',4326),wkb_geometry) and zip_code.countrycode='DE' order by distance desc
Make sure the zip code is unique!
fix with st_centroid or ST_PointOnSurface
create table tmp as select zip_code.countrycode,admincode1,placename,zip,st_distance(wkb_geometry,st_GeomFromText('Point(' || estlonglat[0] || ' ' || estlonglat[1] || ')',4326)) as distance,st_GeomFromText('Point(' || estlonglat[0] || ' ' || estlonglat[1] || ')',4326) as geom,wkb_geometry as polygon from zip_code,postalcode_shape where zip_code.countrycode=postalcode_shape.countrycode and zip=postalcode and not within(st_GeomFromText('Point(' || estlonglat[0] || ' ' || estlonglat[1] || ')',4326),wkb_geometry) and zip_code.countrycode='CA' order by distance desc;
update tmp set geom=st_centroid(wkb_geometry);
update tmp set geom=ST_PointOnSurface(polygon) where not st_within(geom,polygon);
update zip_code set estlonglat = point(st_x(geom), st_y(geom)) from tmp where tmp.zip=zip_code.zip and tmp.countrycode=zip_code.countrycode
kml countrycode admincode1 placename zip geonameid distance inbbox http://qa.geonames.org/qa/kml/DE15537Grünheide (Mark) Kienbaum.kml DE BB Grünheide (Mark) Kienbaum 15537 2891088 0.2696691357707688 f http://qa.geonames.org/qa/kml/DE15537Grünheide (Mark) Kagel.kml DE BB Grünheide (Mark) Kagel 15537 2894290 0.24248157394114006 f http://qa.geonames.org/qa/kml/DE15537Grünheide (Mark).kml DE BB Grünheide (Mark) 15537 6551091 0.20243244997857887 f http://qa.geonames.org/qa/kml/DE15537Grünheide (Mark) Grünheide.kml DE BB Grünheide (Mark) Grünheide 15537 2914177 0.13227674305310014 f http://qa.geonames.org/qa/kml/DE15537Erkner.kml DE BB Erkner 15537 2929602 0.07452884913761505 f http://qa.geonames.org/qa/kml/DE15537Gosen Neu Zittau.kml DE BB Gosen Neu Zittau 15537 null 0.06492621519908028 f http://qa.geonames.org/qa/kml/DE21077Hamburg Eißendorf.kml DE HH Hamburg Eißendorf 21077 2931396 0.06405925969302993 f http://qa.geonames.org/qa/kml/DE22113Hamburg Lohbrügge.kml DE SH Hamburg Lohbrügge 22113 null 0.05344240056113915 f http://qa.geonames.org/qa/kml/DE21077Hamburg.kml DE HH Hamburg 21077 2911298 0.04447498276970415 f http://qa.geonames.org/qa/kml/DE22115Hamburg Lohbrügge.kml DE HH Hamburg Lohbrügge 22115 2876349 0.038371423468089416 f http://qa.geonames.org/qa/kml/DE21077Hamburg Marmstorf.kml DE HH Hamburg Marmstorf 21077 2873243 0.037303326094866966 f http://qa.geonames.org/qa/kml/DE21029Hamburg Altengamme.kml DE HH Hamburg Altengamme 21029 2957686 0.036856533548543825 f http://qa.geonames.org/qa/kml/DE15537Gosen.kml DE BB Gosen 15537 null 0.03188699603630409 f http://qa.geonames.org/qa/kml/DE21037Hamburg Curslack.kml DE HH Hamburg Curslack 21037 2939663 0.03178998755726312 t http://qa.geonames.org/qa/kml/DE22549Hamburg Bahrenfeld.kml DE HH Hamburg Bahrenfeld 22549 2953235 0.030552383260604023 f http://qa.geonames.org/qa/kml/DE22113Oststeinbek.kml DE SH Oststeinbek 22113 2856184 0.030527575505821188 f http://qa.geonames.org/qa/kml/DE22457Hamburg Niendorf.kml DE HH Hamburg Niendorf 22457 2862606 0.029805357903607308 f http://qa.geonames.org/qa/kml/DE22393Hamburg Bramfeld.kml DE HH Hamburg Bramfeld 22393 2945498 0.029726639109305616 f http://qa.geonames.org/qa/kml/DE22359Hamburg Rahlstedt.kml DE HH Hamburg Rahlstedt 22359 2850872 0.02887112351254915 f http://qa.geonames.org/qa/kml/DE20357Hamburg Altona-Altstadt.kml DE HH Hamburg Altona-Altstadt 20357 11669492 0.027718480753028407 f http://qa.geonames.org/qa/kml/DE22587Hamburg Nienstedten.kml DE HH Hamburg Nienstedten 22587 2862534 0.027406744153180833 f http://qa.geonames.org/qa/kml/DE22089Hamburg Wandsbek.kml DE HH Hamburg Wandsbek 22089 2911285 0.026240758749582007 f http://qa.geonames.org/qa/kml/DE22547Hamburg Bahrenfeld.kml DE HH Hamburg Bahrenfeld 22547 2953235 0.02590992282592478 f http://qa.geonames.org/qa/kml/DE22113Hamburg Allermöhe.kml DE SH Hamburg Allermöhe 22113 null 0.024239955076445555 f http://qa.geonames.org/qa/kml/DE22547Hamburg Osdorf.kml DE HH Hamburg Osdorf 22547 2856915 0.02420321850522171 f http://qa.geonames.org/qa/kml/DE22145Hamburg Farmsen-Berne.kml DE SH Hamburg Farmsen-Berne 22145 null 0.02365599627774383 f http://qa.geonames.org/qa/kml/DE22769Hamburg Bahrenfeld.kml DE HH Hamburg Bahrenfeld 22769 2953235 0.023359141811894437 f http://qa.geonames.org/qa/kml/DE22089Hamburg Marienthal.kml DE HH Hamburg Marienthal 22089 2911287 0.023316226471250263 f http://qa.geonames.org/qa/kml/DE21033Hamburg Bergedorf.kml DE HH Hamburg Bergedorf 21033 7290243 0.02255983871228608 f http://qa.geonames.org/qa/kml/DE21029Hamburg Curslack.kml DE HH Hamburg Curslack 21029 2939663 0.022369531768980048 f http://qa.geonames.org/qa/kml/DE20251Hamburg Alsterdorf.kml DE HH Hamburg Alsterdorf 20251 2958105 0.02214904566203344 f http://qa.geonames.org/qa/kml/DE22305Hamburg Winterhude.kml DE HH Hamburg Winterhude 22305 2807748 0.02133724988031834 f http://qa.geonames.org/qa/kml/DE20539Hamburg Wilhelmsburg.kml DE HH Hamburg Wilhelmsburg 20539 2808747 0.021121425210877592 f http://qa.geonames.org/qa/kml/DE21077Hamburg Rönneburg.kml DE HH Hamburg Rönneburg 21077 2845228 0.020921356000719583 f http://qa.geonames.org/qa/kml/DE20255Hamburg Lokstedt.kml DE HH Hamburg Lokstedt 20255 2864595 0.020800618064336186 f http://qa.geonames.org/qa/kml/DE22391Hamburg Bramfeld.kml DE HH Hamburg Bramfeld 22391 2945498 0.020622772908413814 f http://qa.geonames.org/qa/kml/DE20253Hamburg Lokstedt.kml DE HH Hamburg Lokstedt 20253 2864595 0.0202292892906431 f http://qa.geonames.org/qa/kml/DE21035Hamburg Bergedorf.kml DE HH Hamburg Bergedorf 21035 7290243 0.020228504715246717 f http://qa.geonames.org/qa/kml/DE22391Hamburg Ohlsdorf.kml DE HH Hamburg Ohlsdorf 22391 2857650 0.019930056665916067 f http://qa.geonames.org/qa/kml/DE22149Hamburg Tonndorf.kml DE HH Hamburg Tonndorf 22149 2821892 0.019874072569439547 f http://qa.geonames.org/qa/kml/DE22453Hamburg Fuhlsbüttel.kml DE HH Hamburg Fuhlsbüttel 22453 2923850 0.01946126210518742 f http://qa.geonames.org/qa/kml/DE22393Hamburg Poppenbüttel.kml DE HH Hamburg Poppenbüttel 22393 2852673 0.019322093909441704 f http://qa.geonames.org/qa/kml/DE22457Hamburg Eidelstedt.kml DE HH Hamburg Eidelstedt 22457 7274677 0.01916150372908814 f http://qa.geonames.org/qa/kml/DE21073Hamburg Eißendorf.kml DE HH Hamburg Eißendorf 21073 2931396 0.019085340737762434 f http://qa.geonames.org/qa/kml/DE22085Hamburg Barmbek-Süd.kml DE HH Hamburg Barmbek-Süd 22085 7932343 0.01888033924797071 f http://qa.geonames.org/qa/kml/DE21107Hamburg Steinwerder.kml DE HH Hamburg Steinwerder 21107 2827625 0.01871938911529937 f http://qa.geonames.org/qa/kml/DE21107Hamburg Wilhelmsburg.kml DE HH Hamburg Wilhelmsburg 21107 2808747 0.01811287664979898 f http://qa.geonames.org/qa/kml/DE20359Hamburg Altona-Altstadt.kml DE HH Hamburg Altona-Altstadt 20359 11669492 0.017986959981573052 f http://qa.geonames.org/qa/kml/DE22297Hamburg Barmbek-Nord.kml DE HH Hamburg Barmbek-Nord 22297 7932342 0.0171265655682641 f http://qa.geonames.org/qa/kml/DE22609Hamburg Othmarschen.kml DE HH Hamburg Othmarschen 22609 2856163 0.017051807124501682 f http://qa.geonames.org/qa/kml/DE22769Hamburg Stellingen.kml DE HH Hamburg Stellingen 22769 2827552 0.01693469027225243 f http://qa.geonames.org/qa/kml/DE22391Hamburg Sasel.kml DE HH Hamburg Sasel 22391 2841374 0.016923402826192476 f http://qa.geonames.org/qa/kml/DE22309Hamburg Bramfeld.kml DE HH Hamburg Bramfeld 22309 2945498 0.01635875728590766 f http://qa.geonames.org/qa/kml/DE21037Hamburg Neuengamme.kml DE HH Hamburg Neuengamme 21037 2865729 0.01625898240801121 t http://qa.geonames.org/qa/kml/DE21077Hamburg Wilstorf.kml DE HH Hamburg Wilstorf 21077 2808409 0.016226168654309408 f http://qa.geonames.org/qa/kml/DE22159Hamburg Sasel.kml DE HH Hamburg Sasel 22159 2841374 0.0160921623041009 f http://qa.geonames.org/qa/kml/DE20249Hamburg Winterhude.kml DE HH Hamburg Winterhude 20249 2807748 0.016023859734643642 f http://qa.geonames.org/qa/kml/DE22587Hamburg Rissen.kml DE HH Hamburg Rissen 22587 2846455 0.01563612811155819 f http://qa.geonames.org/qa/kml/DE21079Hamburg Hausbruch.kml DE HH Hamburg Hausbruch 21079 2908942 0.01536276788829543 t http://qa.geonames.org/qa/kml/DE21031Hamburg Bergedorf.kml DE HH Hamburg Bergedorf 21031 7290243 0.015323034769495125 f http://qa.geonames.org/qa/kml/DE22391Hamburg Hummelsbüttel.kml DE HH Hamburg Hummelsbüttel 22391 2897674 0.015204057720645276 f http://qa.geonames.org/qa/kml/DE20354Hamburg Sankt Pauli.kml DE HH Hamburg Sankt Pauli 20354 null 0.01518597775964958 f http://qa.geonames.org/qa/kml/DE22303Hamburg Barmbek-Nord.kml DE HH Hamburg Barmbek-Nord 22303 7932342 0.014824989411850089 f http://qa.geonames.org/qa/kml/DE22587Hamburg Osdorf.kml DE HH Hamburg Osdorf 22587 2856915 0.014590771849241185 f http://qa.geonames.org/qa/kml/DE22415Hamburg Hummelsbüttel.kml DE HH Hamburg Hummelsbüttel 22415 2897674 0.014444067226379063 f http://qa.geonames.org/qa/kml/DE21077Hamburg Sinstorf.kml DE HH Hamburg Sinstorf 21077 2831867 0.014436544049460868 f http://qa.geonames.org/qa/kml/DE22113Hamburg Horn.kml DE SH Hamburg Horn 22113 null 0.014348020368836744 f http://qa.geonames.org/qa/kml/DE20357Hamburg Altona-Nord.kml DE HH Hamburg Altona-Nord 20357 11669493 0.014321493416976626 f http://qa.geonames.org/qa/kml/DE22395Hamburg Wohldorf-Ohlstedt.kml DE HH Hamburg Wohldorf-Ohlstedt 22395 2807068 0.01392103021608272 f http://qa.geonames.org/qa/kml/DE22547Hamburg Eidelstedt.kml DE HH Hamburg Eidelstedt 22547 7274677 0.013730142130058695 f http://qa.geonames.org/qa/kml/DE22047Hamburg Bramfeld.kml DE HH Hamburg Bramfeld 22047 2945498 0.013247450211668475 f http://qa.geonames.org/qa/kml/DE20144Hamburg Eimsbüttel.kml DE HH Hamburg Eimsbüttel 20144 2911293 0.013198592385206683 f http://qa.geonames.org/qa/kml/DE22769Hamburg Altona-Altstadt.kml DE HH Hamburg Altona-Altstadt 22769 11669492 0.01307424686735395 f http://qa.geonames.org/qa/kml/DE22767Hamburg Ottensen.kml DE HH Hamburg Ottensen 22767 2856075 0.012856757784113756 f http://qa.geonames.org/qa/kml/DE22111Hamburg Billbrook.kml DE HH Hamburg Billbrook 22111 2948956 0.012655709885958934 f http://qa.geonames.org/qa/kml/DE22589Hamburg Blankenese.kml DE HH Hamburg Blankenese 22589 2948066 0.012497846316110983 f http://qa.geonames.org/qa/kml/DE22041Hamburg Marienthal.kml DE HH Hamburg Marienthal 22041 2911287 0.012394222615879039 f http://qa.geonames.org/qa/kml/DE22041Hamburg Tonndorf.kml DE HH Hamburg Tonndorf 22041 2821892 0.012311388609681811 f http://qa.geonames.org/qa/kml/DE22087Hamburg Hamm-Nord.kml DE HH Hamburg Hamm-Nord 22087 null 0.012161471332175976 f http://qa.geonames.org/qa/kml/DE21075Hamburg Harburg.kml DE HH Hamburg Harburg 21075 2910685 0.01213364605336119 f http://qa.geonames.org/qa/kml/DE22605Hamburg Bahrenfeld.kml DE HH Hamburg Bahrenfeld 22605 2953235 0.011862637907360906 f http://qa.geonames.org/qa/kml/DE22111Hamburg Billstedt.kml DE HH Hamburg Billstedt 22111 2948917 0.01174498264513795 f http://qa.geonames.org/qa/kml/DE22529Hamburg Niendorf.kml DE HH Hamburg Niendorf 22529 2862606 0.011619876340689405 f http://qa.geonames.org/qa/kml/DE20539Hamburg Kleiner Grasbrook.kml DE HH Hamburg Kleiner Grasbrook 20539 7932486 0.011518662249318287 f http://qa.geonames.org/qa/kml/DE21075Hamburg Hausbruch.kml DE HH Hamburg Hausbruch 21075 2908942 0.011128126466293492 f http://qa.geonames.org/qa/kml/DE22607Hamburg Bahrenfeld.kml DE HH Hamburg Bahrenfeld 22607 2953235 0.011086080029932754 f http://qa.geonames.org/qa/kml/DE20253Hamburg Eimsbüttel.kml DE HH Hamburg Eimsbüttel 20253 2911293 0.010858492874023786 f http://qa.geonames.org/qa/kml/DE20099Hamburg Hamburg-Altstadt.kml DE HH Hamburg Hamburg-Altstadt 20099 2956829 0.010743230871278613 f http://qa.geonames.org/qa/kml/DE22455Hamburg Niendorf.kml DE HH Hamburg Niendorf 22455 2862606 0.010697829044946944 f http://qa.geonames.org/qa/kml/DE22113Hamburg Billstedt.kml DE SH Hamburg Billstedt 22113 null 0.010649949519778164 t http://qa.geonames.org/qa/kml/DE21077Hamburg Rönneburg.kml DE HH Hamburg Rönneburg 21077 2845228 0.010558081717532279 f http://qa.geonames.org/qa/kml/DE22087Hamburg Eilbek.kml DE HH Hamburg Eilbek 22087 2931877 0.010530294930044037 f http://qa.geonames.org/qa/kml/DE22043Hamburg Tonndorf.kml DE HH Hamburg Tonndorf 22043 2821892 0.010423918742962194 f http://qa.geonames.org/qa/kml/DE20357Hamburg Eimsbüttel.kml DE HH Hamburg Eimsbüttel 20357 2911293 0.010253972508491594 f http://qa.geonames.org/qa/kml/DE22527Hamburg Eimsbüttel.kml DE HH Hamburg Eimsbüttel 22527 2911293 0.010197750178549998 f http://qa.geonames.org/qa/kml/DE20253Hamburg Harvestehude.kml DE HH Hamburg Harvestehude 20253 2909972 0.010120771473521351 f http://qa.geonames.org/qa/kml/DE22525Hamburg Lurup.kml DE HH Hamburg Lurup 22525 2875023 0.01010061159134872 f http://qa.geonames.org/qa/kml/DE22763Hamburg Othmarschen.kml DE HH Hamburg Othmarschen 22763 2856163 0.010087233266085115 f http://qa.geonames.org/qa/kml/DE22177Hamburg Bramfeld.kml DE HH Hamburg Bramfeld 22177 2945498 0.010042615368789871 f http://qa.geonames.org/qa/kml/DE22769Hamburg Sankt Pauli.kml DE HH Hamburg Sankt Pauli 22769 null 0.010039957492978771 f http://qa.geonames.org/qa/kml/DE22177Hamburg Steilshoop.kml DE HH Hamburg Steilshoop 22177 2828994 0.010026757362403669 t http://qa.geonames.org/qa/kml/DE22115Hamburg Billstedt.kml DE HH Hamburg Billstedt 22115 2948917 0.009944477157649801 f http://qa.geonames.org/qa/kml/DE22395Hamburg Poppenbüttel.kml DE HH Hamburg Poppenbüttel 22395 2852673 0.009900221718522225 f http://qa.geonames.org/qa/kml/DE22415Hamburg Fuhlsbüttel.kml DE HH Hamburg Fuhlsbüttel 22415 2923850 0.009779011157624761 f http://qa.geonames.org/qa/kml/DE22147Hamburg Rahlstedt.kml DE HH Hamburg Rahlstedt 22147 2850872 0.009570418868243039 f http://qa.geonames.org/qa/kml/DE22417Hamburg Langenhorn.kml DE HH Hamburg Langenhorn 22417 2832561 0.009451816313804852 t http://qa.geonames.org/qa/kml/DE20255Hamburg Stellingen.kml DE HH Hamburg Stellingen 20255 2827552 0.009312591236833723 f http://qa.geonames.org/qa/kml/DE20357Hamburg Rotherbaum.kml DE HH Hamburg Rotherbaum 20357 2843965 0.009310483104769014 f http://qa.geonames.org/qa/kml/DE22049Hamburg Wandsbek.kml DE HH Hamburg Wandsbek 22049 2911285 0.009268854287962269 f http://qa.geonames.org/qa/kml/DE22589Hamburg Osdorf.kml DE HH Hamburg Osdorf 22589 2856915 0.009244636063558388 f http://qa.geonames.org/qa/kml/DE20095Hamburg Sankt Georg.kml DE HH Hamburg Sankt Georg 20095 null 0.009217537646641958 f http://qa.geonames.org/qa/kml/DE21039Hamburg Bergedorf.kml DE SH Hamburg Bergedorf 21039 null 0.009198267426941352 t http://qa.geonames.org/qa/kml/DE22359Hamburg Bergstedt.kml DE HH Hamburg Bergstedt 22359 2950265 0.009160599451857123 f http://qa.geonames.org/qa/kml/DE22335Hamburg Groß Borstel.kml DE HH Hamburg Groß Borstel 22335 2916940 0.009050760483825774 f http://qa.geonames.org/qa/kml/DE22525Hamburg Eimsbüttel.kml DE HH Hamburg Eimsbüttel 22525 2911293 0.008779759021352312 f http://qa.geonames.org/qa/kml/DE22607Hamburg Nienstedten.kml DE HH Hamburg Nienstedten 22607 2862534 0.008654513041647743 f http://qa.geonames.org/qa/kml/DE20354Hamburg Rotherbaum.kml DE HH Hamburg Rotherbaum 20354 2843965 0.008560141998643316 f http://qa.geonames.org/qa/kml/DE22767Hamburg Sankt Pauli.kml DE HH Hamburg Sankt Pauli 22767 null 0.008489177597906065 f http://qa.geonames.org/qa/kml/DE22529Hamburg Eppendorf.kml DE HH Hamburg Eppendorf 22529 2929853 0.008469504881920862 t http://qa.geonames.org/qa/kml/DE22309Hamburg Ohlsdorf.kml DE HH Hamburg Ohlsdorf 22309 2857650 0.008343400346355055 f http://qa.geonames.org/qa/kml/DE21109Hamburg Veddel.kml DE HH Hamburg Veddel 21109 11669495 0.008269808993155707 f http://qa.geonames.org/qa/kml/DE22335Hamburg Ohlsdorf.kml DE HH Hamburg Ohlsdorf 22335 2857650 0.007840524313570893 f http://qa.geonames.org/qa/kml/DE22081Hamburg Uhlenhorst.kml DE HH Hamburg Uhlenhorst 22081 2820350 0.007816618237529407 f http://qa.geonames.org/qa/kml/DE21033Hamburg Lohbrügge.kml DE HH Hamburg Lohbrügge 21033 2876349 0.0078048189174167015 t http://qa.geonames.org/qa/kml/DE22395Hamburg Sasel.kml DE HH Hamburg Sasel 22395 2841374 0.007645795273662098 f http://qa.geonames.org/qa/kml/DE22459Hamburg Niendorf.kml DE HH Hamburg Niendorf 22459 2862606 0.007641330855124494 t http://qa.geonames.org/qa/kml/DE22415Hamburg Langenhorn.kml DE HH Hamburg Langenhorn 22415 2832561 0.007561173022113273 f http://qa.geonames.org/qa/kml/DE22525Hamburg Stellingen.kml DE HH Hamburg Stellingen 22525 2827552 0.007499236368226975 t http://qa.geonames.org/qa/kml/DE22339Hamburg Fuhlsbüttel.kml DE HH Hamburg Fuhlsbüttel 22339 2923850 0.0074599059441612095 f http://qa.geonames.org/qa/kml/DE20257Hamburg Altona-Nord.kml DE HH Hamburg Altona-Nord 20257 11669493 0.007431665667514471 f http://qa.geonames.org/qa/kml/DE22529Hamburg Groß Borstel.kml DE HH Hamburg Groß Borstel 22529 2916940 0.007365940083387364 f http://qa.geonames.org/qa/kml/DE21129Hamburg Moorburg.kml DE HH Hamburg Moorburg 21129 11611466 0.007122223952232515 f http://qa.geonames.org/qa/kml/DE22337Hamburg Alsterdorf.kml DE HH Hamburg Alsterdorf 22337 2958105 0.0071079651145912045 f http://qa.geonames.org/qa/kml/DE21073Hamburg Wilstorf.kml DE HH Hamburg Wilstorf 21073 2808409 0.006982135822746151 f http://qa.geonames.org/qa/kml/DE22399Hamburg Lemsahl-Mellingstedt.kml DE HH Hamburg Lemsahl-Mellingstedt 22399 2878918 0.0068386386383923236 f http://qa.geonames.org/qa/kml/DE22605Hamburg Groß Flottbek.kml DE HH Hamburg Groß Flottbek 22605 2915638 0.006807778745105848 f http://qa.geonames.org/qa/kml/DE22159Hamburg Bramfeld.kml DE HH Hamburg Bramfeld 22159 2945498 0.006803192946837658 f http://qa.geonames.org/qa/kml/DE20457Hamburg Neustadt.kml DE HH Hamburg Neustadt 20457 2864067 0.006646159520731953 t http://qa.geonames.org/qa/kml/DE22587Hamburg Sülldorf.kml DE HH Hamburg Sülldorf 22587 11611370 0.006610891561218304 f http://qa.geonames.org/qa/kml/DE20354Hamburg Neustadt.kml DE HH Hamburg Neustadt 20354 2864067 0.006561640757606944 f http://qa.geonames.org/qa/kml/DE22609Hamburg Groß Flottbek.kml DE HH Hamburg Groß Flottbek 22609 2915638 0.0062489050370243444 f http://qa.geonames.org/qa/kml/DE20357Hamburg Sankt Pauli.kml DE HH Hamburg Sankt Pauli 20357 null 0.0061849952827561575 f http://qa.geonames.org/qa/kml/DE22335Hamburg Alsterdorf.kml DE HH Hamburg Alsterdorf 22335 2958105 0.006128233860799389 f http://qa.geonames.org/qa/kml/DE20255Hamburg Hoheluft-West.kml DE HH Hamburg Hoheluft-West 20255 11669491 0.006111447197768763 f http://qa.geonames.org/qa/kml/DE22149Hamburg Rahlstedt.kml DE HH Hamburg Rahlstedt 22149 2850872 0.0060875537455111085 f http://qa.geonames.org/qa/kml/DE20095Hamburg Klostertor.kml DE HH Hamburg Klostertor 20095 null 0.0059820840204258844 f http://qa.geonames.org/qa/kml/DE22309Hamburg Barmbek-Nord.kml DE HH Hamburg Barmbek-Nord 22309 7932342 0.005893223071313241 f http://qa.geonames.org/qa/kml/DE22089Hamburg Hohenfelde.kml DE HH Hamburg Hohenfelde 22089 2901791 0.005881137264138126 f http://qa.geonames.org/qa/kml/DE20459Hamburg Hamburg-Altstadt.kml DE HH Hamburg Hamburg-Altstadt 20459 2956829 0.0058228111821858565 f http://qa.geonames.org/qa/kml/DE22459Hamburg Schnelsen.kml DE HH Hamburg Schnelsen 22459 2837343 0.00573024227785012 f http://qa.geonames.org/qa/kml/DE20253Hamburg Hoheluft-Ost.kml DE HH Hamburg Hoheluft-Ost 20253 11669497 0.005712654840252588 f http://qa.geonames.org/qa/kml/DE22145Hamburg Rahlstedt.kml DE SH Hamburg Rahlstedt 22145 null 0.005710822672389624 t http://qa.geonames.org/qa/kml/DE22159Hamburg Tonndorf.kml DE HH Hamburg Tonndorf 22159 2821892 0.00563721658090561 f http://qa.geonames.org/qa/kml/DE20249Hamburg Harvestehude.kml DE HH Hamburg Harvestehude 20249 2909972 0.0054842552545489014 f http://qa.geonames.org/qa/kml/DE21079Hamburg Wilstorf.kml DE HH Hamburg Wilstorf 21079 2808409 0.005456273808679277 t http://qa.geonames.org/qa/kml/DE20359Hamburg Neustadt.kml DE HH Hamburg Neustadt 20359 2864067 0.005430827259288672 f http://qa.geonames.org/qa/kml/DE21079Hamburg Heimfeld.kml DE HH Hamburg Heimfeld 21079 2907384 0.005392908193420075 t http://qa.geonames.org/qa/kml/DE21077Hamburg Langenbek.kml DE HH Hamburg Langenbek 21077 2881223 0.005350074853751153 f http://qa.geonames.org/qa/kml/DE22175Hamburg Bramfeld.kml DE HH Hamburg Bramfeld 22175 2945498 0.005281166418140428 f http://qa.geonames.org/qa/kml/DE22119Hamburg Billstedt.kml DE HH Hamburg Billstedt 22119 2948917 0.005244455332371314 f http://qa.geonames.org/qa/kml/DE22111Hamburg Horn.kml DE HH Hamburg Horn 22111 2898917 0.004948960239507634 t http://qa.geonames.org/qa/kml/DE22523Hamburg Eidelstedt.kml DE HH Hamburg Eidelstedt 22523 7274677 0.004803068497844448 t http://qa.geonames.org/qa/kml/DE22393Hamburg Wellingsbüttel.kml DE HH Hamburg Wellingsbüttel 22393 2811461 0.0048024232800999034 f http://qa.geonames.org/qa/kml/DE21077Hamburg Sinstorf.kml DE HH Hamburg Sinstorf 21077 2831867 0.0047966624533851915 t http://qa.geonames.org/qa/kml/DE22113Hamburg Billwerder.kml DE SH Hamburg Billwerder 22113 null 0.004680649944043654 t http://qa.geonames.org/qa/kml/DE21079Hamburg Harburg.kml DE HH Hamburg Harburg 21079 2910685 0.004555030856772601 t http://qa.geonames.org/qa/kml/DE22301Hamburg Winterhude.kml DE HH Hamburg Winterhude 22301 2807748 0.004548603042101072 f http://qa.geonames.org/qa/kml/DE21073Hamburg Heimfeld.kml DE HH Hamburg Heimfeld 21073 2907384 0.00443593654360158 t http://qa.geonames.org/qa/kml/DE21035Hamburg Billwerder.kml DE HH Hamburg Billwerder 21035 2948914 0.004426401737057089 f http://qa.geonames.org/qa/kml/DE22607Hamburg Othmarschen.kml DE HH Hamburg Othmarschen 22607 2856163 0.004296856180835076 f http://qa.geonames.org/qa/kml/DE22297Hamburg Winterhude.kml DE HH Hamburg Winterhude 22297 2807748 0.004292679110566445 f http://qa.geonames.org/qa/kml/DE22391Hamburg Poppenbüttel.kml DE HH Hamburg Poppenbüttel 22391 2852673 0.004221573251739966 f http://qa.geonames.org/qa/kml/DE20148Hamburg Harvestehude.kml DE HH Hamburg Harvestehude 20148 2909972 0.0041497918550233714 f http://qa.geonames.org/qa/kml/DE21077Hamburg Langenbek.kml DE HH Hamburg Langenbek 21077 2881223 0.0039456956503794655 t http://qa.geonames.org/qa/kml/DE22529Hamburg Hoheluft-West.kml DE HH Hamburg Hoheluft-West 22529 11669491 0.003939402422330846 f http://qa.geonames.org/qa/kml/DE22529Hamburg Stellingen.kml DE HH Hamburg Stellingen 22529 2827552 0.003932210546016731 t http://qa.geonames.org/qa/kml/DE22765Hamburg Ottensen.kml DE HH Hamburg Ottensen 22765 2856075 0.003927467855510079 f http://qa.geonames.org/qa/kml/DE22527Hamburg Lokstedt.kml DE HH Hamburg Lokstedt 22527 2864595 0.003804290916241887 t http://qa.geonames.org/qa/kml/DE22609Hamburg Osdorf.kml DE HH Hamburg Osdorf 22609 2856915 0.0037707014264103484 f http://qa.geonames.org/qa/kml/DE22399Hamburg Hummelsbüttel.kml DE HH Hamburg Hummelsbüttel 22399 2897674 0.0037029340166679684 f http://qa.geonames.org/qa/kml/DE22043Hamburg Marienthal.kml DE HH Hamburg Marienthal 22043 2911287 0.003608663750311632 f http://qa.geonames.org/qa/kml/DE22549Hamburg Lurup.kml DE HH Hamburg Lurup 22549 2875023 0.0035658077826649323 t http://qa.geonames.org/qa/kml/DE20149Hamburg Rotherbaum.kml DE HH Hamburg Rotherbaum 20149 2843965 0.0035365017179137866 f http://qa.geonames.org/qa/kml/DE20146Hamburg Harvestehude.kml DE HH Hamburg Harvestehude 20146 2909972 0.003496936948661038 f http://qa.geonames.org/qa/kml/DE22297Hamburg Groß Borstel.kml DE HH Hamburg Groß Borstel 22297 2916940 0.0034901398263702172 t http://qa.geonames.org/qa/kml/DE20144Hamburg Rotherbaum.kml DE HH Hamburg Rotherbaum 20144 2843965 0.0034799942585259074 t http://qa.geonames.org/qa/kml/DE20097Hamburg Sankt Georg.kml DE HH Hamburg Sankt Georg 20097 null 0.0032687261986279813 f http://qa.geonames.org/qa/kml/DE22525Hamburg Eidelstedt.kml DE HH Hamburg Eidelstedt 22525 7274677 0.0032493557341860472 f http://qa.geonames.org/qa/kml/DE22525Hamburg Bahrenfeld.kml DE HH Hamburg Bahrenfeld 22525 2953235 0.002932468032112497 f http://qa.geonames.org/qa/kml/DE22769Hamburg Eimsbüttel.kml DE HH Hamburg Eimsbüttel 22769 2911293 0.0028850050069586714 t http://qa.geonames.org/qa/kml/DE21149Hamburg Neugraben-Fischbek.kml DE HH Hamburg Neugraben-Fischbek 21149 2865260 0.002875346006290266 f http://qa.geonames.org/qa/kml/DE22457Hamburg Schnelsen.kml DE HH Hamburg Schnelsen 22457 2837343 0.0028697698687917485 t http://qa.geonames.org/qa/kml/DE22087Hamburg Uhlenhorst.kml DE HH Hamburg Uhlenhorst 22087 2820350 0.0028137222430787688 f http://qa.geonames.org/qa/kml/DE22047Hamburg Tonndorf.kml DE HH Hamburg Tonndorf 22047 2821892 0.0027878225810879834 t http://qa.geonames.org/qa/kml/DE14055Berlin.kml DE BE Berlin 14055 6547539 0.002674159654668553 t http://qa.geonames.org/qa/kml/DE22159Hamburg Farmsen-Berne.kml DE HH Hamburg Farmsen-Berne 22159 7932386 0.0026440736944638027 t http://qa.geonames.org/qa/kml/DE22305Hamburg Barmbek-Nord.kml DE HH Hamburg Barmbek-Nord 22305 7932342 0.002520606327947736 f http://qa.geonames.org/qa/kml/DE50937Köln.kml DE NW Köln 50937 2886242 0.0024777813116778997 t http://qa.geonames.org/qa/kml/DE20255Hamburg Eimsbüttel.kml DE HH Hamburg Eimsbüttel 20255 2911293 0.0024412441890633947 f http://qa.geonames.org/qa/kml/DE20095Hamburg Altstadt.kml DE HH Hamburg Altstadt 20095 null 0.0024410956647518012 f http://qa.geonames.org/qa/kml/DE22305Hamburg Barmbek-Süd.kml DE HH Hamburg Barmbek-Süd 22305 7932343 0.0023577996763228756 f http://qa.geonames.org/qa/kml/DE20457Hamburg Klostertor.kml DE HH Hamburg Klostertor 20457 null 0.0022282092840092927 t http://qa.geonames.org/qa/kml/DE21147Hamburg Hausbruch.kml DE HH Hamburg Hausbruch 21147 2908942 0.0021919962968168453 f http://qa.geonames.org/qa/kml/DE22083Hamburg Barmbek-Süd.kml DE HH Hamburg Barmbek-Süd 22083 7932343 0.0018515450841074903 t http://qa.geonames.org/qa/kml/DE20148Hamburg Rotherbaum.kml DE HH Hamburg Rotherbaum 20148 2843965 0.001610060664070394 f http://qa.geonames.org/qa/kml/DE20249Hamburg Hoheluft-Ost.kml DE HH Hamburg Hoheluft-Ost 20249 11669497 0.0015140513712293103 t http://qa.geonames.org/qa/kml/DE22769Hamburg Altona-Nord.kml DE HH Hamburg Altona-Nord 22769 11669493 0.0013963799436354006 t http://qa.geonames.org/qa/kml/DE22767Hamburg Altona-Altstadt.kml DE HH Hamburg Altona-Altstadt 22767 11669492 0.0012883760917985533 t http://qa.geonames.org/qa/kml/DE20459Hamburg Sankt Pauli.kml DE HH Hamburg Sankt Pauli 20459 null 0.0012607640920822688 t http://qa.geonames.org/qa/kml/DE20355Hamburg Neustadt.kml DE HH Hamburg Neustadt 20355 2864067 0.001110042051040539 t http://qa.geonames.org/qa/kml/DE20097Hamburg Hammerbrook.kml DE HH Hamburg Hammerbrook 20097 7932378 0.0010790651869053251 t http://qa.geonames.org/qa/kml/DE21035Hamburg Allermöhe.kml DE HH Hamburg Allermöhe 21035 2958397 0.0010681799979645754 t http://qa.geonames.org/qa/kml/DE20144Hamburg Hoheluft-Ost.kml DE HH Hamburg Hoheluft-Ost 20144 11669497 0.0009977445617541155 f http://qa.geonames.org/qa/kml/DE20144Hamburg Harvestehude.kml DE HH Hamburg Harvestehude 20144 2909972 0.0009540096761635141 f http://qa.geonames.org/qa/kml/DE22047Hamburg Wandsbek.kml DE HH Hamburg Wandsbek 22047 2911285 0.0009371747462898968 t http://qa.geonames.org/qa/kml/DE22089Hamburg Hamm-Nord.kml DE HH Hamburg Hamm-Nord 22089 null 0.0009233648542051509 f http://qa.geonames.org/qa/kml/DE22303Hamburg Winterhude.kml DE HH Hamburg Winterhude 22303 2807748 0.0006991148613634508 t http://qa.geonames.org/qa/kml/DE22045Hamburg Jenfeld.kml DE HH Hamburg Jenfeld 22045 2895035 0.0006325088106023828 t http://qa.geonames.org/qa/kml/DE20355Hamburg Sankt Pauli.kml DE HH Hamburg Sankt Pauli 20355 null 0.000566631115963867 f http://qa.geonames.org/qa/kml/DE21077Hamburg Eißendorf.kml DE HH Hamburg Eißendorf 21077 2931396 0.0004790673908880538 t http://qa.geonames.org/qa/kml/DE22453Hamburg Niendorf.kml DE HH Hamburg Niendorf 22453 2862606 0.00047498873257572553 t http://qa.geonames.org/qa/kml/DE20537Hamburg Borgfelde.kml DE HH Hamburg Borgfelde 20537 2946281 0.00029616647996474324 t http://qa.geonames.org/qa/kml/DE20249Hamburg Eppendorf.kml DE HH Hamburg Eppendorf 20249 2929853 0.0002474052951890187 t http://qa.geonames.org/qa/kml/DE22113Hamburg.kml DE SH Hamburg 22113 null 0.00020376867711799257 t http://qa.geonames.org/qa/kml/DE20459Hamburg.kml DE HH Hamburg 20459 2911298 0.00019869604599109578 t http://qa.geonames.org/qa/kml/DE20259Hamburg Eimsbüttel.kml DE HH Hamburg Eimsbüttel 20259 2911293 0.00014776573938657113 t http://qa.geonames.org/qa/kml/DE22339Hamburg Hummelsbüttel.kml DE HH Hamburg Hummelsbüttel 22339 2897674 0.00011252214948040777 t http://qa.geonames.org/qa/kml/DE12439Berlin.kml DE BE Berlin 12439 6547539 8.15134779711385e-05 t