603,740
edits
Project:SPARQL/examples: Difference between revisions
→species observed through iNaturalist in New Zealand not being described by an English Wikipedia article
| Line 128: | Line 128: | ||
INCLUDE %result | INCLUDE %result | ||
?observation wbt:P9 ?taxon . | ?observation wbt:P9 ?taxon . | ||
?taxon wbt:P11 ?wikidata . | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
?wikidata wdt:P31 [] . | |||
MINUS {?article schema:about ?wikidata ;schema:isPartOf <https://en.wikipedia.org/> ;schema:inLanguage "en" .} | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | |||
} | |||
</sparql> | |||
== Observations by a select set of observers that are not being described on the English Wikipedia == | |||
<sparql tryit="1" list="1"> | |||
#species observed through iNaturalist in New Zealand not being described by an English Wikipedia article | |||
PREFIX wbt: <http://biodiversity.wiki.opencura.com/prop/direct/> | |||
PREFIX wb: <http://biodiversity.wiki.opencura.com/entity/> | |||
PREFIX observer: <https://www.inaturalist.org/people/> | |||
SELECT DISTINCT | |||
?observer | |||
?taxon | |||
?taxonLabel | |||
?wikidata | |||
?observationUrl | |||
?observationPhoto | |||
WHERE { | |||
VALUES ?observer { | |||
observer:andrawaag | |||
observer:radrat | |||
observer:siobhanleachman | |||
observer:qgroom | |||
} | |||
?observation wbt:P9 ?taxon ; | |||
wbt:P6 ?observationUrl ; | |||
wbt:P7 ?observationPhoto ; | |||
wbt:P3 ?observer . | |||
?taxon wbt:P11 ?wikidata . | ?taxon wbt:P11 ?wikidata . | ||
SERVICE <https://query.wikidata.org/sparql> { | SERVICE <https://query.wikidata.org/sparql> { | ||