603,740
edits
Project:SPARQL/examples: Difference between revisions
→Observations and their locations
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
= Requests and Suggestions = | |||
= Examples = | |||
== Observations and their locations == | == Observations and their locations == | ||
<sparql tryit="1" list="1"> | <sparql tryit="1" list="1"> | ||
#defaultView:Map | #defaultView:Map | ||
PREFIX wbt: <http://biodiversity. | PREFIX wbt: <http://biodiversity.wikibase.cloud/prop/direct/> | ||
SELECT * WHERE { | SELECT * WHERE { | ||
| Line 112: | Line 115: | ||
PREFIX wbt: <http://biodiversity.wiki.opencura.com/prop/direct/> | PREFIX wbt: <http://biodiversity.wiki.opencura.com/prop/direct/> | ||
PREFIX wb: <http://biodiversity.wiki.opencura.com/entity/> | PREFIX wb: <http://biodiversity.wiki.opencura.com/entity/> | ||
SELECT DISTINCT ?taxon ?taxonLabel ?wikidata WITH { | SELECT DISTINCT ?country ?taxon ?taxonLabel ?wikidata WITH { | ||
SELECT * WHERE { | SELECT * WHERE { | ||
VALUES ?country {wd:Q664} # new zealand | VALUES ?country {wd:Q664} # new zealand | ||
| Line 128: | Line 131: | ||
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 | |||
} | |||
?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> { | ||