query-6a0757b0bc5c969a204d22f01a7668b9

rq turtle/ttl

Location of Lithuanian cities with a population count greater than 10.000

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#filter:Location of Lithuanian cities with a population count greater than 10.000
#defaultView:Map
SELECT DISTINCT ?city ?cityLabel ?population ?location ?lon ?lat WHERE {
  # get cities (or classes based on city) in Lithuania
  ?city wdt:P31/wdt:P279* wd:Q515 ;
        wdt:P17 wd:Q37 .

  # get population and location of the city
  ?city wdt:P1082 ?population ;
        wdt:P625 ?location .

  # we're only interested in cities with a population count > 50.000
  FILTER (abs(?population) > 10000)

  # extract lat and lon
  ?city p:P625 ?coordinate.
  ?coordinate psv:P625 ?coordinate_node.
  ?coordinate_node wikibase:geoLongitude ?lon.
  ?coordinate_node wikibase:geoLatitude ?lat. 

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}

Query found at

• https://www.wikidata.org/wiki/User:Zygimantus/Queries