2025-06-28     2025-06-29     2025-06-30

icao code format

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

select geonameid,name,namelocale from alternatename where namelocale='icao' and (not name ~ '[0-9A-Z]{4}' or length(name)<>4)

geonameid	name	namelocale