Query Service: Difference between revisions

no edit summary
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/>