User talk:Mahir256

From Wikidata
Jump to navigation Jump to search

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: <http://www.wikidata.org/prop/novalue/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
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

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

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

171.33.192.82

Why did you rangeblock rather than just block the individual IP? No other addresses in the range have vandalized for over 8 months.--Jasper Deng (talk) 09:50, 25 February 2019 (UTC)