number of errors=15
number of warnings=44
Group=ckgGrpAirpIcao
select dmp_airport.geonameid,dmp_airport.name,iata,cityid,city,geoname.geonameid,geoname.name,dmp_airport.longlat<->geoname.longlat as distance,case when dmp_airport.longlat<->geoname.longlat>1 then 'ERR' else 'WRN' end as ERRWRN from dmp_airport,geoname,alternatename where featureclass='P' and isActive and geoname.geonameid=alternatename.geonameid and alternatename.namelocale='iata' and iata=alternatename.name and cityid<>alternatename.geonameid and dmp_airport.longlat<->geoname.longlat>0.3 and not coalesce(isformername,false) order by dmp_airport.longlat<->geoname.longlat desc
geonameid name iata cityid city geonameid name distance errwrn 6300309 Hyakuri Ab IBR 2111515 Ogawa 1862033 Ibaraki 5.0356013807054145 ERR 8260839 Kuri Airport KUQ 2133105 Kupiano 2092984 Kuri 5.030171145177644 ERR 7668480 Canaima Airport CAJ 3644660 Curatabaca 3795771 Canaima 4.40899678777198 ERR 8555577 Samberigi Airport SWE 2087301 Samberigi Mission 2086499 Siwea 3.697831628237961 ERR 6297040 Sainte-Marie Aerodrome SMS 1060169 Marofototra 1057215 Sainte-Marie 3.0067293786092235 ERR 6300328 Rebun Island RBJ 2130004 Horodomari 2128423 Rebun 2.9141556916229705 ERR 6299754 Cengiz Topel Naval Air Station KCO 738814 Tepetarla 306970 Kocaeli 2.8012212309300026 ERR 7730864 Boalang Airport BJG 1648343 Balaang 1648340 Bolaang 2.792566231873474 ERR 6300055 Arak Airport AJK 122983 Mūtābād 7431358 Arak 2.5702702248335703 ERR 6300720 Pastaza / Rio Amazonas PTZ 3651138 Shell 3827899 Pastaza 1.7690486910884173 ERR 8260887 Pontes E Lacerda LCB 3474495 Nova Alvorada 3453060 Pontes e Lacerda 1.5413283143532923 ERR 7731194 Kratie Airport KTI 1830564 Kratié 11459959 Ta Khmau 1.521764638645284 ERR 6296360 Bou Saada Airport BUJ 2480991 Sidi Belkassem 2502384 Bou Saada 1.4690385553228325 ERR 2685748 Åre Östersund Airport OSD 2685750 Östersund 9114206 Åre 1.438855248811734 ERR 7668300 Galegu Airport DNX 366604 Suwaydā’ 11467834 Dinder 1.1806286974124425 ERR 8261061 Manumu Airport UUU 2097793 Eia 2091502 Manumu 0.9884762445784919 WRN 8261024 Matthews Ridge MWJ 3661479 Amamuri Village 3661152 Matthews Ridge 0.9769667432466681 WRN 7730411 Moro Airport MXH 2094132 Kerisa 2090473 Moro 0.932951763766026 WRN 8986814 Pampa Guanaco Airport DPB 3837123 San Justo 3897148 Cámeron 0.9314475352374869 WRN 7731359 Ord River Airport ODR 8607689 New Ord River 2064077 Ord River 0.7395380158453169 WRN 8987078 Coposa Airport CPP 3896075 Caya 3876353 Pica 0.697408209903637 WRN 7730453 Chisasibi Airport YKU 5921588 Chisasibi 5921589 Chisasibi 0.6002395399212951 WRN 7730300 Qamdo Bangda Airport BPX 7898226 Bangda 1280281 Qamdo 0.581220683006452 WRN 11493676 Yinchuan Helanshan Airport YEH 10188872 Quangou 1785885 Yueyahu 0.5520475263054782 WRN 6300391 Fukushima Airport FKS 2110959 Sukagawa 2112923 Fukushima 0.5238068039668796 WRN 11493876 Hengyang Nanyue Airport HNY 1808370 Hengyang 1799586 Nanyue 0.5237375802823409 WRN 6296804 Sundsvall-Timrå Airport SDL 2670781 Sundsvall/Harnosand 2707684 Härnösand 0.5048694159662438 WRN 6676732 Maku International Airport IMQ 14005 Qarah Jolū 125205 Maku 0.4750669983276067 WRN 6940270 Robin Hood Airport Doncaster Sheffield DSA 2651123 Doncaster 2638077 Sheffield 0.47097093699479214 WRN 10630462 Qinhuangdao Beidaihe Airport BPE 1797595 Qinhuangdao 9937668 Beidaihe 0.4587946752088593 WRN 6299758 Tekirdağ Çorlu Airport TEQ 748893 Çorlu 738927 Tekirdağ 0.4383840480172635 WRN 6694425 Calais-Dunkerque Airport CQF 3029162 Calais/Dunkerque 3020686 Dunkerque 0.4274828973723846 WRN 2681745 Scandinavian Mountains Airport SCR 2681744 Rörbäcksnäs 2680615 Sälen 0.4254544589434809 WRN 11493830 Xinyang Minggang Airport XAI 10423676 Shenhe 1788534 Xinyang 0.418261882963528 WRN 6300795 Johan Adolf Pengel International Airport PBM 3382670 Zanderij 3383330 Paramaribo 0.4140790106720708 WRN 6296538 Halli Airport KEV 659300 Halli 656083 Jämsä 0.4035020102228331 WRN 5835617 Powell Municipal Airport POY 5835606 Powell 5831176 Lovell 0.39930530073729326 WRN 6296527 Karlsruhe/Baden-Baden Airport FKB 2953504 Baden-Baden 2892794 Karlsruhe 0.3972941526677684 WRN 8521371 Kaili Huangping Airport KJH 10044203 Guanzhong 1804866 Kaili 0.3882647743923911 WRN 8260766 Bole Alashankou Airport BPL 8521718 Bole 8521719 Alashankou 0.38488385919995394 WRN 6296784 Szczecin-Goleniów Airport SZZ 3098966 Goleniów 3083829 Szczecin 0.38235959982478 WRN 5200920 Mid-State Airport PSB 5179799 Bellefonte 5184541 Clearfield 0.3820090617328982 WRN 6299341 Murcia–San Javier Airport MJV 2511366 San Javier 2513416 Murcia 0.3819380698097531 WRN 8644081 Hechi Jin Cheng Jiang Airport HCJ 9924841 Nahaitun 1808758 Hechi 0.36042940903872944 WRN 7910201 Jinggangshan Airport JGS 1805667 Ji An 1806445 Ji’an 0.3596815858987538 WRN 3080176 Zielona Gora Airport IEG 3104002 Babimost 3080165 Zielona Góra 0.35575457624315565 WRN 8260946 Zunyi Xinzhou Airport ZYI 1783621 Zunyi 1788455 Xinzhou 0.35130553410843773 WRN 8449504 Kütahya Zafer Airport KZR 305206 Kuyucak 305268 Kütahya 0.34725518663891763 WRN 6300398 Odate–Noshiro Airport ONJ 2128787 Ōdate 2128867 Noshiro 0.3444268326147091 WRN 6300359 Chūbu Centrair International Airport NGO 1850185 Tokoname 1856057 Nagoya 0.3384793960864448 WRN 6296734 Harstad/Narvik Airport, Evenes EVE 6355227 Evenes 3153823 Harstad 0.3359884025736714 WRN 7910384 Zhijiang Airport HJJ 1784525 Huai hua 1807689 Huaihua 0.32892288690675314 WRN 11203813 Giza Sphinx International Airport SPX 7802749 El-Sheikh Zayed City 360995 Giza 0.32890825933229645 WRN 8298754 Yangzhou Taizhou Airport YTY 8270499 Shenzha 1787227 Yangzhou 0.32817499070119033 WRN 4442170 Poplarville-Pearl River County Airport PCU 4442164 Picayune 4440975 Picayune 0.31656209043801026 WRN 8435701 Tho Xuan Airport THD 1584582 Cư Điện 1566166 Thanh Hóa 0.31505420846152954 WRN 10234006 Ordu - Giresun Airport OGU 747257 Eskisayaca 746881 Giresun 0.3108552943991739 WRN 8505071 Xuzhou Guanyin Airport XUZ 10630005 Xuzhou 10630003 Xuzhou 0.3082029408540185 WRN 11102730 Xinzhou Wutaishan Airport WUT 11455289 Wuweizhuang 1788450 Xinzhou 0.3014936269608368 WRN