Query Service

From Swedish Museum
Revision as of 22:24, 20 November 2023 by Tore (talk | contribs)

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


Ny fråga

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

SELECT ?konstverk ?konstverkLabel ?geografiska_koordinater WHERE {

 ?konstverk wdt:P3 wd:Q9 .
 ?konstverk wdt:P17 ?geografiska_koordinater .
 SERVICE wikibase:label { bd:serviceParam wikibase:language "sv" . }

} LIMIT 100