query-964858b7a97547b53b4b434da776c3e3

rq turtle/ttl

The question did not specify “metropolitan France” so I chose not to limit the results to that, which means the map is very zoomed out by default.

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 bd: <http://www.bigdata.com/rdf#>
#defaultView:Map{"hide": ["?layer", "?coordinates]}
SELECT ?river ?riverLabel ?layer (SAMPLE(?coordinates_) AS ?coordinates) WHERE {
  ?river wdt:P17 wd:Q142;
         # /wdt:P279* wd:Q355304; # too expensive – instead:
         wdt:P31 wd:Q4022; # after all, the question was “rivers” not “watercourses” ;)
         wdt:P625 ?coordinates_. # this misses rivers that have no coordinate location, but even if we made this optional they wouldn’t be shown on the map
  BIND(IF(EXISTS { ?river wdt:P403 wd:Q4918. }, # change P403 to P403+ to also highlight tributaries (rivers that *eventually* end in the Mediterranean)
          "ends in the Mediterranean"@en,
          "does not end in the Mediterranean"@en)
       AS ?layer)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,en". }
}
GROUP BY ?river ?riverLabel ?layer
ORDER BY ASC(?layer) # try to make the map draw the “ends in…” dots above the “does not end in…” ones, so they’re more visible

Query found at

• https://www.wikidata.org/wiki/User:TweetsFactsAndQueries/Wikimedia_Hackathon_2021_Data_Challenge/03.Map_out_the_coordinates_of_all_the_rivers_in_France,_highlight_the_ones_that_end_in_the_Mediterranean(in_the_WDQS-GUI_map)