number of errors=0
number of warnings=0
Group=ckgGrpAirpIcao
select featureclass,alternatename.name,alternatename.namelocale from alternatename,geoname where featureclass='S' and geoname.geonameid=alternatename.geonameid and alternatename.namelocale in ('faac','icao','iata') and (isformername is null or not isformername) and alternatename.name<>'EDDB' and geoname.geonameid not in (3208733,8335457, 4464368,4487042, 2814545, 2150784, 508101, 1730737, 2661604,2991214, 4142290,4141903, 2670781,2707684, 8521565,8521722, 5333594,5862653,5852449 ,951450,3023065, 5859733,8521756,8237903,8238216,8555580,8556011,8556013,8556007,8556018,8556002,8643447,8237288,10793776,8236300,11186272,2065587,8238041,8520883,11524257 ,2062144,8617216,8352922,2060753,2073912, 2171623,2177638,2070508,8643446,2163479,2164499,2059276,2074881,2070818,2159518,2178349,2146680,2069336,2064599,8788891,2060893,2067121,2077457,2063835, 2148593, 7266445,7267489,7266838,7267782,7266856, 6301615, 5893837, 6301745) and featurecode not in ('AIRQ','CMP','FRM','INSM','RSTN','HMSD','MN','BUSTN') group by featureclass,alternatename.name,alternatename.namelocale having count(*)>1
Berlin EDDB used for old and new airport (set old to historic later) RDU airport serves two cities Raleigh and Durham. 4464368,4487042 RBM Straubing Wallmühle Airport serves Straubing and Wallmühle 2814545 EAP serves Basel 2661604 and Mulhouse 2991214 DOV = Dover-Cheswold 4142290,4141903 SDL = Sundsvall/Harnosand 2670781,2707684 SVT = city is camp 8521565 EYS = city is a camp 8521722 CSL = city is a camp 5333594 GBH = city is a camp 5862653 BSF = city is a camp 5852449 NTY = city is a resort 951450 CVF = city is a resort 3023065 KCR = city is a mine 5859733 OSO = city is a mine 8521756 NIF = city is a mine 8237903 YNN = city is a mine 8238216 KFE = city is a mine 8555580 WLP = city is a mine 8556011 WRN = city is a mine 8556013 OCM = city is a mine 8556007 GPD = city is a mine 8556018 CJF = city is a mine 8556002 ERQ = city is a mine 8643447 GYL = city is a mine 8237288 CKW = city is a mine 10793776 GTS = city is a mine 8236300 YOA = city is a mine 11186272 WME = city is a mine 2065587 SGP = city is a mine 8238041 PXH = city is a mine 8520883 YNX = city is a mine 11524257 RHL = city is a homestead 2062144 OXO = city is a homestead 8617216 KQR = city is a homestead 8352922 GTS = city is a homestead 2070508 ERQ = city is a homestead 8643446 COY = city is a homestead 2073912 GBW = city is a homestead 2060753 LLG = city is a homestead 2171623 AAB = city is a homestead 2177638 HIG = city is a homestead 2163479 GVP = city is a homestead 2164499 WLA = city is a homestead 2059276 CRY = city is homestead 2074881 GLG = city is homestead 2070818 ABG = city is homestead 2178349 LTV = city is homestead 2159518 TYG = city is homestead 2146680 IVW = city is homestead 2069336 NKB = city is homestead 2064599 DRY = city is homestead 8788891 SSK = city is homestead 2060893 MQA = city is homestead 2067121 AWP = city is homestead 2077457 PRD = city is homestead 2063835 KSV = city is a farm 2148593 HFF = city is a military installation 7266445 FRI = city is a military installation 7267489 CZF = city is a military installation 7266838 APH = city is a military installation 7267782 SVW = city is a military installation 7266856 YAR = city is a dam 5893837
featureclass name namelocale