query-a323debd39b7352b487eeda70236e6d3

rq turtle/ttl

Query to return latitudes and longitudes for places in Paris

SELECT (COUNT(?a) AS ?count) (MIN(?lat) AS ?min_lat) (MIN(?long) AS ?min_long) (MAX(?lat) AS ?max_lat) (MAX(?long) AS ?max_long) WHERE { ?a wdt:P131+ wd:Q90 . # administrative territorial entity = Paris

?a p:P625 ?statement . # coordinate-location statement ?statement psv:P625 ?coordinate_node . ?coordinate_node wikibase:geoLatitude ?lat . ?coordinate_node wikibase:geoLongitude ?long .

{ SELECT ?a (COUNT(?a) AS ?count_stmt) WHERE { ?a wdt:P131+ wd:Q90 . ?a p:P625 ?statement } GROUP BY ?a HAVING (?count_stmt < 2) }

SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . } }

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#>
# Query to return latitudes and longitudes for places in Paris

SELECT (COUNT(?a) AS ?count) (MIN(?lat) AS ?min_lat) (MIN(?long) AS ?min_long) (MAX(?lat) AS ?max_lat) (MAX(?long) AS ?max_long)  WHERE {
  ?a wdt:P131+ wd:Q90 .  # administrative territorial entity = Paris

  ?a p:P625 ?statement . # coordinate-location statement
  ?statement psv:P625 ?coordinate_node .
  ?coordinate_node wikibase:geoLatitude ?lat .
  ?coordinate_node wikibase:geoLongitude ?long .

  {
    SELECT ?a (COUNT(?a) AS ?count_stmt) WHERE {
      ?a wdt:P131+ wd:Q90 .
      ?a p:P625 ?statement
    } GROUP BY ?a HAVING (?count_stmt < 2)
  }

  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" .
  }
}

Query found at

• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries