query-2b4715f41b1bb9967861e4895dfa29ab
High schools in Virginia with coordinate location (P625) but no OpenStreetMap links
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX osmt: <https://wiki.openstreetmap.org/wiki/Key:>
SELECT DISTINCT ?school WHERE {
?school wdt:P31 wd:Q9826.
?school wdt:P131* wd:Q1370.
?school wdt:P625 [].
FILTER (!BOUND(?osmid)).
SERVICE <https://sophox.org/sparql> {
OPTIONAL {?osmid osmt:wikidata ?school}.
}
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?osmid")
v2("?school"):::projected
a1((" "))
c4(["wd:Q1370"]):::iri
c2(["wd:Q9826"]):::iri
f0[["not bound(?osmid)"]]
f0 --> v1
v2 --"wdt:P31"--> c2
v2 --"wdt:P131"--> c4
v2 --"wdt:P625"--> a1
subgraph s1["https://sophox.org/sparql"]
style s1 stroke-width:4px;
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v1 -.https://wiki.openstreetmap.org/wiki/Key:wikidata.-> v2
end
end