Query Service: Difference between revisions

From Swedish Museum
No edit summary
No edit summary
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
<sparql tryit="1">
#defaultView:Map
#title:Gumman i Visby
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/>


SELECT ?item ?itemLabel ?place ?placeLabel ?latitude ?longitude
SELECT ?konstverk ?konstverkLabel ?geografiska_koordinater
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 ?plats
WHERE {
WHERE {
   ?konstverk wdt:P3 wd:Q9 .
   ?konstverk wdt:P3 wd:Q9 .
   ?konstverk wdt:P17 ?plats .
   ?konstverk wdt:P17 ?geografiska_koordinater .
   SERVICE wikibase:label { bd:serviceParam wikibase:language "sv" . }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en" . }
}
}
LIMIT 100
LIMIT 100
</sparql>

Latest revision as of 22:29, 21 November 2023

#defaultView:Map
#title:Gumman i Visby
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,en" . }
}
LIMIT 100

Try it!