GeoKnow / LinkedGeoData

OpenStreetMap for the Semantic Web
http://linkedgeodata.org
GNU General Public License v3.0
133 stars 32 forks source link

ICAO code incorrectly specified as IATA code #25

Open KonradHoeffner opened 8 years ago

KonradHoeffner commented 8 years ago

Patiala Airport is listed with the IATA code VIPL which is actually its ICAO code, see http://linkedgeodata.org/triplify/node412253158

In general, there are more than 200 airports with IATA codes that do not follow the required trigram format. I propose to only use IATA codes that are letter trigrams.

PREFIX dbo: <http://dbpedia.org/ontology/>
PREFIX ocg: <http://www.opengis.net/ont/geosparql#>
PREFIX dbp: <http://dbpedia.org/property/>
PREFIX lgdo: <http://linkedgeodata.org/ontology/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX meta: <http://linkedgeodata.org/meta/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX geom: <http://geovocab.org/geometry#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX dc: <http://purl.org/dc/terms/>
SELECT ?y ?v0
WHERE {
?y rdf:type lgdo:Airport .
?y lgdo:iata ?iata2 .
filter(!regex(?iata2,"^[A-Z]{3}$")).
?y rdf:type meta:Node .
?y lgdo:iata ?v0 .
}