number of errors=187
number of warnings=0
Group=ckgGrpAirpIcao
select geoname.geonameid,countrycode,geoname.name,alternatename.name,featurecode from alternatename,geoname where alternatename.namelocale='icao' and geoname.geonameid=alternatename.geonameid and featureclass='S' and alternatename.name not in (select icao from weatherstation) and featurecode<>'AIRQ' and alternatename.name not in ('KNUU')
insert into weatherstation (icao,name,countrycode,longlat,geography,iata,geonameid,admincode1) select icao,name,countrycode,longlat,st_GeomFromText('Point(' || longlat[0] || ' ' || longlat[1] || ')')::geography,iata,geonameid,admincode1 from dmp_airport where icao is not null and icao not in (select icao from weatherstation);
geonameid countrycode name name featurecode 372536 SD Khartoum International Airport HSSK AIRP 6300140 YE Mukeiras Airport OYMS AIRP 6300661 BR Pedro Otacílio Figueiredo Airport SBVC AIRP 6301335 AU Meekatharra Airport YMEK AIRP 6301244 ID Sultan Thaha Airport WIJJ AIRP 6301179 ID Haluoleo Airport WAWW AIRP 6301207 ID Rendani Airport WAUU AIRP 6301198 ID Syukuran Aminuddin Amir Airport WAFW AIRP 6301325 AU Ceduna Airport YCDU AIRP 6301225 ID Adisucipto International Airport WAHH AIRP 6301282 ID Brangbiji Airport WADS AIRP 6301277 ID Juwata International Airport WAQQ AIRP 4567993 PR José Aponte de la Torre Airport TJRV AIRP 6255013 AU Illawarra Regional Airport YSHL AIRP 7668757 AU Aeropelican Airport YLMQ AIRP 7668770 AU Snake Bay Airport YSNK AIRP 7730189 RU Cherepovets Airport ULWC AIRP 6301263 ID Iskandar Airport WAOI AIRP 12173190 IE Ballyboughal Airfield EIBA AIRF 8504985 BR Barreirinhas Airport SSRS AIRP 8238744 GY Eugene F. Correira International Airport SYEC AIRP 7730747 OM Marmul Airport OONR AIRP 6301315 AU Laverton Aerodrome YMPC STNM 11238187 CN Chengde Puning Airport ZBCD AIRP 8693254 CN Liupanshui Yue Zhao Airport ZUPS AIRP 13157413 PE Pias Airport SPIS AIRP 13157414 IN Maa Mahamaya Airport VEAP AIRP 6693764 AU Yarra Bank Heliport YBPK AIRH 8990016 BO Chimore Airport SLHI AIRP 7668702 AU Coonamble Airport YCNM AIRP 7668747 AU Murray Island Airport YMAE AIRP 13192261 PG Josephstaal Airport AYJS AIRF 13192263 PG Kibuli Airstrip AYLI AIRF 13192262 PG Komaio Airport AYOQ AIRF 13192268 PG Kasonombe Airport AYNM AIRF 13192270 PG Kosipe Airport AYOP AIRF 13192275 PG Lowai Airport AYLO AIRF 13192281 PG Malam Airport AYMQ AIRF 13192300 PG Sialum Airport AYQS AIRF 13192304 PG Timbunke Airport AYTV AIRF 13192307 PG Tinboli Airport AYYL AIRF 13192309 KI Washington Island Airstrip PLWN AIRF 13192310 PG Buin Airport AYUI AIRF 13192264 ID Keluang Airport WIPV AIRF 13192266 PG Kondobol Airport AYDL AIRF 13192267 PG Kol Airport AYOL AIRF 13192284 PG Namudi Airport AYNJ AIRF 13192291 PG Ononge Airport AYQQ AIRF 8849497 AU Mount Holland Aerodrome YMHL AIRF 13192327 PG Wasua Airport AYIW AIRF 13192330 PG Zenag Airport AYZA AIRF 6299819 HN Soto Cano Air Base MHPR AIRB 8617183 CN Alxa Left Banner Airport ZBAL AIRP 13192290 PG Olsobip Airport AYOV AIRF 13192292 PG Ossima Airport AYZS AIRF 13192294 PG Pangia Airport AYPG AIRF 3493082 DO San Juan de La Maguana MDSA AIRF 13192301 SC Sehulea Airport AYSL AIRF 7668580 IN Swami Vivekananda Airport VERP AIRP 12440520 SA Red Sea International Airport OERS AIRP 7910191 CN Tengchong Airport ZPTC AIRP 12022101 CN Tumxuk Tangwangcheng Airport ZWTS AIRP 11127694 CN Ulanqab Airport ZBUC AIRP 8260748 OM Mukhaizna Airport OOMK AIRP 11608476 CN Shaoyang Wugang Airport ZGSY AIRP 11493830 CN Xinyang Minggang Airport ZHXY AIRP 6298757 US Naval Air Station Brunswick KBXM AIRP 3099231 PL Gliwice EPGL AIRF 11154613 CN Shangrao Sanqingshan Airport ZSSR AIRP 6301228 ID Achmad Yani International Airport WAHS AIRP 8643880 ET Semera Airport HASM AIRP 11608591 CN Zunyi Maotai Airport ZUMT AIRP 7910204 CN Wuhai Airport ZBUH AIRP 8093485 US Williston Basin International Airport KXWA AIRP 10943302 ID Yahukimo Nop Goliath Airport WAVD AIRP 3387297 BR Boa Vista Heliport SNGL AIRH 6297022 ZM Ndola Airport FLSK AIRP 3407379 BR Canoa Quebrada Dragão do Mar Regional Airport SBAC AIRP 3714958 PA Ailigandi Airport MPAI AIRP 13192033 KH Techo International Airport VDTI AIRP 13192036 ID Kuala Kurun Airport WAGA AIRP 13192155 PG Bodinumu Airport AYBD AIRF 13192326 PG Wanuma Airport AYWH AIRF 13192328 PG Biniguni Airport AYBZ AIRF 13192250 PG Gewoia Airport AYGC AIRF 13192251 AU Grenfell Airport YGNF AIRF 13192297 PG Suabi Airport AYSA AIRF 13192255 PG Komako Airport AYOK AIRF 13192256 AU Hope Vale Airport YHPV AIRF 13192273 PG Lengbati Airport AYLT AIRF 13192276 PG Masa Airport AYSX AIRF 13192279 PG Malalaua Airport AYMP AIRF 13192280 PG Mapua(Mabua) Airport AYMZ AIRF 13192283 PG Nambaiyufa Airport AYNY AIRF 13192285 PG Nomane Airport AYNO AIRF 13192254 PG Habi Airport AYHB AIRF 13192258 PG Indagen Airport AYID AIRF 13192259 PG Imonda Airport AYIO AIRF 13192271 PG Kaintiba Airport AYKT AIRF 13192282 PG Menyamya Airport AYMC AIRF 1058533 MG Moramanga FMFE AIRF 13192293 PG Pangoa Airport AYPC AIRF 13192298 VE Macagua Airport SVMU AIRF 13192303 PE Shiringayoc/Hacienda Hda Mejia Airport SPOV AIRF 13192305 PG Tarabo Airport AYTR AIRF 13192306 PG Torembi Airport AYVM AIRF 13192299 PG Satwag Airport AYSW AIRF 13192302 PG Sauren Airport AYSV AIRF 13192311 PG Upiara Airport AYUR AIRF 13192312 PG Uvol Airport AYUZ AIRF 13192315 PG Weam Airport AYXW AIRF 7668571 IN Hubli Airport VOHB AIRP 11669752 CN Shache Yeerqiang Airport ZWSC AIRP 7731467 BR Rondonópolis Airport SBRD AIRP 11203813 EG Giza Sphinx International Airport HESX AIRP 3581932 BZ Belize City Municipal Airport MZBE AIRP 5875127 US Stebbins Airport KWBB AIRP 8521333 CA Fort MacKay/Firebag Aerodrome CYFI AIRP 12110894 CN Yulin Fumian Airport ZGYL AIRP 7731491 ET Shire Inda Selassie Airport HASR AIRP 4264881 US Indy South Greenwood Airport KHFY AIRP 7730812 IN Aizawl Lengpui Airport VELP AIRP 11951798 ID Muara Bongo Airport WIJB AIRP 7730330 BZ Caye Caulker Airport MZCK AIRP 3582432 BZ Cay Chapel Airstrip MZCP AIRP 7910483 BZ Corozal Airport MZCZ AIRP 11524617 MV Dhaalu Atoll Airport VRMU AIRP 7730322 BZ Dangriga Airport MZPB AIRP 7731006 PH El Nido Airport RPEN AIRP 12110485 AU Gruyere Mine Airport YGRM AIRP 7910488 EG Sohag International Airport HESG AIRP 8260769 CN Shaoguan Guitou Airport ZGSG AIRP 11185240 CN Huolinhe Airport ZBHZ AIRP 3581743 BZ Independence Airport MZSV AIRP 6301035 IN Belgaum Airport VOBM AIRP 11468550 BR Jericoacoara Airport SBJE AIRP 11288239 CN Lancang Jingmai Airport ZPJM AIRP 7731146 BR Ji-Paraná Airport SBJI AIRP 5863329 US Grayling Airport PAGX AIRP 11778487 KE Musiara Airport HKMZ AIRF 7458752 ID Tampa Padang Airport WAFJ AIRF 11778488 ID Morowali Airport WAFO AIRP 1105968 ZW Bulawayo Airport FJVN AIRP 7668667 ID Kalimaru Airport WAQT AIRP 11995099 CN Bazhong Enyang Airport ZUBZ AIRP 8260841 PG Lablab AYLB AIRP 6300715 EC Catamayo / Camilo Ponce Enriquez SECA AIRP 12420788 CO Aeropuerto Morelia SKMO AIRP 12402360 AU Gudai-Darri Airstrip YKDD AIRP 8520857 ID Minangkabau International Airport WIEE AIRP 7910454 BZ Placencia Airport MZPL AIRP 3581397 BZ Punta Gorda Airstrip MZPG AIRF 7668437 BR Tancredo Thomas de Faria Airport SSGG AIRP 2681745 SE Scandinavian Mountains Airport ESKS AIRP 7668585 IN Jagdalpur Airport VEJR AIRP 7668568 IN Diu Airport VADU AIRP 8260842 ID Oesman Sadik Airport WAEL AIRP 7910484 BR Bauru-Arealva Airport SBAE AIRP 6297348 SS Juba Airport HJJJ AIRP 8593872 CN Lüliang Airport ZBLL AIRP 7730108 CR Tortuguero Airport MRBT AIRP 6301093 IN Lal Bahadur Shastri Airport VEBN AIRP 7668597 IN Visakhapatnam Airport VOVZ AIRP 11351974 CN Songyuan Chaganhu Airport ZYSQ AIRP 11785347 CN Yueyang Sanhe Airport ZGYY AIRP 10943299 CN Ninglang Luguhu Airport ZPNL AIRP 8643364 MM Monywa Airport VYMY AIRP 11101973 KE Vipingo Airport HKVG AIRP 13192609 DE Dinslaken/Schwarze Heide Airport EDLD AIRF 13192653 ID Karel Sadsuitubun Airport WAPF AIRP 13192741 AU Fortnum Private Airfield YFOR AIRF 7731372 BR Presidente João Batista Figueiredo Airport SBSI AIRP 7668444 BR Telêmaco Borba Airport SSVL AIRP 8468841 RU Talakan Airport UECT AIRP 7336574 ID Tambolaka Airport WATK AIRF 8260755 LA Boun Neua Airport VLFL AIRP 7731403 ID Tjilik Riwut Airport WAGG AIRP 11237564 CN Jiansanjiang Airport ZYJS AIRP 7731017 ID Ewer Airport WAKG AIRP 3701862 PA Scarlett Martinez International Airport MPSM AIRP 3387787 BR Serra Talhada/Santa Magalhaes Airport SNHS AIRP 7668665 ID Tanjung Harapan Airport WAGD AIRP 11128430 CN Wudalianchi Dedu Airport ZYDU AIRP 13192617 IN Halwara International Airport VIHX AIRP 3209147 DE Bautzen Litten EDAB AIRF 12110449 AU Wodgina Airport YWDC AIRP 6301196 ID Kasiguncu Airport WAFP AIRP