Open main menu

User talk:Mahir256

For past messages, see the archive.

Airports in India

Hi there, I suppose you are keen on Indian airports. If you could check this list

PREFIX wdno: <>
PREFIX rdf: <>
SELECT DISTINCT ?airport ?airportLabel (SAMPLE(?coord) AS ?coord) ?ICAO ?IATA  WHERE {
  ?airport (wdt:P31/wdt:P279*) wd:Q62447.
  ?airport wdt:P17 wd:Q668.
  MINUS { ?airport wdt:P576 _:b2. }
  MINUS { ?airport wdt:P582 _:b3. }
  MINUS { ?airport (wdt:P31/wdt:P279*) wd:Q1311670. }
  MINUS { ?airport (wdt:P31/wdt:P279*) wd:Q7373622. }
  MINUS { ?airport (wdt:P31/wdt:P279*) wd:Q502074. }
  MINUS { ?airport (wdt:P31/wdt:P279*) wd:Q2265915. }
  MINUS { ?airport (wdt:P31/wdt:P279*) wd:Q44665966. }
  MINUS { ?airport (wdt:P31/wdt:P279*) wd:Q782667. }
  MINUS { ?airport rdf:type wdno:P17. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en,fr,[AUTO_LANGUAGE]". }
  OPTIONAL { ?airport wdt:P625 ?coord. }
  OPTIONAL { ?airport wdt:P239 ?ICAO. }
  OPTIONAL { ?airport wdt:P238 ?IATA. }
GROUP BY ?airport ?airportLabel ?ICAO ?IATA
ORDER BY ?coord

Try it! and make sure there is no duplicates or defuncts airports on this+if all have their correct IATA and ICAO codes ?

If you don't have time, no problem. Thank you ! Bouzinac (talk) 21:12, 3 February 2019 (UTC)

Thanks a bunch

  The Wikidata Barnstar
Thank you for your work on the duplicate items!

Bukhari (Talk!) 08:46, 7 February 2019 (UTC)

Return to the user page of "Mahir256".