query-4612e5a426199c8806463baa153d3608
???
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 psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel ?itemDescription ?geographLink
WHERE {
?item wdt:P31/wdt:P279* wd:Q44494;
wdt:P131* wd:Q5922;
p:P625 ?coordinate.
?coordinate psv:P625 ?coordinate_node.
?coordinate_node wikibase:geoLatitude ?lat.
?coordinate_node wikibase:geoLongitude ?lon.
BIND(URI(CONCAT("http://geo.hlipp.de/browse.php?ll=",STR(?lat),",",STR(?lon))) AS ?geographLink)
SERVICE wikibase:label { bd:serviceParam wikibase:language "de". }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?coordinate")
v3("?coordinate_node")
v6("?geographLink"):::projected
v1("?item"):::projected
v4("?lat")
v5("?lon")
a1((" "))
c13(["de"]):::literal
c3(["wd:Q44494"]):::iri
c11(["bd:serviceParam"]):::iri
c5(["wd:Q5922"]):::iri
v1 --"p:direct/P31"--> a1
a1 --"p:direct/P279"--> c3
v1 --"p:direct/P131"--> c5
v1 --"p:P625"--> v2
v2 --"p:statement/value/P625"--> v3
v3 --"wikibase:geoLatitude"--> v4
v3 --"wikibase:geoLongitude"--> v5
bind0[/"concat('http://geo.hlipp.de/browse.php?ll=',str(?lat),',',str(?lon))"/]
v4 --o bind0
v5 --o bind0
bind0 --as--o v6
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c11 --"wikibase:language"--> c13
end