query-51229eab07502deb8db01ff40f1775ca
Map of Biosphere reserves with an entry and location in Wikidata but not in English Wikipedia
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
#defaultView:Map
SELECT ?wikidata_item ?biosphere_reserve_name ?biosphereURL ?image ?location
WHERE {
?wikidata_item wdt:P2520 ?biosphereURL ; # get a list of all biospheres
wdt:P625 ?location # and location
OPTIONAL{ ?wikidata_item wdt:P18 ?image }
FILTER NOT EXISTS { ?enwp schema:about ?wikidata_item ; schema:isPartOf <https://en.wikipedia.org/> } # No article in English wikipedia
?wikidata_item rdfs:label ?biosphere_reserve_name filter (lang(?biosphere_reserve_name) = "en")
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?biosphereURL"):::projected
v1("?biosphere_reserve_name"):::projected
v2("?enwp")
v6("?image"):::projected
v5("?location"):::projected
v3("?wikidata_item"):::projected
c4([https://en.wikipedia.org/]):::iri
f0[["?biosphere_reserve_name = 'en'"]]
f0 --> v1
f1[["not "]]
subgraph f1e0["Exists Clause"]
e0v1 --"schema:about"--> e0v2
e0v1 --"schema:isPartOf"--> e0c3
e0v1("?enwp"):::projected
e0v2("?wikidata_item"):::projected
e0c3([https://en.wikipedia.org/]):::iri
end
f1--EXISTS--> f1e0
f1 --> v2
f1 --> c2
f1 --> v3
f1 --> c3
f1 --> c4
v2 --"schema:about"--> v3
v2 --"schema:isPartOf"--> c4
v3 --"wdt:P2520"--> v4
v3 --"wdt:P625"--> v5
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P18".-> v6
end
v3 --"rdfs:label"--> v1