distance between toponym (airport) and weatherstation with same icao should not be too large

number of errors=8
number of warnings=0
Group=ckgGrpAirpIcao

select dmp_airport.geonameid,dmp_airport.name as airportname,weatherstation.name as weathername,dmp_airport.iata,dmp_airport.icao,weatherstation.longlat<->dmp_airport.longlat as dist,numberofobservations from weatherstation,dmp_airport where weatherstation.icao=dmp_airport.icao and weatherstation.longlat<->dmp_airport.longlat>1 order by 6 desc

geonameid	airportname	weathername	iata	icao	dist	numberofobservations	
8849441	Lakes Entrance Airfield	Great Lakes Airport	null	YGRL	250.42055389875318	null	
8533074	Yirol Airport	Likiep Airfield	null	HSYL	138.83206704635893	null	
11398250	Kang Airport	Kang Airport	null	FBKG	121.9793236176386	null	
12402419	Planalto Serrano Regional Airport	Carutapera Airport	EEA	SNCP	26.75689398679338	null	
8531867	U.S. Naval Air Station Cubi Poin	General Santos International Airport	null	RPMB	10.005135157610264	null	
8531888	Sawan Airport	Sahiwal Airport	RZS	OPSW	6.046124808589921	null	
3681167	Hacaritama Airport	Aguaclara Airport	HAY	SKAG	3.5482154375810615	null	
11711352	Mollis	EuroAirport Basel–Mulhouse–Freiburg	null	LSZM	1.6176825477592935	null