Query Service: Difference between revisions

From Swedish Museum
No edit summary
No edit summary
Line 1: Line 1:
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 wd: <https://swedishmuseum.wikibase.cloud/entity/>
PREFIX wdt: <https://swedishmuseum.wikibase.cloud/prop/direct/>
PREFIX wdt: <https://swedishmuseum.wikibase.cloud/prop/direct/>

Revision as of 21:23, 21 November 2023

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