number of errors=500
number of warnings=0
country=EC
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='EC' and postalcode_shape.place=zip_code.placename 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/EC010220Molleturo.kml EC 02 Molleturo 010220 3654104 0.4393770766443335 f http://qa.geonames.org/qa/kml/EC080407Cube.kml EC 09 Cube 080407 3658701 0.3809437128725141 f http://qa.geonames.org/qa/kml/EC130313Pedro Pablo Gomez.kml EC 14 Pedro Pablo Gomez 130313 3653293 0.35599258445275556 f http://qa.geonames.org/qa/kml/EC010219Chaucha.kml EC 02 Chaucha 010219 3659368 0.34323353186629485 f http://qa.geonames.org/qa/kml/EC120115Montalvo.kml EC 13 Montalvo 120115 3654064 0.33830169406320876 f http://qa.geonames.org/qa/kml/EC110119Jimbilla.kml EC 12 Jimbilla 110119 3655450 0.33820142611579124 f http://qa.geonames.org/qa/kml/EC050409Angamarca.kml EC 07 Angamarca 050409 3660634 0.3213706721279208 f http://qa.geonames.org/qa/kml/EC080409La Union.kml EC 09 La Union 080409 8470652 0.3082799884579573 f http://qa.geonames.org/qa/kml/EC091305Colimes.kml EC 10 Colimes 091305 3658948 0.28975127548655377 f http://qa.geonames.org/qa/kml/EC120609Patricia Pilar.kml EC 13 Patricia Pilar 120609 8471974 0.2835597856715801 f http://qa.geonames.org/qa/kml/EC070309Salati.kml EC 08 Salati 070309 3652111 0.28301895677583977 f http://qa.geonames.org/qa/kml/EC120607Valencia.kml EC 13 Valencia 120607 3650301 0.27178878830108 f http://qa.geonames.org/qa/kml/EC130714Canuto.kml EC 14 Canuto 130714 3659780 0.2591229390469267 f http://qa.geonames.org/qa/kml/EC240107Colonche.kml EC 25 Colonche 240107 3658930 0.24150264009797645 f http://qa.geonames.org/qa/kml/EC130226La Pila.kml EC 14 La Pila 130226 3655041 0.2390889630551211 f http://qa.geonames.org/qa/kml/EC091307Balzar.kml EC 10 Balzar 091307 3660361 0.23078679129206375 f http://qa.geonames.org/qa/kml/EC050502Isinlivi.kml EC 07 Isinlivi 050502 3655557 0.2207329150626544 f http://qa.geonames.org/qa/kml/EC120606Valencia.kml EC 13 Valencia 120606 3650301 0.218329521522659 f http://qa.geonames.org/qa/kml/EC130308Membrillal.kml EC 14 Membrillal 130308 3654255 0.2168744142076327 f http://qa.geonames.org/qa/kml/EC092301Samborondon.kml EC 10 Samborondon 092301 3652065 0.21029160554542936 f http://qa.geonames.org/qa/kml/EC150107Cotundo.kml EC 23 Cotundo 150107 3658760 0.20356284817361242 f http://qa.geonames.org/qa/kml/EC120112Caracol.kml EC 13 Caracol 120112 3659735 0.1998383166517905 f http://qa.geonames.org/qa/kml/EC100216Pataqui.kml EC 11 Pataqui 100216 3653376 0.19414888981999434 f http://qa.geonames.org/qa/kml/EC140203Pablo Sexto.kml EC 15 Pablo Sexto 140203 3655731 0.19363217619508502 f http://qa.geonames.org/qa/kml/EC120608San Jacinto De Buena Fe.kml EC 13 San Jacinto De Buena Fe 120608 3660073 0.19092610717967026 f http://qa.geonames.org/qa/kml/EC060409Palmira.kml EC 06 Palmira 060409 3653540 0.186758515877541 f http://qa.geonames.org/qa/kml/EC240105Chanduy.kml EC 25 Chanduy 240105 3659427 0.18529676326560388 f http://qa.geonames.org/qa/kml/EC020109Simiatug.kml EC 03 Simiatug 020109 3651040 0.18453573659703826 f http://qa.geonames.org/qa/kml/EC040205San Gabriel.kml EC 05 San Gabriel 040205 3651868 0.18292393756380182 f http://qa.geonames.org/qa/kml/EC170314San Antonio.kml EC 18 San Antonio 170314 3652031 0.17845634708158642 f http://qa.geonames.org/qa/kml/EC230209Valle Hermoso.kml EC 26 Valle Hermoso 230209 8472427 0.17589075448279679 f http://qa.geonames.org/qa/kml/EC091906Santa Lucia.kml EC 10 Santa Lucia 091906 3651412 0.16946811124895217 f http://qa.geonames.org/qa/kml/EC170411San Juan.kml EC 18 San Juan 170411 3651736 0.16928004575560027 f http://qa.geonames.org/qa/kml/EC120205Puerto Pechiche.kml EC 13 Puerto Pechiche 120205 3652720 0.16452257895306407 f http://qa.geonames.org/qa/kml/EC130505El Carmen.kml EC 14 El Carmen 130505 3658336 0.1585349052834217 f http://qa.geonames.org/qa/kml/EC110115Loja.kml EC 12 Loja 110115 3654667 0.1578260436062208 f http://qa.geonames.org/qa/kml/EC120108Pimocha.kml EC 13 Pimocha 120108 3653137 0.15502025358473154 f http://qa.geonames.org/qa/kml/EC130224Manta.kml EC 14 Manta 130224 3654410 0.14873790627644023 f http://qa.geonames.org/qa/kml/EC120114Montalvo.kml EC 13 Montalvo 120114 3654064 0.148484314899245 f http://qa.geonames.org/qa/kml/EC170402San Juan.kml EC 18 San Juan 170402 3651736 0.14832543389883843 f http://qa.geonames.org/qa/kml/EC100215Otavalo.kml EC 11 Otavalo 100215 3653693 0.14813987124109396 f http://qa.geonames.org/qa/kml/EC110602El Lucero.kml EC 12 El Lucero 110602 3658224 0.1452099479017158 f http://qa.geonames.org/qa/kml/EC120111Pimocha.kml EC 13 Pimocha 120111 3653137 0.14434647393777486 f http://qa.geonames.org/qa/kml/EC120204San Juan.kml EC 13 San Juan 120204 3651727 0.14283102754286647 f http://qa.geonames.org/qa/kml/EC040108Tulcan.kml EC 05 Tulcan 040108 3650472 0.14066607998327557 f http://qa.geonames.org/qa/kml/EC131004Cojimies.kml EC 14 Cojimies 131004 3658968 0.14033548040574814 f http://qa.geonames.org/qa/kml/EC120110Pimocha.kml EC 13 Pimocha 120110 3653137 0.1398903273770246 f http://qa.geonames.org/qa/kml/EC180110Pasa-San Fernando (Pasa San Fernando).kml EC 19 Pasa-San Fernando (Pasa San Fernando) 180110 3651922 0.13880068274503332 f http://qa.geonames.org/qa/kml/EC020107Guaranda.kml EC 03 Guaranda 020107 3657571 0.13844161335491287 f http://qa.geonames.org/qa/kml/EC091303Balzar.kml EC 10 Balzar 091303 3660361 0.13790045192008538 f http://qa.geonames.org/qa/kml/EC080404Malimpia.kml EC 09 Malimpia 080404 3654474 0.13351661781353794 f http://qa.geonames.org/qa/kml/EC130718Flavio Alfaro.kml EC 14 Flavio Alfaro 130718 3657919 0.13093176811668905 f http://qa.geonames.org/qa/kml/EC110114Loja.kml EC 12 Loja 110114 3654667 0.1301807611741966 f http://qa.geonames.org/qa/kml/EC170315San Antonio.kml EC 18 San Antonio 170315 3652031 0.1287204172930449 f http://qa.geonames.org/qa/kml/EC120206Ricaurte.kml EC 13 Ricaurte 120206 3652362 0.12750865277617798 f http://qa.geonames.org/qa/kml/EC230211Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230211 3651297 0.12727198988531802 f http://qa.geonames.org/qa/kml/EC130214Montecristi.kml EC 14 Montecristi 130214 3654055 0.12401451465095302 f http://qa.geonames.org/qa/kml/EC091304Balzar.kml EC 10 Balzar 091304 3660361 0.12237601584484861 f http://qa.geonames.org/qa/kml/EC171108Machachi.kml EC 18 Machachi 171108 3654536 0.1214001297941884 f http://qa.geonames.org/qa/kml/EC170407San Juan.kml EC 18 San Juan 170407 3651736 0.1207973481074758 f http://qa.geonames.org/qa/kml/EC092302Samborondon.kml EC 10 Samborondon 092302 3652065 0.1201424139524771 f http://qa.geonames.org/qa/kml/EC130221Jaramijo.kml EC 14 Jaramijo 130221 3655502 0.11921814684210329 f http://qa.geonames.org/qa/kml/EC050405Pujili.kml EC 07 Pujili 050405 3652684 0.11748760463948124 f http://qa.geonames.org/qa/kml/EC110904Paletillas.kml EC 12 Paletillas 110904 3653577 0.11629527585813997 f http://qa.geonames.org/qa/kml/EC131005Pedernales.kml EC 14 Pedernales 131005 3653307 0.11510706732603185 f http://qa.geonames.org/qa/kml/EC130804Pichincha.kml EC 14 Pichincha 130804 3653226 0.11428004963056249 f http://qa.geonames.org/qa/kml/EC120311San Carlos.kml EC 13 San Carlos 120311 3651960 0.11391465045618301 f http://qa.geonames.org/qa/kml/EC130213Montecristi.kml EC 14 Montecristi 130213 3654055 0.11106460377685166 f http://qa.geonames.org/qa/kml/EC171114Aloag.kml EC 18 Aloag 171114 3660754 0.11046051409810476 f http://qa.geonames.org/qa/kml/EC230114Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230114 3651297 0.1084776574861837 f http://qa.geonames.org/qa/kml/EC100211Atuntaqui.kml EC 11 Atuntaqui 100211 3660478 0.10789930881068573 f http://qa.geonames.org/qa/kml/EC050113Latacunga.kml EC 07 Latacunga 050113 3654870 0.10643092654724556 f http://qa.geonames.org/qa/kml/EC230117Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230117 3651297 0.10616155017040972 f http://qa.geonames.org/qa/kml/EC010215Santa Ana.kml EC 02 Santa Ana 010215 3651488 0.10602261055960241 f http://qa.geonames.org/qa/kml/EC170311Nono.kml EC 18 Nono 170311 3653801 0.10543880069317753 f http://qa.geonames.org/qa/kml/EC171106Sangolqui.kml EC 18 Sangolqui 171106 3651857 0.10446231366964509 f http://qa.geonames.org/qa/kml/EC120511Palenque.kml EC 13 Palenque 120511 3653587 0.10401642494600243 f http://qa.geonames.org/qa/kml/EC050410Pilalo.kml EC 07 Pilalo 050410 3653180 0.10329144270826678 f http://qa.geonames.org/qa/kml/EC120406Zapotal.kml EC 13 Zapotal 120406 3649928 0.10296313572068298 f http://qa.geonames.org/qa/kml/EC130607Calceta.kml EC 14 Calceta 130607 3659926 0.10251938153421901 f http://qa.geonames.org/qa/kml/EC100302Imantag.kml EC 11 Imantag 100302 3655638 0.09874371368442014 f http://qa.geonames.org/qa/kml/EC171009Cayambe.kml EC 18 Cayambe 171009 3659578 0.09811624215070873 f http://qa.geonames.org/qa/kml/EC130408Olmedo.kml EC 14 Olmedo 130408 3653735 0.09779839152244359 f http://qa.geonames.org/qa/kml/EC100214San Jose De Quichinche.kml EC 11 San Jose De Quichinche 100214 3651743 0.09659206033470055 f http://qa.geonames.org/qa/kml/EC110601Cariamanga.kml EC 12 Cariamanga 110601 3659711 0.09631620314204736 f http://qa.geonames.org/qa/kml/EC050403Chantilin-Saquisili.kml EC 07 Chantilin-Saquisili 050403 8542034 0.09564055087960785 f http://qa.geonames.org/qa/kml/EC110607Gonzanama.kml EC 12 Gonzanama 110607 3657778 0.0936670823158623 f http://qa.geonames.org/qa/kml/EC130403Ayacucho.kml EC 14 Ayacucho 130403 3660462 0.09320663269646931 f http://qa.geonames.org/qa/kml/EC120602Valencia.kml EC 13 Valencia 120602 3650301 0.09106946929828813 f http://qa.geonames.org/qa/kml/EC060115Lican.kml EC 06 Lican 060115 3654767 0.08998436272300961 f http://qa.geonames.org/qa/kml/EC170313Pomasqui.kml EC 18 Pomasqui 170313 3652977 0.08948161273481525 f http://qa.geonames.org/qa/kml/EC091306Colimes.kml EC 10 Colimes 091306 3658948 0.08790994014909587 f http://qa.geonames.org/qa/kml/EC110605Cariamanga.kml EC 12 Cariamanga 110605 3659711 0.08767180919212543 f http://qa.geonames.org/qa/kml/EC120113La Union.kml EC 13 La Union 120113 3654845 0.08657644389079104 f http://qa.geonames.org/qa/kml/EC040206San Gabriel.kml EC 05 San Gabriel 040206 3651868 0.08597240716999574 f http://qa.geonames.org/qa/kml/EC130707Boyaca.kml EC 14 Boyaca 130707 3660100 0.08585127638094874 f http://qa.geonames.org/qa/kml/EC100210Atuntaqui.kml EC 11 Atuntaqui 100210 3660478 0.08516076584308528 f http://qa.geonames.org/qa/kml/EC130706Chone.kml EC 14 Chone 130706 3659139 0.08274142087463263 f http://qa.geonames.org/qa/kml/EC130225Manta.kml EC 14 Manta 130225 3654410 0.08213371051872198 f http://qa.geonames.org/qa/kml/EC230118Santa Maria Del Toachi.kml EC 26 Santa Maria Del Toachi 230118 8472517 0.07959994303951888 f http://qa.geonames.org/qa/kml/EC120604San Jacinto De Buena Fe.kml EC 13 San Jacinto De Buena Fe 120604 3660073 0.07552535791019983 f http://qa.geonames.org/qa/kml/EC010701Camilo Ponce Enriquez.kml EC 02 Camilo Ponce Enriquez 010701 3659872 0.07522754147348447 f http://qa.geonames.org/qa/kml/EC100116Salinas.kml EC 11 Salinas 100116 3652103 0.07491118566223869 f http://qa.geonames.org/qa/kml/EC190302Zumba.kml EC 20 Zumba 190302 3649880 0.07458476717785868 f http://qa.geonames.org/qa/kml/EC091904Daule.kml EC 10 Daule 091904 3658501 0.07363441083661412 f http://qa.geonames.org/qa/kml/EC130410Sucre.kml EC 14 Sucre 130410 3650960 0.07318554748445193 f http://qa.geonames.org/qa/kml/EC040107Tulcan.kml EC 05 Tulcan 040107 3650472 0.0728216858485608 f http://qa.geonames.org/qa/kml/EC020304San Pablo (San Pablo De Atenas).kml EC 03 San Pablo (San Pablo De Atenas) 020304 3651589 0.06995181992772871 f http://qa.geonames.org/qa/kml/EC130407La Union.kml EC 14 La Union 130407 3654848 0.06983330493000063 f http://qa.geonames.org/qa/kml/EC170507Concepcion.kml EC 18 Concepcion 170507 3657168 0.06967792083401746 f http://qa.geonames.org/qa/kml/EC010111Sinincay.kml EC 02 Sinincay 010111 3651026 0.06815915939140593 f http://qa.geonames.org/qa/kml/EC010217Tarqui.kml EC 02 Tarqui 010217 3650765 0.06378898206294006 f http://qa.geonames.org/qa/kml/EC180106Ambato.kml EC 19 Ambato 180106 3660689 0.0629245727356021 f http://qa.geonames.org/qa/kml/EC110113Loja.kml EC 12 Loja 110113 3654667 0.06272832816126905 f http://qa.geonames.org/qa/kml/EC240108Simon Bolivar (Julio Moreno).kml EC 25 Simon Bolivar (Julio Moreno) 240108 3651038 0.0622643136590265 f http://qa.geonames.org/qa/kml/EC120509Vinces.kml EC 13 Vinces 120509 3650186 0.06215857961015079 f http://qa.geonames.org/qa/kml/EC120117Baba.kml EC 13 Baba 120117 3660422 0.06110549867928553 f http://qa.geonames.org/qa/kml/EC050109Latacunga.kml EC 07 Latacunga 050109 3654870 0.06049848427045811 f http://qa.geonames.org/qa/kml/EC130709Chone.kml EC 14 Chone 130709 3659139 0.060445210314505046 f http://qa.geonames.org/qa/kml/EC080119Esmeraldas.kml EC 09 Esmeraldas 080119 3657990 0.05997071943390136 f http://qa.geonames.org/qa/kml/EC020106Guaranda.kml EC 03 Guaranda 020106 3657571 0.059557249978109024 f http://qa.geonames.org/qa/kml/EC091905Narcisa De Jesus.kml EC 10 Narcisa De Jesus 091905 3653805 0.05913308522824064 f http://qa.geonames.org/qa/kml/EC100213Otavalo.kml EC 11 Otavalo 100213 3653693 0.05910436518582825 f http://qa.geonames.org/qa/kml/EC170513Belisario Quevedo.kml EC 18 Belisario Quevedo 170513 3660258 0.05701611300478004 f http://qa.geonames.org/qa/kml/EC130118Portoviejo.kml EC 14 Portoviejo 130118 3652941 0.05657580723643251 f http://qa.geonames.org/qa/kml/EC120407Quinsaloma.kml EC 13 Quinsaloma 120407 3660367 0.05573871065689497 f http://qa.geonames.org/qa/kml/EC120507Vinces.kml EC 13 Vinces 120507 3650186 0.054904216865854436 f http://qa.geonames.org/qa/kml/EC130309Jipijapa.kml EC 14 Jipijapa 130309 3655446 0.054802583512387835 f http://qa.geonames.org/qa/kml/EC210402Shushufindi.kml EC 22 Shushufindi 210402 3651092 0.0538577070865757 f http://qa.geonames.org/qa/kml/EC130220Manta.kml EC 14 Manta 130220 3654410 0.053634211515270806 f http://qa.geonames.org/qa/kml/EC100303Quiroga.kml EC 11 Quiroga 100303 3652478 0.05235841116580663 f http://qa.geonames.org/qa/kml/EC170511Nayon.kml EC 18 Nayon 170511 3653845 0.05208384542971706 f http://qa.geonames.org/qa/kml/EC130708Ricaurte.kml EC 14 Ricaurte 130708 3652364 0.052047469386347356 t http://qa.geonames.org/qa/kml/EC120109Babahoyo.kml EC 13 Babahoyo 120109 3660418 0.05152249183070263 f http://qa.geonames.org/qa/kml/EC100113San Antonio.kml EC 11 San Antonio 100113 3652029 0.05151536441376649 f http://qa.geonames.org/qa/kml/EC130219Manta.kml EC 14 Manta 130219 3654410 0.05039866471055145 f http://qa.geonames.org/qa/kml/EC120312Mocache.kml EC 13 Mocache 120312 3654137 0.04976743105472938 f http://qa.geonames.org/qa/kml/EC130222Montecristi.kml EC 14 Montecristi 130222 3654055 0.04971637323301431 f http://qa.geonames.org/qa/kml/EC240110Colonche.kml EC 25 Colonche 240110 3658930 0.04947126666380279 f http://qa.geonames.org/qa/kml/EC170517Cochapamba.kml EC 18 Cochapamba 170517 8478208 0.049230236959877646 f http://qa.geonames.org/qa/kml/EC092002Junquillal.kml EC 10 Junquillal 092002 3655380 0.04870967492028848 f http://qa.geonames.org/qa/kml/EC170510Zambiza.kml EC 18 Zambiza 170510 3649966 0.04865621445570066 f http://qa.geonames.org/qa/kml/EC230113Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230113 3651297 0.04844481505486696 f http://qa.geonames.org/qa/kml/EC120603San Jacinto De Buena Fe.kml EC 13 San Jacinto De Buena Fe 120603 3660073 0.0478462617669476 f http://qa.geonames.org/qa/kml/EC020306Telimbela.kml EC 03 Telimbela 020306 3650726 0.04762031501712307 f http://qa.geonames.org/qa/kml/EC030303La Troncal.kml EC 04 La Troncal 030303 3654853 0.047461211323256904 f http://qa.geonames.org/qa/kml/EC050604Cusubamba.kml EC 07 Cusubamba 050604 3658546 0.04702260633581428 f http://qa.geonames.org/qa/kml/EC120404Ventanas.kml EC 13 Ventanas 120404 3650267 0.046737976838280085 f http://qa.geonames.org/qa/kml/EC110120Vilcabamba (Victoria)-San Pedro De Vilcabamba.kml EC 12 Vilcabamba (Victoria)-San Pedro De Vilcabamba 110120 3651559 0.04668310693346319 f http://qa.geonames.org/qa/kml/EC050303Ramon Campaña.kml EC 07 Ramon Campaña 050303 3652441 0.04660751299801737 f http://qa.geonames.org/qa/kml/EC130115Portoviejo.kml EC 14 Portoviejo 130115 3652941 0.04599361742282254 f http://qa.geonames.org/qa/kml/EC130217Montecristi.kml EC 14 Montecristi 130217 3654055 0.04583127755315756 f http://qa.geonames.org/qa/kml/EC230111Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230111 3651297 0.04540769674167105 f http://qa.geonames.org/qa/kml/EC120107Babahoyo.kml EC 13 Babahoyo 120107 3660418 0.045269260160066355 f http://qa.geonames.org/qa/kml/EC130218Montecristi.kml EC 14 Montecristi 130218 3654055 0.044660475268549084 f http://qa.geonames.org/qa/kml/EC100117Ambuqui.kml EC 11 Ambuqui 100117 3660683 0.044627302053270534 t http://qa.geonames.org/qa/kml/EC130310La Union-America.kml EC 14 La Union-America 130310 3653886 0.04441396867836278 t http://qa.geonames.org/qa/kml/EC170304Comite Del Pueblo.kml EC 18 Comite Del Pueblo 170304 8478209 0.04416294917259056 f http://qa.geonames.org/qa/kml/EC040106Tulcan.kml EC 05 Tulcan 040106 3650472 0.043869119444327455 f http://qa.geonames.org/qa/kml/EC010305Pucara.kml EC 02 Pucara 010305 3652839 0.042359038909205386 f http://qa.geonames.org/qa/kml/EC070109Pasaje.kml EC 08 Pasaje 070109 3653403 0.04151343968883969 f http://qa.geonames.org/qa/kml/EC240101Santa Elena.kml EC 25 Santa Elena 240101 3651438 0.041291771809341224 f http://qa.geonames.org/qa/kml/EC010216Quingeo.kml EC 02 Quingeo 010216 3652502 0.04121835930551044 f http://qa.geonames.org/qa/kml/EC020108Salinas.kml EC 03 Salinas 020108 3652101 0.040924603621239314 f http://qa.geonames.org/qa/kml/EC170512Mariscal Sucre.kml EC 18 Mariscal Sucre 170512 7116565 0.039664517820952636 f http://qa.geonames.org/qa/kml/EC130504El Carmen.kml EC 14 El Carmen 130504 3658336 0.03892900388426248 f http://qa.geonames.org/qa/kml/EC010218Valle.kml EC 02 Valle 010218 3650292 0.038371542048072096 f http://qa.geonames.org/qa/kml/EC170712La Ecuatoriana.kml EC 18 La Ecuatoriana 170712 8478219 0.03768028343852219 f http://qa.geonames.org/qa/kml/EC170515Cochapamba.kml EC 18 Cochapamba 170515 8478208 0.037475295593924075 f http://qa.geonames.org/qa/kml/EC130114Portoviejo.kml EC 14 Portoviejo 130114 3652941 0.0371185452771404 f http://qa.geonames.org/qa/kml/EC080118Esmeraldas.kml EC 09 Esmeraldas 080118 3657990 0.03695421994701016 f http://qa.geonames.org/qa/kml/EC120605Valencia.kml EC 13 Valencia 120605 3650301 0.036892895258732725 t http://qa.geonames.org/qa/kml/EC130110Portoviejo.kml EC 14 Portoviejo 130110 3652941 0.03643205536825635 f http://qa.geonames.org/qa/kml/EC060114Riobamba.kml EC 06 Riobamba 060114 3652350 0.03598143228025306 f http://qa.geonames.org/qa/kml/EC170514Cochapamba.kml EC 18 Cochapamba 170514 8478208 0.03554594604175506 f http://qa.geonames.org/qa/kml/EC170308El Condado.kml EC 18 El Condado 170308 8478211 0.035340139972021206 f http://qa.geonames.org/qa/kml/EC170316Puellaro.kml EC 18 Puellaro 170316 3652776 0.03329495164389851 f http://qa.geonames.org/qa/kml/EC170309El Condado.kml EC 18 El Condado 170309 8478211 0.03203130346607301 t http://qa.geonames.org/qa/kml/EC170306Cotocollao.kml EC 18 Cotocollao 170306 3658773 0.03177313138341178 f http://qa.geonames.org/qa/kml/EC110112Loja.kml EC 12 Loja 110112 3654667 0.03170084845679508 f http://qa.geonames.org/qa/kml/EC050115Toacaso.kml EC 07 Toacaso 050115 3650612 0.03146604201289542 t http://qa.geonames.org/qa/kml/EC220203Puerto Francisco De Orellana (Coca).kml EC 24 Puerto Francisco De Orellana (Coca) 220203 3652743 0.031454180528714036 t http://qa.geonames.org/qa/kml/EC050105Latacunga.kml EC 07 Latacunga 050105 3654870 0.03134178768600875 f http://qa.geonames.org/qa/kml/EC170610Solanda.kml EC 18 Solanda 170610 8478229 0.0312420141148371 f http://qa.geonames.org/qa/kml/EC050104Latacunga.kml EC 07 Latacunga 050104 3654870 0.030963371364984383 f http://qa.geonames.org/qa/kml/EC070222Machala.kml EC 08 Machala 070222 3654533 0.030501061998830643 f http://qa.geonames.org/qa/kml/EC180109Izamba.kml EC 19 Izamba 180109 3655545 0.030422068516430232 f http://qa.geonames.org/qa/kml/EC060113Riobamba.kml EC 06 Riobamba 060113 3652350 0.03026202219217193 f http://qa.geonames.org/qa/kml/EC130216Manta.kml EC 14 Manta 130216 3654410 0.03015108320719089 f http://qa.geonames.org/qa/kml/EC090604Guayaquil-Mapasingue.kml EC 10 Guayaquil-Mapasingue 090604 3654378 0.03003161944163155 f http://qa.geonames.org/qa/kml/EC120314Mocache.kml EC 13 Mocache 120314 3654137 0.02975952418795886 f http://qa.geonames.org/qa/kml/EC090105Guayaquil-Guasmo.kml EC 10 Guayaquil-Guasmo 090105 3657533 0.02968761406104051 f http://qa.geonames.org/qa/kml/EC230206Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230206 3651297 0.029285806077976886 f http://qa.geonames.org/qa/kml/EC170310Pomasqui.kml EC 18 Pomasqui 170310 3652977 0.029281733280222717 f http://qa.geonames.org/qa/kml/EC070214Machala.kml EC 08 Machala 070214 3654533 0.029274887313047445 f http://qa.geonames.org/qa/kml/EC180604Pinguili-Mocha.kml EC 19 Pinguili-Mocha 180604 3655581 0.029250677669824927 f http://qa.geonames.org/qa/kml/EC080117Esmeraldas.kml EC 09 Esmeraldas 080117 3657990 0.02870073832407724 f http://qa.geonames.org/qa/kml/EC170508Kennedy.kml EC 18 Kennedy 170508 8478217 0.028535813485033854 f http://qa.geonames.org/qa/kml/EC080115Vuelta Larga.kml EC 09 Vuelta Larga 080115 3650152 0.028295576068650363 f http://qa.geonames.org/qa/kml/EC100205Gonzalez Suarez-San Rafael.kml EC 11 Gonzalez Suarez-San Rafael 100205 10174981 0.028052270593413874 f http://qa.geonames.org/qa/kml/EC110206La Tingue.kml EC 12 La Tingue 110206 3654864 0.027688368735828344 t http://qa.geonames.org/qa/kml/EC120307Quevedo.kml EC 13 Quevedo 120307 3652567 0.02679128723053499 f http://qa.geonames.org/qa/kml/EC230208Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230208 3651297 0.026784954534602487 t http://qa.geonames.org/qa/kml/EC170516Belisario Quevedo.kml EC 18 Belisario Quevedo 170516 3660258 0.026313606169147036 f http://qa.geonames.org/qa/kml/EC120118Baba.kml EC 13 Baba 120118 3660422 0.025915240109855985 f http://qa.geonames.org/qa/kml/EC200106Isla Pinzon.kml EC 01 Isla Pinzon 200106 null 0.025601419910856814 t http://qa.geonames.org/qa/kml/EC170312Calacali.kml EC 18 Calacali 170312 3659930 0.02516888147392827 f http://qa.geonames.org/qa/kml/EC070215Machala.kml EC 08 Machala 070215 3654533 0.024972365510452458 f http://qa.geonames.org/qa/kml/EC070221Machala.kml EC 08 Machala 070221 3654533 0.0245028715464622 f http://qa.geonames.org/qa/kml/EC120309Quevedo.kml EC 13 Quevedo 120309 3652567 0.02444347687740372 t http://qa.geonames.org/qa/kml/EC130113Portoviejo.kml EC 14 Portoviejo 130113 3652941 0.024362348474357174 f http://qa.geonames.org/qa/kml/EC230112Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230112 3651297 0.024115107312549074 f http://qa.geonames.org/qa/kml/EC130109Portoviejo.kml EC 14 Portoviejo 130109 3652941 0.023828005928028268 f http://qa.geonames.org/qa/kml/EC060119Chambo.kml EC 06 Chambo 060119 3659451 0.02354486324678476 f http://qa.geonames.org/qa/kml/EC050411Tingo.kml EC 07 Tingo 050411 3650650 0.023544089179811645 f http://qa.geonames.org/qa/kml/EC170307El Condado.kml EC 18 El Condado 170307 8478211 0.02308926313065817 f http://qa.geonames.org/qa/kml/EC171004Cayambe.kml EC 18 Cayambe 171004 3659578 0.02302777964050378 f http://qa.geonames.org/qa/kml/EC030107Guapan.kml EC 04 Guapan 030107 3657576 0.022959201193653543 t http://qa.geonames.org/qa/kml/EC240111Manglaralto.kml EC 25 Manglaralto 240111 3654423 0.02249965536018538 f http://qa.geonames.org/qa/kml/EC230109Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230109 3651297 0.022481291836960158 f http://qa.geonames.org/qa/kml/EC070223Machala.kml EC 08 Machala 070223 3654533 0.021859538561984554 f http://qa.geonames.org/qa/kml/EC240205Salinas.kml EC 25 Salinas 240205 3652100 0.0218514690482752 f http://qa.geonames.org/qa/kml/EC130215Manta.kml EC 14 Manta 130215 3654410 0.02182901736877239 f http://qa.geonames.org/qa/kml/EC171105Sangolqui.kml EC 18 Sangolqui 171105 3651857 0.021814941128895662 f http://qa.geonames.org/qa/kml/EC180211Santa Rosa.kml EC 19 Santa Rosa 180211 3651377 0.02175220444536307 f http://qa.geonames.org/qa/kml/EC010306Pucara.kml EC 02 Pucara 010306 3652839 0.021423409515805753 f http://qa.geonames.org/qa/kml/EC230110Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230110 3651297 0.021320974949594923 t http://qa.geonames.org/qa/kml/EC092303Tarifa.kml EC 10 Tarifa 092303 3650769 0.02116708093963108 t http://qa.geonames.org/qa/kml/EC090106Guayaquil-Guasmo.kml EC 10 Guayaquil-Guasmo 090106 3657533 0.021150986106698313 f http://qa.geonames.org/qa/kml/EC131202Rocafuerte.kml EC 14 Rocafuerte 131202 3652315 0.020974035761931024 t http://qa.geonames.org/qa/kml/EC080108Esmeraldas.kml EC 09 Esmeraldas 080108 3657990 0.02031811749772136 f http://qa.geonames.org/qa/kml/EC170611La Mena.kml EC 18 La Mena 170611 8478231 0.02015893162725077 t http://qa.geonames.org/qa/kml/EC120402Zapotal.kml EC 13 Zapotal 120402 3649928 0.019941074917266953 f http://qa.geonames.org/qa/kml/EC110110Loja.kml EC 12 Loja 110110 3654667 0.019912643573986543 f http://qa.geonames.org/qa/kml/EC170909Pifo.kml EC 18 Pifo 170909 8604722 0.019855722217846563 t http://qa.geonames.org/qa/kml/EC070220Machala.kml EC 08 Machala 070220 3654533 0.019733804224757356 f http://qa.geonames.org/qa/kml/EC050602San Miguel.kml EC 07 San Miguel 050602 3651613 0.019718744740689426 f http://qa.geonames.org/qa/kml/EC080107Esmeraldas.kml EC 09 Esmeraldas 080107 3657990 0.019672100846724293 f http://qa.geonames.org/qa/kml/EC170809Amaguaña.kml EC 18 Amaguaña 170809 3660711 0.019645105355553437 f http://qa.geonames.org/qa/kml/EC110111Loja.kml EC 12 Loja 110111 3654667 0.01915523930871942 f http://qa.geonames.org/qa/kml/EC171203Puerto Quito.kml EC 18 Puerto Quito 171203 3652712 0.018910957193757724 t http://qa.geonames.org/qa/kml/EC170303Comite Del Pueblo.kml EC 18 Comite Del Pueblo 170303 8478209 0.018611711666716657 f http://qa.geonames.org/qa/kml/EC170506Rumipamba.kml EC 18 Rumipamba 170506 8478226 0.018582166414076118 f http://qa.geonames.org/qa/kml/EC060106Riobamba.kml EC 06 Riobamba 060106 3652350 0.0183314178030635 f http://qa.geonames.org/qa/kml/EC080116Esmeraldas.kml EC 09 Esmeraldas 080116 3657990 0.018279018127292903 f http://qa.geonames.org/qa/kml/EC170707Guamani.kml EC 18 Guamani 170707 3657629 0.01801211956161898 f http://qa.geonames.org/qa/kml/EC230207Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230207 3651297 0.01795170550212816 f http://qa.geonames.org/qa/kml/EC170706Guamani.kml EC 18 Guamani 170706 3657629 0.017902132183641915 f http://qa.geonames.org/qa/kml/EC120103Babahoyo.kml EC 13 Babahoyo 120103 3660418 0.017752194668010642 f http://qa.geonames.org/qa/kml/EC110106Loja.kml EC 12 Loja 110106 3654667 0.017593430421778248 f http://qa.geonames.org/qa/kml/EC170305Ponceano.kml EC 18 Ponceano 170305 8478222 0.017472949481434307 f http://qa.geonames.org/qa/kml/EC180207Ambato.kml EC 19 Ambato 180207 3660689 0.01745991687723262 f http://qa.geonames.org/qa/kml/EC070218Machala.kml EC 08 Machala 070218 3654533 0.017452445173607462 f http://qa.geonames.org/qa/kml/EC130212Manta.kml EC 14 Manta 130212 3654410 0.0174159363913685 f http://qa.geonames.org/qa/kml/EC170410Puengasi.kml EC 18 Puengasi 170410 8478223 0.017187965458117203 f http://qa.geonames.org/qa/kml/EC070103Pasaje.kml EC 08 Pasaje 070103 3653403 0.017129538792153398 t http://qa.geonames.org/qa/kml/EC070211Machala.kml EC 08 Machala 070211 3654533 0.017027085321506066 f http://qa.geonames.org/qa/kml/EC130210Manta.kml EC 14 Manta 130210 3654410 0.016786710800004167 f http://qa.geonames.org/qa/kml/EC180101Ambato.kml EC 19 Ambato 180101 3660689 0.016505545522422678 f http://qa.geonames.org/qa/kml/EC171007Cayambe.kml EC 18 Cayambe 171007 3659578 0.01636966691330045 f http://qa.geonames.org/qa/kml/EC180204Ambato.kml EC 19 Ambato 180204 3660689 0.016350835246458903 f http://qa.geonames.org/qa/kml/EC050106Latacunga.kml EC 07 Latacunga 050106 3654870 0.01631437301363885 t http://qa.geonames.org/qa/kml/EC030108Azogues.kml EC 04 Azogues 030108 3660434 0.016239722083368057 f http://qa.geonames.org/qa/kml/EC091203Naranjal.kml EC 10 Naranjal 091203 3653882 0.016204131640430105 t http://qa.geonames.org/qa/kml/EC170708La Ecuatoriana.kml EC 18 La Ecuatoriana 170708 8478219 0.01618443226953972 t http://qa.geonames.org/qa/kml/EC110105Loja.kml EC 12 Loja 110105 3654667 0.016178647847255867 f http://qa.geonames.org/qa/kml/EC060112Riobamba.kml EC 06 Riobamba 060112 3652350 0.015908858432675803 f http://qa.geonames.org/qa/kml/EC120308Quevedo.kml EC 13 Quevedo 120308 3652567 0.015504165217680535 f http://qa.geonames.org/qa/kml/EC060403Guamote.kml EC 06 Guamote 060403 3657621 0.015464218586763357 t http://qa.geonames.org/qa/kml/EC230205Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230205 3651297 0.015422423770148843 f http://qa.geonames.org/qa/kml/EC230202Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230202 3651297 0.015375643375467842 f http://qa.geonames.org/qa/kml/EC070219Machala.kml EC 08 Machala 070219 3654533 0.015235237295014463 f http://qa.geonames.org/qa/kml/EC091714Milagro.kml EC 10 Milagro 091714 3654215 0.015222377431782279 f http://qa.geonames.org/qa/kml/EC070216Machala.kml EC 08 Machala 070216 3654533 0.015040977510149163 f http://qa.geonames.org/qa/kml/EC110104Loja.kml EC 12 Loja 110104 3654667 0.014762814227984408 f http://qa.geonames.org/qa/kml/EC070504Huaquillas.kml EC 08 Huaquillas 070504 3655720 0.014634802851654846 f http://qa.geonames.org/qa/kml/EC210202Nueva Loja.kml EC 22 Nueva Loja 210202 3655185 0.01462038019624273 f http://qa.geonames.org/qa/kml/EC091712Milagro.kml EC 10 Milagro 091712 3654215 0.014535507135107102 f http://qa.geonames.org/qa/kml/EC050404Pujili.kml EC 07 Pujili 050404 3652684 0.014457980268895634 t http://qa.geonames.org/qa/kml/EC180102Ambato.kml EC 19 Ambato 180102 3660689 0.014435472931111231 f http://qa.geonames.org/qa/kml/EC130111Portoviejo.kml EC 14 Portoviejo 130111 3652941 0.014339934283043615 f http://qa.geonames.org/qa/kml/EC080202Luis V. Torres (Cab. En Playa De Oro)-Selva Alegre-Colon Eloy Del Maria-Maldonado-Timbire.kml EC 09 Luis V. Torres (Cab. En Playa De Oro)-Selva Alegre-Colon Eloy Del Maria-Maldonado-Timbire 080202 null 0.014286905192945055 t http://qa.geonames.org/qa/kml/EC130208Manta.kml EC 14 Manta 130208 3654410 0.01426669173041312 f http://qa.geonames.org/qa/kml/EC130305Jipijapa.kml EC 14 Jipijapa 130305 3655446 0.01413592877715005 f http://qa.geonames.org/qa/kml/EC080103Esmeraldas.kml EC 09 Esmeraldas 080103 3657990 0.013931661333498447 f http://qa.geonames.org/qa/kml/EC130211Manta.kml EC 14 Manta 130211 3654410 0.013361195635233759 f http://qa.geonames.org/qa/kml/EC130108Portoviejo.kml EC 14 Portoviejo 130108 3652941 0.013333496755050127 f http://qa.geonames.org/qa/kml/EC091709Milagro.kml EC 10 Milagro 091709 3654215 0.013332799346393844 f http://qa.geonames.org/qa/kml/EC060105Riobamba.kml EC 06 Riobamba 060105 3652350 0.013313576503972073 f http://qa.geonames.org/qa/kml/EC091710Milagro.kml EC 10 Milagro 091710 3654215 0.013136100754716697 f http://qa.geonames.org/qa/kml/EC070209Machala.kml EC 08 Machala 070209 3654533 0.013092594901260869 f http://qa.geonames.org/qa/kml/EC080102Esmeraldas.kml EC 09 Esmeraldas 080102 3657990 0.013007530991443746 f http://qa.geonames.org/qa/kml/EC070217Machala.kml EC 08 Machala 070217 3654533 0.012718601375486995 f http://qa.geonames.org/qa/kml/EC100203Otavalo.kml EC 11 Otavalo 100203 3653693 0.012676529756437899 f http://qa.geonames.org/qa/kml/EC131103Bahia De Caraquez.kml EC 14 Bahia De Caraquez 131103 3660401 0.012654552114504178 f http://qa.geonames.org/qa/kml/EC230108Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230108 3651297 0.012564673501503375 f http://qa.geonames.org/qa/kml/EC170705Turubamba.kml EC 18 Turubamba 170705 8478230 0.01232852331481094 f http://qa.geonames.org/qa/kml/EC230106Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230106 3651297 0.012224852637440626 f http://qa.geonames.org/qa/kml/EC170607San Bartolo.kml EC 18 San Bartolo 170607 8478227 0.012219186437036917 f http://qa.geonames.org/qa/kml/EC091708Milagro.kml EC 10 Milagro 091708 3654215 0.012184119789365785 f http://qa.geonames.org/qa/kml/EC091707Milagro.kml EC 10 Milagro 091707 3654215 0.012174989368966771 f http://qa.geonames.org/qa/kml/EC230104Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230104 3651297 0.011845775864934068 f http://qa.geonames.org/qa/kml/EC180206Ambato.kml EC 19 Ambato 180206 3660689 0.011573940143690929 f http://qa.geonames.org/qa/kml/EC240204La Libertad.kml EC 25 La Libertad 240204 3655131 0.011550571458062778 f http://qa.geonames.org/qa/kml/EC120505Vinces.kml EC 13 Vinces 120505 3650186 0.011521804047232558 f http://qa.geonames.org/qa/kml/EC171104Sangolqui.kml EC 18 Sangolqui 171104 3651857 0.011413087683344154 f http://qa.geonames.org/qa/kml/EC130209Manta.kml EC 14 Manta 130209 3654410 0.01122321462120672 f http://qa.geonames.org/qa/kml/EC180104Ambato.kml EC 19 Ambato 180104 3660689 0.011019532591184697 f http://qa.geonames.org/qa/kml/EC020102Guaranda.kml EC 03 Guaranda 020102 3657571 0.010831729225841488 t http://qa.geonames.org/qa/kml/EC060101Riobamba.kml EC 06 Riobamba 060101 3652350 0.010653997482015657 f http://qa.geonames.org/qa/kml/EC110109Loja.kml EC 12 Loja 110109 3654667 0.010631380514770201 f http://qa.geonames.org/qa/kml/EC120202Catarama.kml EC 13 Catarama 120202 3659592 0.010557093059907003 f http://qa.geonames.org/qa/kml/EC100209San Roque.kml EC 11 San Roque 100209 3651517 0.010544409617937373 t http://qa.geonames.org/qa/kml/EC070213Machala.kml EC 08 Machala 070213 3654533 0.010454368412601032 f http://qa.geonames.org/qa/kml/EC090507Guayaquil-Alborada.kml EC 10 Guayaquil-Alborada 090507 7116567 0.01043173064979397 f http://qa.geonames.org/qa/kml/EC070210Machala.kml EC 08 Machala 070210 3654533 0.01034233585194034 f http://qa.geonames.org/qa/kml/EC130112Portoviejo.kml EC 14 Portoviejo 130112 3652941 0.0102129063256174 t http://qa.geonames.org/qa/kml/EC220204San Luis De Armenia.kml EC 24 San Luis De Armenia 220204 3660552 0.01016742765922582 t http://qa.geonames.org/qa/kml/EC040104Tulcan.kml EC 05 Tulcan 040104 3650472 0.010135183126097073 t http://qa.geonames.org/qa/kml/EC130207Manta.kml EC 14 Manta 130207 3654410 0.010047388962451838 f http://qa.geonames.org/qa/kml/EC060404Guamote.kml EC 06 Guamote 060404 3657621 0.010013013143014523 f http://qa.geonames.org/qa/kml/EC180103Ambato.kml EC 19 Ambato 180103 3660689 0.009971067281287683 f http://qa.geonames.org/qa/kml/EC170609Chilibulo.kml EC 18 Chilibulo 170609 8478206 0.009932346999355 f http://qa.geonames.org/qa/kml/EC170711Guamani.kml EC 18 Guamani 170711 3657629 0.00993106871696128 f http://qa.geonames.org/qa/kml/EC070212Machala.kml EC 08 Machala 070212 3654533 0.009878260772213538 f http://qa.geonames.org/qa/kml/EC010401Gualaceo.kml EC 02 Gualaceo 010401 3657670 0.009786571862079346 f http://qa.geonames.org/qa/kml/EC070204Machala.kml EC 08 Machala 070204 3654533 0.009763323736811592 f http://qa.geonames.org/qa/kml/EC140407San Miguel De Cuyes.kml EC 15 San Miguel De Cuyes 140407 3651615 0.00966856201921859 t http://qa.geonames.org/qa/kml/EC060110Riobamba.kml EC 06 Riobamba 060110 3652350 0.009468839019072452 f http://qa.geonames.org/qa/kml/EC060109Riobamba.kml EC 06 Riobamba 060109 3652350 0.009424202159894358 f http://qa.geonames.org/qa/kml/EC070203Machala.kml EC 08 Machala 070203 3654533 0.009276726482838513 f http://qa.geonames.org/qa/kml/EC170814Amaguaña.kml EC 18 Amaguaña 170814 3660711 0.00923391691875375 t http://qa.geonames.org/qa/kml/EC130107Portoviejo.kml EC 14 Portoviejo 130107 3652941 0.009173413015765946 f http://qa.geonames.org/qa/kml/EC180208Ambato.kml EC 19 Ambato 180208 3660689 0.009161962083158311 f http://qa.geonames.org/qa/kml/EC080113Esmeraldas.kml EC 09 Esmeraldas 080113 3657990 0.00913269906324706 t http://qa.geonames.org/qa/kml/EC050302Pinllopata.kml EC 07 Pinllopata 050302 3653101 0.009037863447611566 t http://qa.geonames.org/qa/kml/EC070502Huaquillas.kml EC 08 Huaquillas 070502 3655720 0.008918117447973184 f http://qa.geonames.org/qa/kml/EC120106Babahoyo.kml EC 13 Babahoyo 120106 3660418 0.008835306953799712 t http://qa.geonames.org/qa/kml/EC050301El Corazon.kml EC 07 El Corazon 050301 3658293 0.008793913356961273 t http://qa.geonames.org/qa/kml/EC091711Milagro.kml EC 10 Milagro 091711 3654215 0.008740819331272047 f http://qa.geonames.org/qa/kml/EC230103Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230103 3651297 0.008688103524913303 f http://qa.geonames.org/qa/kml/EC120306Quevedo.kml EC 13 Quevedo 120306 3652567 0.008543753131764743 f http://qa.geonames.org/qa/kml/EC080120Vuelta Larga.kml EC 09 Vuelta Larga 080120 3650152 0.008471557875366586 t http://qa.geonames.org/qa/kml/EC070112Uzhcurrumi.kml EC 08 Uzhcurrumi 070112 null 0.008439259049423786 t http://qa.geonames.org/qa/kml/EC120301Quevedo.kml EC 13 Quevedo 120301 3652567 0.008146386196797663 f http://qa.geonames.org/qa/kml/EC130101Portoviejo.kml EC 14 Portoviejo 130101 3652941 0.008125568722875487 f http://qa.geonames.org/qa/kml/EC170404Puengasi.kml EC 18 Puengasi 170404 8478223 0.008091034945597958 f http://qa.geonames.org/qa/kml/EC090505Guayaquil- Kennedy.kml EC 10 Guayaquil- Kennedy 090505 7116568 0.00806150753488978 t http://qa.geonames.org/qa/kml/EC230204Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230204 3651297 0.007940890447956728 f http://qa.geonames.org/qa/kml/EC230105Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230105 3651297 0.007893823393690368 f http://qa.geonames.org/qa/kml/EC050103Latacunga.kml EC 07 Latacunga 050103 3654870 0.007753029597394967 f http://qa.geonames.org/qa/kml/EC020104Guaranda.kml EC 03 Guaranda 020104 3657571 0.007728904674584657 t http://qa.geonames.org/qa/kml/EC070101Pasaje.kml EC 08 Pasaje 070101 3653403 0.007710359310412753 f http://qa.geonames.org/qa/kml/EC171101Sangolqui.kml EC 18 Sangolqui 171101 3651857 0.007672182291815822 f http://qa.geonames.org/qa/kml/EC060107Riobamba.kml EC 06 Riobamba 060107 3652350 0.007617669670418845 f http://qa.geonames.org/qa/kml/EC080104Esmeraldas.kml EC 09 Esmeraldas 080104 3657990 0.007505990468963613 f http://qa.geonames.org/qa/kml/EC130206Manta.kml EC 14 Manta 130206 3654410 0.007415926822593431 f http://qa.geonames.org/qa/kml/EC171112Machachi.kml EC 18 Machachi 171112 3654536 0.007261229535241095 f http://qa.geonames.org/qa/kml/EC070503Huaquillas.kml EC 08 Huaquillas 070503 3655720 0.007022904665880467 f http://qa.geonames.org/qa/kml/EC060108Riobamba.kml EC 06 Riobamba 060108 3652350 0.0070002976351399475 f http://qa.geonames.org/qa/kml/EC190105Zamora.kml EC 20 Zamora 190105 3649959 0.0068496656585173435 t http://qa.geonames.org/qa/kml/EC130205Manta.kml EC 14 Manta 130205 3654410 0.006846235035133167 f http://qa.geonames.org/qa/kml/EC160103Canelos-Veracruz (Cab. En Indillama)-Pomona-Simon Bolivar (Cab En Mushullama.kml EC 17 Canelos-Veracruz (Cab. En Indillama)-Pomona-Simon Bolivar (Cab En Mushullama 160103 null 0.00676092555406061 t http://qa.geonames.org/qa/kml/EC080101Esmeraldas.kml EC 09 Esmeraldas 080101 3657990 0.0066069377897242125 f http://qa.geonames.org/qa/kml/EC120303Quevedo.kml EC 13 Quevedo 120303 3652567 0.0065051863235506555 t http://qa.geonames.org/qa/kml/EC110102Loja.kml EC 12 Loja 110102 3654667 0.006412632903015707 f http://qa.geonames.org/qa/kml/EC091706Milagro.kml EC 10 Milagro 091706 3654215 0.006388518186332219 f http://qa.geonames.org/qa/kml/EC130306Jipijapa.kml EC 14 Jipijapa 130306 3655446 0.006365282807034057 f http://qa.geonames.org/qa/kml/EC110204San Pedro De La Bendita.kml EC 12 San Pedro De La Bendita 110204 3651546 0.006348785165606932 f http://qa.geonames.org/qa/kml/EC130204Manta.kml EC 14 Manta 130204 3654410 0.006293505975323957 f http://qa.geonames.org/qa/kml/EC050108Latacunga.kml EC 07 Latacunga 050108 3654870 0.006120770886579607 f http://qa.geonames.org/qa/kml/EC180201Ambato.kml EC 19 Ambato 180201 3660689 0.00602035021793913 f http://qa.geonames.org/qa/kml/EC070208Machala.kml EC 08 Machala 070208 3654533 0.0060079794149779315 f http://qa.geonames.org/qa/kml/EC130106Portoviejo.kml EC 14 Portoviejo 130106 3652941 0.006006031682219398 f http://qa.geonames.org/qa/kml/EC160102Puyo.kml EC 17 Puyo 160102 3652584 0.0058370745054401145 f http://qa.geonames.org/qa/kml/EC120104Babahoyo.kml EC 13 Babahoyo 120104 3660418 0.005568518889757549 f http://qa.geonames.org/qa/kml/EC020302San Sebastian-San Jose De Chimbo.kml EC 03 San Sebastian-San Jose De Chimbo 020302 null 0.005446695670487726 t http://qa.geonames.org/qa/kml/EC091705Milagro.kml EC 10 Milagro 091705 3654215 0.0053470292390634805 f http://qa.geonames.org/qa/kml/EC090506Guayaquil-Urdesa.kml EC 10 Guayaquil-Urdesa 090506 7116566 0.005189106801012959 f http://qa.geonames.org/qa/kml/EC120102Babahoyo.kml EC 13 Babahoyo 120102 3660418 0.005102460271662387 f http://qa.geonames.org/qa/kml/EC131009Jama.kml EC 14 Jama 131009 3655522 0.005082559894843274 t http://qa.geonames.org/qa/kml/EC091702Milagro.kml EC 10 Milagro 091702 3654215 0.005077151353175572 f http://qa.geonames.org/qa/kml/EC170503Jipijapa.kml EC 18 Jipijapa 170503 8478216 0.005032132666865958 f http://qa.geonames.org/qa/kml/EC170504Iñaquito.kml EC 18 Iñaquito 170504 8478214 0.0050175130812767305 f http://qa.geonames.org/qa/kml/EC120302Quevedo.kml EC 13 Quevedo 120302 3652567 0.005004846964846136 f http://qa.geonames.org/qa/kml/EC170703Quitumbe.kml EC 18 Quitumbe 170703 8478224 0.0047029807732934 f http://qa.geonames.org/qa/kml/EC080110Esmeraldas.kml EC 09 Esmeraldas 080110 3657990 0.0046931513147481455 f http://qa.geonames.org/qa/kml/EC240203La Libertad.kml EC 25 La Libertad 240203 3655131 0.004685962105268612 f http://qa.geonames.org/qa/kml/EC120101Babahoyo.kml EC 13 Babahoyo 120101 3660418 0.004588292281120133 f http://qa.geonames.org/qa/kml/EC090502Guayaquil-Alborada.kml EC 10 Guayaquil-Alborada 090502 7116567 0.0045757692188862975 f http://qa.geonames.org/qa/kml/EC210204Nueva Loja.kml EC 22 Nueva Loja 210204 3655185 0.004511090638214618 f http://qa.geonames.org/qa/kml/EC130501El Carmen.kml EC 14 El Carmen 130501 3658336 0.0044967391406694306 f http://qa.geonames.org/qa/kml/EC170904Cumbaya.kml EC 18 Cumbaya 170904 3658625 0.004415630360483015 t http://qa.geonames.org/qa/kml/EC070104Pasaje.kml EC 08 Pasaje 070104 3653403 0.004234191721809448 t http://qa.geonames.org/qa/kml/EC091703Milagro.kml EC 10 Milagro 091703 3654215 0.004214525509525523 t http://qa.geonames.org/qa/kml/EC170408Itchimbia.kml EC 18 Itchimbia 170408 8478215 0.004203431558547705 f http://qa.geonames.org/qa/kml/EC130102Portoviejo.kml EC 14 Portoviejo 130102 3652941 0.004114044694695391 f http://qa.geonames.org/qa/kml/EC040102Tulcan.kml EC 05 Tulcan 040102 3650472 0.004044545743561938 t http://qa.geonames.org/qa/kml/EC130701Chone.kml EC 14 Chone 130701 3659139 0.0040055074877202975 t http://qa.geonames.org/qa/kml/EC091907Santa Lucia.kml EC 10 Santa Lucia 091907 3651412 0.003935675422315372 t http://qa.geonames.org/qa/kml/EC070205Machala.kml EC 08 Machala 070205 3654533 0.003896125971871456 f http://qa.geonames.org/qa/kml/EC070102Pasaje.kml EC 08 Pasaje 070102 3653403 0.003790708809790887 f http://qa.geonames.org/qa/kml/EC050107Latacunga.kml EC 07 Latacunga 050107 3654870 0.0037763817615604663 t http://qa.geonames.org/qa/kml/EC080106Esmeraldas.kml EC 09 Esmeraldas 080106 3657990 0.003775521703610274 f http://qa.geonames.org/qa/kml/EC080109Esmeraldas.kml EC 09 Esmeraldas 080109 3657990 0.00376715224659449 f http://qa.geonames.org/qa/kml/EC070601Santa Rosa.kml EC 08 Santa Rosa 070601 3651356 0.0037277868417258248 f http://qa.geonames.org/qa/kml/EC171001Cayambe.kml EC 18 Cayambe 171001 3659578 0.003699454378368149 f http://qa.geonames.org/qa/kml/EC130103Portoviejo.kml EC 14 Portoviejo 130103 3652941 0.0036187285266473454 f http://qa.geonames.org/qa/kml/EC170710Turubamba.kml EC 18 Turubamba 170710 8478230 0.0035852994888103083 f http://qa.geonames.org/qa/kml/EC170301Ponceano.kml EC 18 Ponceano 170301 8478222 0.003582386255695089 t http://qa.geonames.org/qa/kml/EC160105Shell-Madre Tierra-Mera.kml EC 17 Shell-Madre Tierra-Mera 160105 null 0.0035428974359744936 t http://qa.geonames.org/qa/kml/EC110101Loja.kml EC 12 Loja 110101 3654667 0.0035171135627593162 f http://qa.geonames.org/qa/kml/EC050101Latacunga.kml EC 07 Latacunga 050101 3654870 0.0035018971160691663 t http://qa.geonames.org/qa/kml/EC130806Barraganete.kml EC 14 Barraganete 130806 8472260 0.0034992635416685636 t http://qa.geonames.org/qa/kml/EC091308Palestina.kml EC 10 Palestina 091308 3653583 0.0034563823953285555 t http://qa.geonames.org/qa/kml/EC070202Machala.kml EC 08 Machala 070202 3654533 0.0033670700061577867 f http://qa.geonames.org/qa/kml/EC120405Ventanas.kml EC 13 Ventanas 120405 3650267 0.003312528492059976 f http://qa.geonames.org/qa/kml/EC070201Machala.kml EC 08 Machala 070201 3654533 0.003200078607518496 f http://qa.geonames.org/qa/kml/EC130713Flavio Alfaro.kml EC 14 Flavio Alfaro 130713 3657919 0.0031896071924460132 t http://qa.geonames.org/qa/kml/EC180403Pelileo.kml EC 19 Pelileo 180403 3653287 0.002947796781748193 t http://qa.geonames.org/qa/kml/EC180401Pelileo.kml EC 19 Pelileo 180401 3653287 0.002929870831741543 f http://qa.geonames.org/qa/kml/EC130704Chone.kml EC 14 Chone 130704 3659139 0.0029163151738709793 t http://qa.geonames.org/qa/kml/EC070207Machala.kml EC 08 Machala 070207 3654533 0.002906904374043822 f http://qa.geonames.org/qa/kml/EC210203Nueva Loja.kml EC 22 Nueva Loja 210203 3655185 0.0028311740530445116 f http://qa.geonames.org/qa/kml/EC240201La Libertad.kml EC 25 La Libertad 240201 3655131 0.002778442913020136 f http://qa.geonames.org/qa/kml/EC130803Pichincha.kml EC 14 Pichincha 130803 3653226 0.002698391454442135 t http://qa.geonames.org/qa/kml/EC020103Guaranda.kml EC 03 Guaranda 020103 3657571 0.0026880991854836608 t http://qa.geonames.org/qa/kml/EC091701Milagro.kml EC 10 Milagro 091701 3654215 0.002636092771229227 f http://qa.geonames.org/qa/kml/EC180202Ambato.kml EC 19 Ambato 180202 3660689 0.002615749231413177 f http://qa.geonames.org/qa/kml/EC010212Valle.kml EC 02 Valle 010212 3650292 0.002604292013045977 t http://qa.geonames.org/qa/kml/EC060104Riobamba.kml EC 06 Riobamba 060104 3652350 0.0024587975384527307 f http://qa.geonames.org/qa/kml/EC060111Riobamba.kml EC 06 Riobamba 060111 3652350 0.0024580394092783855 f http://qa.geonames.org/qa/kml/EC230101Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230101 3651297 0.002393829541831153 f http://qa.geonames.org/qa/kml/EC130303Jipijapa.kml EC 14 Jipijapa 130303 3655446 0.002321324157135925 t http://qa.geonames.org/qa/kml/EC091204Naranjal.kml EC 10 Naranjal 091204 3653882 0.0023148593930617115 t http://qa.geonames.org/qa/kml/EC130104Portoviejo.kml EC 14 Portoviejo 130104 3652941 0.0022814063412637865 t http://qa.geonames.org/qa/kml/EC180203Ambato.kml EC 19 Ambato 180203 3660689 0.0022784536157255293 f http://qa.geonames.org/qa/kml/EC120502Vinces.kml EC 13 Vinces 120502 3650186 0.0022747533977093117 f http://qa.geonames.org/qa/kml/EC230116Alluriquin.kml EC 26 Alluriquin 230116 3660760 0.0022561331939439017 t http://qa.geonames.org/qa/kml/EC130710Canuto.kml EC 14 Canuto 130710 3659780 0.002187129800778568 t http://qa.geonames.org/qa/kml/EC080112Esmeraldas.kml EC 09 Esmeraldas 080112 3657990 0.0021185929613626755 f http://qa.geonames.org/qa/kml/EC030301La Troncal.kml EC 04 La Troncal 030301 3654853 0.002116973734469412 t http://qa.geonames.org/qa/kml/EC130702Chone.kml EC 14 Chone 130702 3659139 0.0019677947840913428 t http://qa.geonames.org/qa/kml/EC091803Naranjito.kml EC 10 Naranjito 091803 3653873 0.0019114422079416105 t http://qa.geonames.org/qa/kml/EC230107Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230107 3651297 0.0019064011789053387 f http://qa.geonames.org/qa/kml/EC130304Jipijapa.kml EC 14 Jipijapa 130304 3655446 0.0018797406681359586 f http://qa.geonames.org/qa/kml/EC070507Arenillas.kml EC 08 Arenillas 070507 3660559 0.0018079520537340663 t http://qa.geonames.org/qa/kml/EC091301Balzar.kml EC 10 Balzar 091301 3660361 0.001799829482994047 t http://qa.geonames.org/qa/kml/EC090901Guayaquil-Puerto Hondo.kml EC 10 Guayaquil-Puerto Hondo 090901 null 0.0017076884028739724 t http://qa.geonames.org/qa/kml/EC150102Tena.kml EC 23 Tena 150102 3650721 0.0016952315637443417 t http://qa.geonames.org/qa/kml/EC120501Vinces.kml EC 13 Vinces 120501 3650186 0.001659799770405969 t http://qa.geonames.org/qa/kml/EC130201Manta.kml EC 14 Manta 130201 3654410 0.0016382223196123138 t http://qa.geonames.org/qa/kml/EC070606Victoria.kml EC 08 Victoria 070606 3650207 0.0016292406561019474 t http://qa.geonames.org/qa/kml/EC240102Santa Elena.kml EC 25 Santa Elena 240102 3651438 0.0015825706876299301 f http://qa.geonames.org/qa/kml/EC230203Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230203 3651297 0.0015496755744192614 f http://qa.geonames.org/qa/kml/EC120305Quevedo.kml EC 13 Quevedo 120305 3652567 0.001543636521127325 f http://qa.geonames.org/qa/kml/EC170505Iñaquito.kml EC 18 Iñaquito 170505 8478214 0.001542810133266225 t http://qa.geonames.org/qa/kml/EC090501Guayaquil-Alborada.kml EC 10 Guayaquil-Alborada 090501 7116567 0.0015007535304174216 f http://qa.geonames.org/qa/kml/EC110107Loja.kml EC 12 Loja 110107 3654667 0.0014506178279762596 t http://qa.geonames.org/qa/kml/EC170903Tumbaco.kml EC 18 Tumbaco 170903 3650463 0.0013806631167116875 t http://qa.geonames.org/qa/kml/EC130203Manta.kml EC 14 Manta 130203 3654410 0.0013707305572897993 t http://qa.geonames.org/qa/kml/EC220201Puerto Francisco De Orellana (Coca).kml EC 24 Puerto Francisco De Orellana (Coca) 220201 3652743 0.001324005234564876 t http://qa.geonames.org/qa/kml/EC110103Loja.kml EC 12 Loja 110103 3654667 0.0013127189465899315 f http://qa.geonames.org/qa/kml/EC091401Pedro Carbo.kml EC 10 Pedro Carbo 091401 3653295 0.0013056888260074727 t http://qa.geonames.org/qa/kml/EC040101Tulcan.kml EC 05 Tulcan 040101 3650472 0.0012735536558268446 t http://qa.geonames.org/qa/kml/EC120504Vinces.kml EC 13 Vinces 120504 3650186 0.0012183717665353894 t http://qa.geonames.org/qa/kml/EC240104Santa Elena.kml EC 25 Santa Elena 240104 3651438 0.001203868998632837 t http://qa.geonames.org/qa/kml/EC170405Centro Historico.kml EC 18 Centro Historico 170405 8478205 0.0011863809550718518 t http://qa.geonames.org/qa/kml/EC130503El Carmen.kml EC 14 El Carmen 130503 3658336 0.0011194402449063402 t http://qa.geonames.org/qa/kml/EC171003Cayambe.kml EC 18 Cayambe 171003 3659578 0.001115522536324976 f http://qa.geonames.org/qa/kml/EC230201Santo Domingo De Los Colorados.kml EC 26 Santo Domingo De Los Colorados 230201 3651297 0.0010726058887102707 t http://qa.geonames.org/qa/kml/EC091801Naranjito.kml EC 10 Naranjito 091801 3653873 0.0010598951804777835 f http://qa.geonames.org/qa/kml/EC131002Pedernales.kml EC 14 Pedernales 131002 3653307 0.0010313535630852356 t http://qa.geonames.org/qa/kml/EC010207Cuenca_El Batan.kml EC 02 Cuenca_El Batan 010207 null 0.0009506752444406265 t http://qa.geonames.org/qa/kml/EC240207Jose Luis Tamayo (Muey).kml EC 25 Jose Luis Tamayo (Muey) 240207 3655422 0.0009479024760972449 f http://qa.geonames.org/qa/kml/EC110404Chaquinal-12 De Diciembre (Cab En Achiotes).kml EC 12 Chaquinal-12 De Diciembre (Cab En Achiotes) 110404 null 0.0009393790167497117 t http://qa.geonames.org/qa/kml/EC120401Ventanas.kml EC 13 Ventanas 120401 3650267 0.0009333968326115208 t http://qa.geonames.org/qa/kml/EC170701Guamani.kml EC 18 Guamani 170701 3657629 0.0007363827965615253 f http://qa.geonames.org/qa/kml/EC130605Junin.kml EC 14 Junin 130605 3655385 0.0006843068228378115 t http://qa.geonames.org/qa/kml/EC030101Azogues.kml EC 04 Azogues 030101 3660434 0.0006477958284967603 t http://qa.geonames.org/qa/kml/EC070603Santa Rosa.kml EC 08 Santa Rosa 070603 3651356 0.0006337613614381856 t http://qa.geonames.org/qa/kml/EC080105Esmeraldas.kml EC 09 Esmeraldas 080105 3657990 0.0006331982554070777 f http://qa.geonames.org/qa/kml/EC130302Jipijapa.kml EC 14 Jipijapa 130302 3655446 0.0006117510301895159 t http://qa.geonames.org/qa/kml/EC120601San Jacinto De Buena Fe.kml EC 13 San Jacinto De Buena Fe 120601 3660073 0.000562690676397258 t http://qa.geonames.org/qa/kml/EC180105Ambato.kml EC 19 Ambato 180105 3660689 0.0005346887024701977 t http://qa.geonames.org/qa/kml/EC171103Sangolqui.kml EC 18 Sangolqui 171103 3651857 0.0005114752651348595 t http://qa.geonames.org/qa/kml/EC170704Turubamba.kml EC 18 Turubamba 170704 8478230 0.0005007076799805396 f http://qa.geonames.org/qa/kml/EC130223Montecristi.kml EC 14 Montecristi 130223 3654055 0.0004972578280049642 t http://qa.geonames.org/qa/kml/EC010109Cuenca_Bellavista.kml EC 02 Cuenca_Bellavista 010109 null 0.0004783346290219526 t http://qa.geonames.org/qa/kml/EC070115El Guabo.kml EC 08 El Guabo 070115 null 0.0003974796831079823 t http://qa.geonames.org/qa/kml/EC120610Valencia.kml EC 13 Valencia 120610 3650301 0.0003474920971126339 t http://qa.geonames.org/qa/kml/EC130602Calceta.kml EC 14 Calceta 130602 3659926 0.00034054327555037994 t http://qa.geonames.org/qa/kml/EC130409Bellavista.kml EC 14 Bellavista 130409 3660247 0.00033170388298009874 t http://qa.geonames.org/qa/kml/EC131203Tosagua.kml EC 14 Tosagua 131203 3650554 0.0003191259824527196 t http://qa.geonames.org/qa/kml/EC100301Cotacachi.kml EC 11 Cotacachi 100301 3658781 0.00031066222026402475 t http://qa.geonames.org/qa/kml/EC060102Riobamba.kml EC 06 Riobamba 060102 3652350 0.0001463739366573117 t http://qa.geonames.org/qa/kml/EC050202La Mana.kml EC 07 La Mana 050202 3655117 0.00012266825816988799 t http://qa.geonames.org/qa/kml/EC091901Daule.kml EC 10 Daule 091901 3658501 7.963644110923446e-05 t http://qa.geonames.org/qa/kml/EC100201Otavalo.kml EC 11 Otavalo 100201 3653693 7.653544622882497e-05 t http://qa.geonames.org/qa/kml/EC090205Guayaquil- Esteros.kml EC 10 Guayaquil- Esteros 090205 null 2.4010025347126276e-05 t