query-dbcd916ad39b97df49c8e2f589d6ea98
TODO
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 prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?item ?type (CONCAT(STR(?lat),' / ',STR(?long)) AS ?loc) WHERE {
?item wdt:P31/wdt:P279? wd:Q744099 ; wdt:P31 ?type ; wdt:P131 wd:Q23183 ; wdt:P4102 ?atlas ; p:P625 ?locstatement .
FILTER EXISTS { ?locstatement prov:wasDerivedFrom/pr:P854 ?locref } .
?locstatement psv:P625 ?coordinate_node .
?coordinate_node wikibase:geoLatitude ?lat .
?coordinate_node wikibase:geoLongitude ?long .
?type wdt:P279? wd:Q744099
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?atlas")
v6("?coordinate_node")
v3("?item"):::projected
v7("?lat"):::projected
v9("?loc")
v2("?locref")
v1("?locstatement")
v8("?long"):::projected
v4("?type"):::projected
a2((" "))
a1((" "))
c4(["wd:Q744099"]):::iri
c7(["wd:Q23183"]):::iri
f0[[" "]]
subgraph f0e0["Exists Clause"]
e0v1 --"prov:wasDerivedFrom"--> e0a1
e0a1 --"p:reference/P854"--> e0v2
e0v2("?locref"):::projected
e0v1("?locstatement"):::projected
e0a1((" ")):::projected
end
f0--EXISTS--> f0e0
f0 --> v1
f0 --> c1
f0 --> a1
f0 --> c2
f0 --> v2
v1 --"prov:wasDerivedFrom"--> a1
a1 --"p:reference/P854"--> v2
v3 --"p:direct/P31"--> a2
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
a2 --"p:direct/P279"--> c4
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
end
union0r <== or ==> union0l
end
v3 --"p:direct/P31"--> v4
v3 --"p:direct/P131"--> c7
v3 --"p:direct/P4102"--> v5
v3 --"p:P625"--> v1
v1 --"p:statement/value/P625"--> v6
v6 --"wikibase:geoLatitude"--> v7
v6 --"wikibase:geoLongitude"--> v8
subgraph union1[" Union "]
subgraph union1l[" "]
style union1l fill:#abf,stroke-dasharray: 3 3;
v4 --"p:direct/P279"--> c4
end
subgraph union1r[" "]
style union1r fill:#abf,stroke-dasharray: 3 3;
end
union1r <== or ==> union1l
end
bind1[/"concat(str(?lat),' / ',str(?long))"/]
v7 --o bind1
v8 --o bind1
bind1 --as--o v9