Query Service: Difference between revisions
From Swedish Museum
No edit summary |
No edit summary |
||
| Line 24: | Line 24: | ||
PREFIX wdt: <https://swedishmuseum.wikibase.cloud/prop/direct/> | PREFIX wdt: <https://swedishmuseum.wikibase.cloud/prop/direct/> | ||
SELECT ?konstverk ?konstverkLabel ? | SELECT ?konstverk ?konstverkLabel ?geografiska_koordinater | ||
WHERE { | WHERE { | ||
?konstverk wdt:P3 wd:Q9 . | ?konstverk wdt:P3 wd:Q9 . | ||
?konstverk wdt:P17 ? | ?konstverk wdt:P17 ?geografiska_koordinater . | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv" . } | SERVICE wikibase:label { bd:serviceParam wikibase:language "sv" . } | ||
} | } | ||
LIMIT 100 | LIMIT 100 | ||
Revision as of 22:24, 20 November 2023
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
