query-51229eab07502deb8db01ff40f1775ca

rq turtle/ttl

Map of Biosphere reserves with an entry and location in Wikidata but not in English Wikipedia

Use at

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