query-65a7d1a3f86da93e2619bf7787834e0b
14:27, 12 November 2020 (UTC) Jura>8000 images --- 14:40, 12 November 2020 (UTC) Jura --- (P625)coordinate location on images, not (P1259)coordinates of the point of view I forgot to mention, the above queries for 14:35, 12 November 2020 (UTC)) talk (Dipsacus fullonumI was about to say the same. You could fetch the coordinates of Q1731 from Wikidata with a federated call to WDQS, or use the coordinates of a file as the center. -- 14:49, 12 November 2020 (UTC)) talk (sk: Many thanks. This help! I know there are many images, but I need an example for the first query. :-) -- Jura1, Dipsacus fullonum@
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:Map{"hide":["?coor"]}
# query by Jura1, 2020-11-12
SELECT ?fileLabel ?fileDescription ?image ?coor
WHERE
{
SERVICE <https://query.wikidata.org/sparql> { wd:Q2079 wdt:P625 ?center }
SERVICE wikibase:around {
?file wdt:P1259 ?coor.
bd:serviceParam wikibase:center ?center .
bd:serviceParam wikibase:radius "1". # 1 kilometer around
}
?file schema:contentUrl ?url .
bind(iri(concat("http://commons.wikimedia.org/wiki/Special:FilePath/", wikibase:decodeUri(substr(str(?url),53)))) AS ?image)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de". }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?center")
v3("?coor"):::projected
v2("?file")
v5("?image"):::projected
v4("?url")
c9(["1"]):::literal
c6(["bd:serviceParam"]):::iri
c2(["wd:Q2079"]):::iri
c13(["#91;AUTO_LANGUAGE#93;,en,de"]):::literal
subgraph s1["https://query.wikidata.org/sparql"]
style s1 stroke-width:4px;
c2 --"wdt:P625"--> v1
end
subgraph s2["http://wikiba.se/ontology#around"]
style s2 stroke-width:4px;
v2 --"wdt:P1259"--> v3
c6 --"wikibase:center"--> v1
c6 --"wikibase:radius"--> c9
end
v2 --"schema:contentUrl"--> v4
bind0[/"concat('http://commons.wikimedia.org/wiki/Special:FilePath/',http://wikiba.se/ontology#decodeUri(substring(str(?url),'53^^xsd:integer')))"/]
v4 --o bind0
bind0 --as--o v5
subgraph s3["http://wikiba.se/ontology#label"]
style s3 stroke-width:4px;
c6 --"wikibase:language"--> c13
end