Project:SPARQL/examples: Difference between revisions

Project:SPARQL/examples (view source)

1,239 bytes added , 3 months ago

579

edits

@@ Line 1,600: / Line 1,600: @@
 ORDER BY ?locationLabel
+</sparql>
+=== Locations of BN excavations ===
+<sparql tryit="1">
+#title:Locations of BN excavations
+PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
+PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
+PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
+PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
+PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
+PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
+PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+#defaultView:Map
+SELECT distinct ?item ?itemLabel ?locationLabel ?location ?wikidata ?wd_geo
+WHERE {
+  ?item bnwdt:P12 bnwd:Q38 .
+  ?item bnwdt:P2  ?location .  # item has property P2 location
+  ?location bnwdt:P117 ?ws .  # and has wikidata id
+    bind(iri(concat("http://www.wikidata.org/entity/", str(?ws))) as ?wikidata) .
+         SERVICE <https://query.wikidata.org/sparql> {
+             wd:Q1026699 wdt:P625 ?start. # devizes coordinates
+             ?wikidata wdt:P625 ?wd_geo .
+         } # /wikidata service
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+}
+ORDER BY ?locationLabel
 </sparql>