query-6e2b1a5303a67303c5c977b604580b89

TODO

Use at

https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT ?item (SAMPLE(?coordinates_) AS ?coordinates) WHERE {
  ?item wdt:P31/wdt:P279* wd:Q15324;
        wdt:P17 wd:Q34.
  OPTIONAL { ?item wdt:P625 ?coordinates_. } # add coordinates for convenience
  # leaving out the label service because there are a lot of results and the label service makes it significantly slower
}
GROUP BY ?item # in case items have multiple coordinates

Query found at

https://www.wikidata.org/wiki/User:TweetsFactsAndQueries/Wikimedia_Hackathon_2021_Data_Challenge/01.Create_a_list_of_all_the_water_bodies(sea,_lake_or_river)_in_Sweden.

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?coordinates") v2("?coordinates_"):::projected v1("?item"):::projected a1((" ")) c5(["wd:Q34"]):::iri c3(["wd:Q15324"]):::iri v1 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c3 v1 --"wdt:P17"--> c5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P625".-> v2 end bind1[/"sample(?coordinates_)"/] v2 --o bind1 bind1 --as--o v3