number of errors=222
number of warnings=0
country=FI
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='FI' 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/FI70006Vastauslähetys.kml FI 11 Vastauslähetys 70006 null 0.09938282260256283 t http://qa.geonames.org/qa/kml/FI79101Leppävirta.kml FI 11 Leppävirta 79101 648227 0.08967201757793188 t http://qa.geonames.org/qa/kml/FI98840Ruuvaoja.kml FI 19 Ruuvaoja 98840 828754 0.08066372214710991 t http://qa.geonames.org/qa/kml/FI21661Nauvo.kml FI 02 Nauvo 21661 null 0.07626961916294364 t http://qa.geonames.org/qa/kml/FI85501Nivala.kml FI 17 Nivala 85501 644499 0.07403710651530648 t http://qa.geonames.org/qa/kml/FI19601Hartola.kml FI 07 Hartola 19601 658757 0.07324501035199077 t http://qa.geonames.org/qa/kml/FI34301Kuru.kml FI 06 Kuru 34301 null 0.07179738427582939 t http://qa.geonames.org/qa/kml/FI86801Pyhäsalmi.kml FI 17 Pyhäsalmi 86801 640403 0.06705270344176267 t http://qa.geonames.org/qa/kml/FI21601Parainen.kml FI 02 Parainen 21601 null 0.066914289827157 t http://qa.geonames.org/qa/kml/FI61401Ylistaro.kml FI 14 Ylistaro 61401 null 0.059791068894761074 t http://qa.geonames.org/qa/kml/FI73301Nilsiä.kml FI 11 Nilsiä 73301 644632 0.047348462825290434 t http://qa.geonames.org/qa/kml/FI11101Riihimäki.kml FI 05 Riihimäki 11101 639406 0.04170701002241907 t http://qa.geonames.org/qa/kml/FI99801Ivalo.kml FI 19 Ivalo 99801 656220 0.038103347377375814 t http://qa.geonames.org/qa/kml/FI65101Vaasa.kml FI 15 Vaasa 65101 null 0.03340943520861468 t http://qa.geonames.org/qa/kml/FI93101Pudasjärvi.kml FI 17 Pudasjärvi 93101 640803 0.03299506971931077 t http://qa.geonames.org/qa/kml/FI50520Mikkeli.kml FI 10 Mikkeli 50520 646005 0.02890139039109637 t http://qa.geonames.org/qa/kml/FI43701Kyyjärvi.kml FI 13 Kyyjärvi 43701 null 0.027934661301951054 t http://qa.geonames.org/qa/kml/FI93601Kuusamo.kml FI 17 Kuusamo 93601 null 0.026514643218298616 t http://qa.geonames.org/qa/kml/FI60101Seinäjoki.kml FI 14 Seinäjoki 60101 null 0.02547620709470479 t http://qa.geonames.org/qa/kml/FI04131Sipoo.kml FI 01 Sipoo 04131 null 0.024747651317660442 t http://qa.geonames.org/qa/kml/FI70101Kuopio.kml FI 11 Kuopio 70101 650224 0.023787828386403174 t http://qa.geonames.org/qa/kml/FI45750Sairaalamäki.kml FI 08 Sairaalamäki 45750 638172 0.023497125940050222 t http://qa.geonames.org/qa/kml/FI81660Lehmikylä.kml FI 12 Lehmikylä 81660 null 0.023019534501160736 t http://qa.geonames.org/qa/kml/FI13800Katinala.kml FI 05 Katinala 13800 653695 0.021007331126746825 t http://qa.geonames.org/qa/kml/FI40951Muurame.kml FI 13 Muurame 40951 null 0.020720227238917224 t http://qa.geonames.org/qa/kml/FI03601Karkkila.kml FI 01 Karkkila 03601 null 0.020457100659899904 t http://qa.geonames.org/qa/kml/FI83915Vihtasuo.kml FI 12 Vihtasuo 83915 631714 0.02010313425089309 t http://qa.geonames.org/qa/kml/FI75930Petäiskylä.kml FI 12 Petäiskylä 75930 642027 0.019030323173443567 t http://qa.geonames.org/qa/kml/FI99940Näätämö.kml FI 19 Näätämö 99940 645181 0.018340622276239116 t http://qa.geonames.org/qa/kml/FI07171Pornainen.kml FI 01 Pornainen 07171 null 0.01773318416279684 t http://qa.geonames.org/qa/kml/FI88820Katerma.kml FI 18 Katerma 88820 653698 0.016422816695536375 t http://qa.geonames.org/qa/kml/FI99695Tankavaara.kml FI 19 Tankavaara 99695 10231030 0.015988481203389495 t http://qa.geonames.org/qa/kml/FI95355Koivu.kml FI 19 Koivu 95355 null 0.01570483043401953 t http://qa.geonames.org/qa/kml/FI23501Uusikaupunki.kml FI 02 Uusikaupunki 23501 633221 0.015626267639975523 t http://qa.geonames.org/qa/kml/FI57120Savonlinna.kml FI 10 Savonlinna 57120 637292 0.01542321906359432 t http://qa.geonames.org/qa/kml/FI17501Padasjoki.kml FI 07 Padasjoki 17501 643260 0.014949545030427508 t http://qa.geonames.org/qa/kml/FI67101Kokkola.kml FI 16 Kokkola 67101 null 0.013763953662489187 t http://qa.geonames.org/qa/kml/FI10901Hanko.kml FI 01 Hanko 10901 null 0.013149059040942178 t http://qa.geonames.org/qa/kml/FI85101Kalajoki.kml FI 17 Kalajoki 85101 null 0.01300637617931928 t http://qa.geonames.org/qa/kml/FI62810Savonjoki.kml FI 14 Savonjoki 62810 null 0.012982884877119854 t http://qa.geonames.org/qa/kml/FI49220Siltakylä.kml FI 08 Siltakylä 49220 null 0.012945047671150773 t http://qa.geonames.org/qa/kml/FI96100Rovaniemi.kml FI 19 Rovaniemi 96100 638936 0.012375289289152326 t http://qa.geonames.org/qa/kml/FI71801Siilinjärvi.kml FI 11 Siilinjärvi 71801 636947 0.011657714031126776 t http://qa.geonames.org/qa/kml/FI95400Tornio.kml FI 19 Tornio 95400 634093 0.01146596105098391 t http://qa.geonames.org/qa/kml/FI58901Rantasalmi.kml FI 10 Rantasalmi 58901 null 0.011310285700532227 t http://qa.geonames.org/qa/kml/FI99950Karigasniemi.kml FI 19 Karigasniemi 99950 654085 0.011069416304196148 t http://qa.geonames.org/qa/kml/FI88300Paltamo.kml FI 18 Paltamo 88300 642750 0.01100297961273002 t http://qa.geonames.org/qa/kml/FI99970Nuvvus.kml FI 19 Nuvvus 99970 644128 0.010910262423883576 t http://qa.geonames.org/qa/kml/FI44101Äänekoski.kml FI 13 Äänekoski 44101 null 0.010710830007788765 t http://qa.geonames.org/qa/kml/FI99860Nellim.kml FI 19 Nellim 99860 644976 0.010290522576044073 t http://qa.geonames.org/qa/kml/FI66560Österhankmo.kml FI 15 Österhankmo 66560 null 0.009493284626723355 t http://qa.geonames.org/qa/kml/FI57100Savonlinna.kml FI 10 Savonlinna 57100 637292 0.009153275578202143 t http://qa.geonames.org/qa/kml/FI97145Totonvaara.kml FI 19 Totonvaara 97145 null 0.00888667133645609 t http://qa.geonames.org/qa/kml/FI15101Lahti.kml FI 07 Lahti 15101 649360 0.008356560269924977 t http://qa.geonames.org/qa/kml/FI28101Pori.kml FI 04 Pori 28101 640999 0.008006471993216 t http://qa.geonames.org/qa/kml/FI31761Urjala.kml FI 06 Urjala 31761 null 0.0078004270393697275 t http://qa.geonames.org/qa/kml/FI96900Saarenkylä.kml FI 19 Saarenkylä 96900 638436 0.007634154066710597 t http://qa.geonames.org/qa/kml/FI49480Summa.kml FI 08 Summa 49480 635825 0.0075601220962649325 t http://qa.geonames.org/qa/kml/FI77430Siikamäki.kml FI 10 Siikamäki 77430 636979 0.007423640439906945 t http://qa.geonames.org/qa/kml/FI83985Tuopanjoki.kml FI 12 Tuopanjoki 83985 633746 0.007148401815175326 t http://qa.geonames.org/qa/kml/FI26410Kaaro.kml FI 04 Kaaro 26410 null 0.006827966872454038 t http://qa.geonames.org/qa/kml/FI62900Alajärvi.kml FI 14 Alajärvi 62900 661576 0.00676750327033457 t http://qa.geonames.org/qa/kml/FI65730Jungsund.kml FI 15 Jungsund 65730 null 0.006635850714147307 t http://qa.geonames.org/qa/kml/FI62201Kauhava.kml FI 14 Kauhava 62201 null 0.006424743277477548 t http://qa.geonames.org/qa/kml/FI87101Kajaani.kml FI 18 Kajaani 87101 654899 0.00639238549439964 t http://qa.geonames.org/qa/kml/FI81700Lieksa.kml FI 12 Lieksa 81700 648090 0.005924847854579733 t http://qa.geonames.org/qa/kml/FI92401Ruukki.kml FI 17 Ruukki 92401 null 0.005536135350503908 t http://qa.geonames.org/qa/kml/FI99930Sevettijärvi.kml FI 19 Sevettijärvi 99930 637078 0.005329767966561851 t http://qa.geonames.org/qa/kml/FI65760Iskmo.kml FI 15 Iskmo 65760 null 0.005219493103984042 t http://qa.geonames.org/qa/kml/FI42701Keuruu.kml FI 13 Keuruu 42701 652977 0.005209354897639524 t http://qa.geonames.org/qa/kml/FI77960Pakarila.kml FI 11 Pakarila 77960 643041 0.00500299455318361 t http://qa.geonames.org/qa/kml/FI99600Sodankylä.kml FI 19 Sodankylä 99600 636464 0.004856858388267942 t http://qa.geonames.org/qa/kml/FI42560Pohjoisjärvi.kml FI 13 Pohjoisjärvi 42560 641202 0.004320491686718601 t http://qa.geonames.org/qa/kml/FI97630Pekkala.kml FI 19 Pekkala 97630 642400 0.004308289961674388 t http://qa.geonames.org/qa/kml/FI35400Längelmäki.kml FI 13 Längelmäki 35400 649120 0.003933978935946718 t http://qa.geonames.org/qa/kml/FI20100Turku.kml FI 02 Turku 20100 null 0.0038073097752375244 t http://qa.geonames.org/qa/kml/FI99120Kallo.kml FI 19 Kallo 99120 654607 0.0037180353334795926 t http://qa.geonames.org/qa/kml/FI87100Kajaani.kml FI 18 Kajaani 87100 654899 0.0036851633528956237 t http://qa.geonames.org/qa/kml/FI44950Kärväsjärvi.kml FI 13 Kärväsjärvi 44950 653821 0.0035956829068662577 t http://qa.geonames.org/qa/kml/FI95350Peura.kml FI 19 Peura 95350 null 0.003578301392747739 t http://qa.geonames.org/qa/kml/FI93140Kipinä.kml FI 17 Kipinä 93140 652716 0.0035555792083702695 t http://qa.geonames.org/qa/kml/FI97430Taapajärvi.kml FI 19 Taapajärvi 97430 635256 0.0034786729378570337 t http://qa.geonames.org/qa/kml/FI97530Yli-Nampa.kml FI 19 Yli-Nampa 97530 630851 0.0032482039882614218 t http://qa.geonames.org/qa/kml/FI41210Jokihaara.kml FI 13 Jokihaara 41210 655742 0.0032459392350872723 t http://qa.geonames.org/qa/kml/FI74630Heinäkylä.kml FI 11 Heinäkylä 74630 658371 0.0031285937584326702 t http://qa.geonames.org/qa/kml/FI11311Riihimäki.kml FI 05 Riihimäki 11311 null 0.0030760611667108397 t http://qa.geonames.org/qa/kml/FI27920Säkylä.kml FI 04 Säkylä 27920 638104 0.002861869536297607 t http://qa.geonames.org/qa/kml/FI79410Niinimäki.kml FI 11 Niinimäki 79410 644735 0.002712707232274141 t http://qa.geonames.org/qa/kml/FI51620Pitkäaho.kml FI 10 Pitkäaho 51620 null 0.002677819341103443 t http://qa.geonames.org/qa/kml/FI85801Haapajärvi.kml FI 17 Haapajärvi 85801 null 0.002647707981079911 t http://qa.geonames.org/qa/kml/FI95940Tapojärvi.kml FI 19 Tapojärvi 95940 634902 0.0026412080721449505 t http://qa.geonames.org/qa/kml/FI91670Rokua.kml FI 17 Rokua 91670 null 0.002631097682990786 t http://qa.geonames.org/qa/kml/FI85620Nivala.kml FI 17 Nivala 85620 644499 0.0026202122587617458 t http://qa.geonames.org/qa/kml/FI74490Koirakoski.kml FI 11 Koirakoski 74490 652193 0.0024073808022582145 t http://qa.geonames.org/qa/kml/FI31140Menonen.kml FI 06 Menonen 31140 646202 0.0024017396456655496 t http://qa.geonames.org/qa/kml/FI95330Tervola.kml FI 19 Tervola 95330 634592 0.0023957954752045897 t http://qa.geonames.org/qa/kml/FI98930Kotalankylä.kml FI 19 Kotalankylä 98930 null 0.0023860501286699504 t http://qa.geonames.org/qa/kml/FI97310Patokoski.kml FI 19 Patokoski 97310 642506 0.0023786361431314073 t http://qa.geonames.org/qa/kml/FI23880Suontaka.kml FI 02 Suontaka 23880 635670 0.0023480476254734025 t http://qa.geonames.org/qa/kml/FI61950Juonikylä.kml FI 14 Juonikylä 61950 655405 0.002347715493182604 t http://qa.geonames.org/qa/kml/FI14330Kaloinen.kml FI 05 Kaloinen 14330 654568 0.0023344626190574683 t http://qa.geonames.org/qa/kml/FI99135Rauhala.kml FI 19 Rauhala 99135 639741 0.00230780070796749 t http://qa.geonames.org/qa/kml/FI35260Hoivamäki.kml FI 06 Hoivamäki 35260 null 0.0022337501885582286 t http://qa.geonames.org/qa/kml/FI04380Tuusula.kml FI 01 Tuusula 04380 633591 0.0021089968553604844 t http://qa.geonames.org/qa/kml/FI81320Kuismavaara.kml FI 12 Kuismavaara 81320 650675 0.0020533796087987303 t http://qa.geonames.org/qa/kml/FI44770Valkeisjärvi.kml FI 13 Valkeisjärvi 44770 null 0.0020412200141629506 t http://qa.geonames.org/qa/kml/FI35320Hirsilä.kml FI 06 Hirsilä 35320 7838822 0.0020363079981975786 t http://qa.geonames.org/qa/kml/FI99910Kaamanen.kml FI 19 Kaamanen 99910 655174 0.0020238409216836385 t http://qa.geonames.org/qa/kml/FI89600Suomussalmi.kml FI 18 Suomussalmi 89600 635696 0.0019324894227914554 t http://qa.geonames.org/qa/kml/FI29830Sammi.kml FI 04 Sammi 29830 637831 0.0018854070289852864 t http://qa.geonames.org/qa/kml/FI73860Pykälikkö.kml FI 11 Pykälikkö 73860 null 0.0018584955412815041 t http://qa.geonames.org/qa/kml/FI14500Iittala.kml FI 05 Iittala 14500 656810 0.0018500906734383626 t http://qa.geonames.org/qa/kml/FI05800Hyvinkää.kml FI 01 Hyvinkää 05800 7647488 0.001841191173137105 t http://qa.geonames.org/qa/kml/FI28100Pori.kml FI 04 Pori 28100 640999 0.0018347540999606642 t http://qa.geonames.org/qa/kml/FI14370Lukana.kml FI 05 Lukana 14370 647494 0.0018134481284981627 t http://qa.geonames.org/qa/kml/FI97685Siika-Kämä.kml FI 19 Siika-Kämä 97685 636997 0.0017934176065149648 t http://qa.geonames.org/qa/kml/FI69440Lestijärvi.kml FI 16 Lestijärvi 69440 648178 0.0017750763546152165 t http://qa.geonames.org/qa/kml/FI23840Soukainen.kml FI 02 Soukainen 23840 636156 0.0016589979667681668 t http://qa.geonames.org/qa/kml/FI69970Salamajärvi.kml FI 16 Salamajärvi 69970 638093 0.0016018836899732564 t http://qa.geonames.org/qa/kml/FI74240Marttisenjärvi.kml FI 11 Marttisenjärvi 74240 646501 0.0015933846877538762 t http://qa.geonames.org/qa/kml/FI42140Juokslahti.kml FI 13 Juokslahti 42140 655418 0.0015455226187420837 t http://qa.geonames.org/qa/kml/FI99401Enontekiö.kml FI 19 Enontekiö 99401 null 0.0015199051797065391 t http://qa.geonames.org/qa/kml/FI47490Mankala.kml FI 08 Mankala 47490 646806 0.0015129382132938534 t http://qa.geonames.org/qa/kml/FI92520Sipola.kml FI 17 Sipola 92520 636714 0.0015068259673661508 t http://qa.geonames.org/qa/kml/FI39195Kaipio.kml FI 06 Kaipio 39195 null 0.0015053914279946781 t http://qa.geonames.org/qa/kml/FI42820Riiho.kml FI 13 Riiho 42820 639383 0.0014412464306375146 t http://qa.geonames.org/qa/kml/FI81330Luhtapohja.kml FI 12 Luhtapohja 81330 647513 0.0013990001823656567 t http://qa.geonames.org/qa/kml/FI68999Kokkola.kml FI 16 Kokkola 68999 null 0.0013808916263515394 t http://qa.geonames.org/qa/kml/FI51860Narila.kml FI 10 Narila 51860 645092 0.0013601542730393968 t http://qa.geonames.org/qa/kml/FI64840Heikkilänjoki.kml FI 14 Heikkilänjoki 64840 658431 0.0013534930088333363 t http://qa.geonames.org/qa/kml/FI68870Edsevö.kml FI 15 Edsevö 68870 660357 0.0013464030721814025 t http://qa.geonames.org/qa/kml/FI83460Harinjärvi.kml FI 12 Harinjärvi 83460 null 0.0013386726775663925 t http://qa.geonames.org/qa/kml/FI25650Strömma.kml FI 02 Strömma 25650 null 0.0013286251151855104 t http://qa.geonames.org/qa/kml/FI09120Karjalohja.kml FI 01 Karjalohja 09120 null 0.001325813706784538 t http://qa.geonames.org/qa/kml/FI95950Kihlanki.kml FI 19 Kihlanki 95950 652901 0.0012989591905618039 t http://qa.geonames.org/qa/kml/FI79680Lahnalahti.kml FI 10 Lahnalahti 79680 649418 0.0012824553888000046 t http://qa.geonames.org/qa/kml/FI62350Ekola.kml FI 14 Ekola 62350 660317 0.0012310228768787064 t http://qa.geonames.org/qa/kml/FI12130Mommila.kml FI 05 Mommila 12130 645883 0.0012237670454768215 t http://qa.geonames.org/qa/kml/FI97770Petäjäjärvi.kml FI 19 Petäjäjärvi 97770 642015 0.0011927704273499362 t http://qa.geonames.org/qa/kml/FI19730Särkilampi.kml FI 07 Särkilampi 19730 637624 0.001154790369017186 t http://qa.geonames.org/qa/kml/FI53950Lappeenranta.kml FI 09 Lappeenranta 53950 648900 0.001137003852193197 t http://qa.geonames.org/qa/kml/FI68555Bosund.kml FI 15 Bosund 68555 null 0.001108804291993807 t http://qa.geonames.org/qa/kml/FI31930Vanttila.kml FI 06 Vanttila 31930 632441 0.0010942803803379606 t http://qa.geonames.org/qa/kml/FI52150Hauhala.kml FI 10 Hauhala 52150 658669 0.0010504105538290832 t http://qa.geonames.org/qa/kml/FI66730Oxkangar.kml FI 15 Oxkangar 66730 null 0.0010398000389068417 t http://qa.geonames.org/qa/kml/FI68601Pietarsaari.kml FI 15 Pietarsaari 68601 null 0.0010041365008244952 t http://qa.geonames.org/qa/kml/FI17870Ruolahti.kml FI 13 Ruolahti 17870 638778 0.000987813948916662 t http://qa.geonames.org/qa/kml/FI38490Haukijärvi.kml FI 06 Haukijärvi 38490 658646 0.0009029827767614987 t http://qa.geonames.org/qa/kml/FI77480Savuniemi.kml FI 10 Savuniemi 77480 null 0.0008992655176607489 t http://qa.geonames.org/qa/kml/FI31650Venäjänkangas.kml FI 05 Venäjänkangas 31650 631984 0.0008531119474267175 t http://qa.geonames.org/qa/kml/FI66550Västerhankmo.kml FI 15 Västerhankmo 66550 null 0.000841099485865956 t http://qa.geonames.org/qa/kml/FI86980Väliaho.kml FI 17 Väliaho 86980 632778 0.0008239009770437211 t http://qa.geonames.org/qa/kml/FI21195Velkua.kml FI 02 Velkua 21195 631994 0.0008096481409687696 t http://qa.geonames.org/qa/kml/FI79885Etelä-Petruma.kml FI 10 Etelä-Petruma 79885 660101 0.0007766397196499732 t http://qa.geonames.org/qa/kml/FI62220Pernaa.kml FI 14 Pernaa 62220 642117 0.0007730394506965291 t http://qa.geonames.org/qa/kml/FI41530Veneranta.kml FI 13 Veneranta 41530 null 0.0007397893292465937 t http://qa.geonames.org/qa/kml/FI73830Siikajärvi.kml FI 11 Siikajärvi 73830 null 0.0007381368121587848 t http://qa.geonames.org/qa/kml/FI10440Bollsta.kml FI 01 Bollsta 10440 null 0.0007296199173357022 t http://qa.geonames.org/qa/kml/FI89830Ala-Vuokki.kml FI 18 Ala-Vuokki 89830 661358 0.0007228506919514303 t http://qa.geonames.org/qa/kml/FI27150Eurajoki.kml FI 04 Eurajoki 27150 660073 0.0007171436145234137 t http://qa.geonames.org/qa/kml/FI49630Vehkajoki.kml FI 08 Vehkajoki 49630 null 0.0007079477729946935 t http://qa.geonames.org/qa/kml/FI51310Levä.kml FI 10 Levä 51310 null 0.0006854308569448114 t http://qa.geonames.org/qa/kml/FI79180Tuppurinmäki.kml FI 11 Tuppurinmäki 79180 633707 0.0006724973559844564 t http://qa.geonames.org/qa/kml/FI37180Sarkola.kml FI 06 Sarkola 37180 637561 0.0006546970094450321 t http://qa.geonames.org/qa/kml/FI17780Harmoinen.kml FI 13 Harmoinen 17780 658793 0.00064163822446578 t http://qa.geonames.org/qa/kml/FI32250Kojonkulma.kml FI 02 Kojonkulma 32250 651995 0.0005483875700645361 t http://qa.geonames.org/qa/kml/FI07901Loviisa.kml FI 01 Loviisa 07901 null 0.0005074000646153877 t http://qa.geonames.org/qa/kml/FI75990Höljäkkä.kml FI 12 Höljäkkä 75990 657541 0.0004545715831804933 t http://qa.geonames.org/qa/kml/FI62430Peltotupa.kml FI 14 Peltotupa 62430 null 0.0004443464126240763 t http://qa.geonames.org/qa/kml/FI34430Kekkonen.kml FI 06 Kekkonen 34430 653369 0.0004337029091122695 t http://qa.geonames.org/qa/kml/FI19410Kuortti.kml FI 10 Kuortti 19410 650159 0.0004161585041908689 t http://qa.geonames.org/qa/kml/FI52420Pellosniemi.kml FI 10 Pellosniemi 52420 null 0.0004025098517293038 t http://qa.geonames.org/qa/kml/FI50130Mikkeli.kml FI 10 Mikkeli 50130 646005 0.0003921450372868566 t http://qa.geonames.org/qa/kml/FI97380Kukasranta.kml FI 19 Kukasranta 97380 null 0.00038644905308959123 t http://qa.geonames.org/qa/kml/FI86601Haapavesi.kml FI 17 Haapavesi 86601 659554 0.0003862314159085387 t http://qa.geonames.org/qa/kml/FI99360Kangosjärvi.kml FI 19 Kangosjärvi 99360 654394 0.0003849774440887949 t http://qa.geonames.org/qa/kml/FI00540Helsinki.kml FI 01 Helsinki 00540 null 0.00037913896142302247 t http://qa.geonames.org/qa/kml/FI80210Joensuu.kml FI 12 Joensuu 80210 655808 0.00037588851317019476 t http://qa.geonames.org/qa/kml/FI83760Sola.kml FI 12 Sola 83760 636369 0.00034863181416038735 t http://qa.geonames.org/qa/kml/FI45100Kouvola.kml FI 08 Kouvola 45100 650859 0.0003423354971359461 t http://qa.geonames.org/qa/kml/FI69550Kanala.kml FI 16 Kanala 69550 654482 0.00032504542467107314 t http://qa.geonames.org/qa/kml/FI51270Kutemajärvi.kml FI 10 Kutemajärvi 51270 649989 0.00032346519940817996 t http://qa.geonames.org/qa/kml/FI51450Pajulankylä.kml FI 10 Pajulankylä 51450 null 0.00031896449188139415 t http://qa.geonames.org/qa/kml/FI62240Huhmarkoski.kml FI 14 Huhmarkoski 62240 null 0.0003130971943783506 t http://qa.geonames.org/qa/kml/FI61430Isorehto.kml FI 14 Isorehto 61430 null 0.00029850103911156534 t http://qa.geonames.org/qa/kml/FI40801Vaajakoski.kml FI 13 Vaajakoski 40801 null 0.0002806394141081882 t http://qa.geonames.org/qa/kml/FI04820Kaukalampi.kml FI 01 Kaukalampi 04820 653611 0.00027182463918588065 t http://qa.geonames.org/qa/kml/FI62730Haukkala.kml FI 14 Haukkala 62730 658607 0.00026635346718222963 t http://qa.geonames.org/qa/kml/FI91900Liminka.kml FI 17 Liminka 91900 647930 0.00026505885326555265 t http://qa.geonames.org/qa/kml/FI95460Tornio.kml FI 19 Tornio 95460 634093 0.00026401969113631977 t http://qa.geonames.org/qa/kml/FI65460Tölby.kml FI 15 Tölby 65460 null 0.0002626157747966093 t http://qa.geonames.org/qa/kml/FI82200Hammaslahti.kml FI 12 Hammaslahti 82200 659158 0.000255513166050236 t http://qa.geonames.org/qa/kml/FI08450Lohja.kml FI 01 Lohja 08450 null 0.00025428598424700343 t http://qa.geonames.org/qa/kml/FI73990Kangaslahti.kml FI 11 Kangaslahti 73990 654416 0.00025390421335177575 t http://qa.geonames.org/qa/kml/FI62640Savonkylä.kml FI 14 Savonkylä 62640 null 0.0002483874434561975 t http://qa.geonames.org/qa/kml/FI07190Halkia.kml FI 01 Halkia 07190 659340 0.0002455592507005278 t http://qa.geonames.org/qa/kml/FI96400Rovaniemi.kml FI 19 Rovaniemi 96400 638936 0.00024319387897021448 t http://qa.geonames.org/qa/kml/FI17630Vesijako.kml FI 07 Vesijako 17630 631871 0.00020129551291276745 t http://qa.geonames.org/qa/kml/FI86790Venetpalo.kml FI 17 Venetpalo 86790 631946 0.00019434553159134257 t http://qa.geonames.org/qa/kml/FI79820Varistaipale.kml FI 10 Varistaipale 79820 632385 0.0001636283516302595 t http://qa.geonames.org/qa/kml/FI10710Snappertuna.kml FI 01 Snappertuna 10710 null 0.00015722832318480236 t http://qa.geonames.org/qa/kml/FI95225Viantie.kml FI 19 Viantie 95225 631814 0.00015482506310970218 t http://qa.geonames.org/qa/kml/FI89610Jumaliskylä.kml FI 18 Jumaliskylä 89610 null 0.00015137807061166864 t http://qa.geonames.org/qa/kml/FI39880Kihniö As.kml FI 06 Kihniö As 39880 null 0.00014913194846502277 t http://qa.geonames.org/qa/kml/FI69820Räyrinki.kml FI 16 Räyrinki 69820 639616 0.00014737497112863882 t http://qa.geonames.org/qa/kml/FI75970Kohtavaara.kml FI 12 Kohtavaara 75970 null 0.00014405432941868513 t http://qa.geonames.org/qa/kml/FI42330Haavisto.kml FI 13 Haavisto 42330 659478 0.0001407297162070167 t http://qa.geonames.org/qa/kml/FI74940Remeskylä.kml FI 11 Remeskylä 74940 639539 0.00012735496754444603 t http://qa.geonames.org/qa/kml/FI65870Björköby.kml FI 15 Björköby 65870 null 0.0001271305458817486 t http://qa.geonames.org/qa/kml/FI19740Liikola.kml FI 07 Liikola 19740 648019 0.00011820136154628193 t http://qa.geonames.org/qa/kml/FI62860Sahi.kml FI 14 Sahi 62860 null 0.00011748056183926784 t http://qa.geonames.org/qa/kml/FI68580Larsmo.kml FI 15 Larsmo 68580 null 0.00010211393224117047 t http://qa.geonames.org/qa/kml/FI34930Liedenpohja.kml FI 06 Liedenpohja 34930 null 6.45005556077442e-05 t http://qa.geonames.org/qa/kml/FI70700Kuopio.kml FI 11 Kuopio 70700 650224 5.800256123379034e-05 t http://qa.geonames.org/qa/kml/FI80101Joensuu.kml FI 12 Joensuu 80101 null 4.861828117159229e-05 t http://qa.geonames.org/qa/kml/FI65970Söderudden.kml FI 15 Söderudden 65970 null 4.7164256921420585e-05 t http://qa.geonames.org/qa/kml/FI41410Kankainen.kml FI 13 Kankainen 41410 654350 2.733562475207086e-05 t http://qa.geonames.org/qa/kml/FI43960Saarensalmi.kml FI 13 Saarensalmi 43960 null 2.0384800306377128e-05 t http://qa.geonames.org/qa/kml/FI13200Hämeenlinna.kml FI 05 Hämeenlinna 13200 659180 1.88034732713675e-05 t http://qa.geonames.org/qa/kml/FI37210Kulovesi.kml FI 06 Kulovesi 37210 650443 1.7623682289927515e-05 t http://qa.geonames.org/qa/kml/FI41350Laukaa As.kml FI 13 Laukaa As 41350 null 8.152748280141237e-06 t http://qa.geonames.org/qa/kml/FI63540Hernesmaa.kml FI 14 Hernesmaa 63540 658157 4.535227758438047e-06 t