query-8d6ef92de1e4a3f5dadef74901cfdbf2

rq turtle/ttl

TODO

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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:Map{"hide":["?coordinates"]}
SELECT ?item ?itemLabel (SAMPLE(?coordinates_) AS ?coordinates) WHERE {
  # there seem to be two possible ways of modeling a shipwreck (may be combined on the same item)
  {
    # instance of shipwreck, coordinates as main statement
    ?item wdt:P31 wd:Q852190;
          wdt:P625 ?coordinates_.
  } UNION {
    # significant event shipwreck, coordinates as qualifier of that
    ?item p:P793 [
      a wikibase:BestRank;
      ps:P793 wd:Q906512;
      pq:P625 ?location
    ].
  }
  # include both (the GROUP BY will ensure we don’t get duplicates)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?item ?itemLabel # coalesce duplicate coordinates and also items that are selected by both UNION branches

Query found at

• https://www.wikidata.org/wiki/User:TweetsFactsAndQueries/Wikimedia_Hackathon_2021_Data_Challenge/06._Map_out_the_coordinates_of_all_the_shipwrecks_on_the_Earth.