number of errors=83
number of warnings=0
Group=ckgGrpAirpIcao
select dmp_airport.geonameid,dmp_airport.countrycode,dmp_airport.name,iata,icao,cityid,geoname.name,geoname.countrycode,st_distance(ST_GeographyFromText('Point(' || dmp_airport.longlat[0] || ' ' || dmp_airport.longlat[1] || ')'),geography::geometry)::int as dist_m from dmp_airport,geoname where geoname.geonameid=cityid and dmp_airport.countrycode<>geoname.countrycode order by dist_m desc
geonameid countrycode name iata icao cityid name countrycode dist_m 8531990 CN Yongxing Island Airport null ZJYX 11496092 Hoàng Sa VN 44650 9034672 CL Laguna Redonda Airport null SCIO 6690180 El Chaltén AR 44482 6694769 FR Sallanches - Mont-Blanc XSN LFHZ 8533415 Les Moulins VS (Liddes) CH 41380 11263191 VE Río Riecito 1 null null 3668942 Santa Ana CO 36466 3208815 DE Altdorf-Wallburg null EDSW 3038008 Altorf FR 36396 7730162 BR Tiriós Airport null SBTS 3384728 Appikalo SR 35810 4988756 US Chippewa County International Airport CIU KCIU 6141439 Sault Ste. Marie CA 31235 1012558 ZA Cramond null null 933780 Five Dunes BW 29838 5557833 US Taku Lodge Seaplane Base TKL null 6170091 Tulsequah CA 27496 1012554 ZA Cramond East null null 933364 Melekgon BW 25907 11263163 VE Cinaruco null null 11250764 Las Margaritas CO 25731 8644117 ZW Mana Pools Airfield null null 908566 Mafuta ZM 21592 8533878 ZW Kotwa Airport null FVOT 1048085 Cochemane MZ 20169 8986814 CL Pampa Guanaco Airport DPB SCBI 3837123 San Justo AR 18265 11499717 IQ Ruwayshid null null 10682405 Ar Rīshah JO 17813 2424352 TD Yaligambo null null 6857270 Danzé CF 17024 5007638 US Rosedale Airport null null 6141439 Sault Ste. Marie CA 15541 5306615 US Nogales International Airport OLS KOLS 4004886 Nogales MX 14841 8298816 ZW Mahenye Airport MJW FVMH 1039580 Mavue MZ 12929 7731430 BR Guaíra Airport GGJ SSGY 3437148 Salto del Guairá PY 11899 11493732 CN Tuan Chang null null 1518716 Sumbe KZ 11670 3429494 AR Rio Iguazu null null 6318536 São Luiz BR 10836 8990099 CL Entrada Baker Airport null SCEB 3841845 Paso Rodolfo Roballos AR 10760 3353649 NA Pella Drift null null 3362964 Pella ZA 10656 8113526 US Faith Ranch Airport null null 3990824 Rancho Cerrito Prieta MX 10351 3429521 AR Rincon de Mercedes null null 3454868 Passo de São Marcos BR 9865 5688102 US Border International Airport null null 5949569 Estevan Airport CA 9599 5311941 US Rolle Airfield null null 3985604 San Luis Río Colorado MX 9464 283468 PS Jerusalem Airport JRS LLJR 7498240 West Jerusalem IL 9394 8093502 US Strom Private Airport null null 6125970 Roche Percee CA 9095 7730737 AF Darwaz Airport DAZ OADZ 1143928 Darvāz TJ 8677 11263096 VE Cucurucho null null 3685471 La Culebra CO 7866 11387536 US Stand Fast Airport null null 3993331 La Parrita MX 7822 3438704 PY Estable Santa Isabel null null 3429718 Puerto Valle AR 7800 5322074 US Yuma Number Four Airfield (historical) null null 3989850 Rancho Las Delicias MX 7645 8113019 US Indio-Faith Airport null null 3997465 Los Morales MX 7244 4721225 US Rachal Airport null null 3517862 San Ramon MX 6588 8644116 ZW Sapi Safari Airfield null null 916572 Jeki ZM 6398 5062487 US Weston Airport null null 5951270 Fallison CA 6394 8990105 BO Flor de Oro Airport null SLFO 3925096 Frutuoso BR 6386 7575033 BW Serondela Airstrip null null 877241 Kabulabula NA 6003 3437661 PY Northeast Hernandarias null null 3452718 Pôrto Mendes BR 5839 11483595 IL Nahal Hever null null 7892553 Khashm al Karm PS 5574 3437355 PY Puerto Paranambu null null 3429723 Puerto Segundo AR 5560 3432673 AR La Emilia null null 3437373 Puerto Marité PY 5486 5295073 US Forrest Airport null null 10224937 El Polo MX 4857 7668282 MA Dakhla Airport VIL GMMH 2463447 Dakhla EH 4562 8096242 US Horsley Airstrip (historical) null null 5946580 Edenburg CA 3973 5304152 US McDaniel Field (historical) null null 3979543 Libertador MX 3965 11514534 GT Pista de Aterrizaje Treinta y Ocho null null 3532705 Arroyo el Triunfo Primera Sección MX 3959 3436455 AR Ajncon del Salto null null 3438936 Colonia Salto PY 3927 11508251 GT Pista de Aterrizaje Noventa y Dos null null 3519586 San Carlos MX 3909 3437404 PY Puerto D M de Irala West null null 3436064 Bella Vista AR 3816 6297211 MA Hassan I Airport EUN GMML 2462881 Laayoune EH 3280 8784245 OM Dibba Airport BYB null 292231 Dibba Al-Fujairah AE 2923 3995170 MX Naco East null null 5284909 Bisbee Junction US 2862 8533006 UZ Kerben Airport null UAFE 7580258 Ondokon KG 2770 2711088 SE Gransjön null null 3162642 Askosberget NO 2615 413152 GB Kingsfield Airstrip null null 146110 Pýla CY 2501 3427229 AR Yurucua null null 3438625 Estancia Capurro PY 2482 4993364 US Franklin's Airport null null 6137309 Sailors Encampment CA 2203 4993344 US Franklin Landing Strip null null 6137309 Sailors Encampment CA 2187 799883 GE Vaziani null null 494768 Shertobitov RU 2134 876738 NA Wenela null null 902259 Nalisa ZM 2128 11500099 BY Dobryanka West null null 708402 Hornostaivka UA 2086 3218016 HR Bihac null LQBI 3212877 Papari BA 2065 6296503 BE Weelde Military null EBWE 2759552 Baarle-Nassau-grens NL 1931 3982838 MX Sonoyta null null 5303321 Lukeville US 1766 796696 KZ Turgay null null 480312 Turgay RU 1725 5692069 US Sherwood Municipal Airport null null 5948059 Elmore CA 1548 5462685 US Columbus Heliport null null 3991350 Puerto Palomas MX 1536 3526088 MX Lacantun null null 11579158 Cablecarril GT 1486 9034548 BR Santa Teresita Airport null SLSE 3444654 Marco Porvenir BO 1452 11263161 VE Santa Rosa Oeste null null 3669058 San Rafael CO 1415 11457212 TJ Ishkashim null null 1120871 Zargarān AF 1384 6324585 CN Kai Tak Airport null null 8504415 Kowloon Bay HK 1317 283507 PS Janīn null null 294142 Muqeibila IL 1263 5522985 US Heath Canyon Airport null null 4001598 La Linda MX 1215 3206767 DE Kirchdorf null null 2781721 Blankenbach AT 1199 8521570 TJ Khorog Airport null UTOD 1124971 Shiwa AF 1189 11506448 KR H 128 Heliport null null 1872770 Palsal-li KP 1057 1089187 MZ Zumbo null null 909887 Luangwa ZM 901 9671466 US Moose City Airport null null 5954263 Flathead CA 894