number of errors=28
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 13354015 SR Eduard Alexander Gummels Airport SMEG AIRP 7668479 BR Ponta Grossa Airport SBPG AIRP 7730328 PH General Santos International Airport RPMR AIRP 7731137 AU Shute Harbour Airport YSHR AIRP 8504708 NZ Fox Glacier Heliport NZFH AIRH 6301263 ID Iskandar Airport WAOI AIRP 454769 LV Jurmala EVTA AIRF 12173190 IE Ballyboughal Airfield EIBA AIRF 4997371 US Jack Barstow Airport KIKW AIRP 8260875 MM Naypyidaw Airport VYNT AIRP 8443039 VN Cam Ly Airport VVCL AIRF 765872 PL Lublin Airport EPLB AIRP 8531915 ID Malinau Robert Atty Bessing Airport WRLM AIRP 8298688 BR Marcelo Pires Halzhausen State Airport SBAS AIRP 7731153 ID Kao Kuabang Airport WAMK AIRP 7730747 OM Marmul Airport OONR AIRP 7668338 RS Ponikve Airport LYUZ AIRP 6299466 FR EuroAirport Basel–Mulhouse–Freiburg LFSB AIRP 8521332 NO Førde Airport, Bringeland ENBL AIRP 8299403 ID Sangia Nibandera Airport WAWP AIRP 6301315 AU Laverton Aerodrome YMPC STNM 12750420 ID Singkawang Airport WIOD AIRP 6301231 ID H.A.S. Hanandjoeddin Airport WIOD AIRP 7730862 CN Beihai Fucheng Airport ZGBH AIRP 8260997 ES Castellón–Costa Azahar Airport LECH AIRP 5787941 US Bowers Field KELN AIRP 11457232 UZ Karshi Airport UTSK AIRP 13308827 AL Vlora International Airport LAVL AIRP