Query Service

From Swedish Museum
Revision as of 20:07, 19 November 2023 by Tore (talk | contribs) (test query)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

PREFIX wd: <https://swedishmuseum.wikibase.cloud/entity/> PREFIX wdt: <https://swedishmuseum.wikibase.cloud/prop/direct/>

SELECT ?item ?itemLabel ?place ?placeLabel ?latitude ?longitude WHERE {

 ?item wdt:P3 wd:Q9 .
 OPTIONAL {
   ?item wdt:P17 ?place.
  
   BIND (xsd:double(strbefore(strafter(str(?coordinates), "("), " ")) AS ?latitude)
   BIND (xsd:double(strbefore(strbefore(strafter(str(?coordinates), " "), ")"), " ")) AS ?longitude)
 }
 SERVICE wikibase:label {
   bd:serviceParam wikibase:language "sv".
 }

} ORDER BY ?itemLabel