603,740
edits
(26 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
= Requests and Suggestions = | |||
= Examples = | |||
== Observations and their locations == | == Observations and their locations == | ||
< | <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 { | ||
?s wbt:P8 ?o . | ?s wbt:P8 ?o . | ||
} | } | ||
}} | </sparql> | ||
</ | |||
== Species covered and counts == | |||
<sparql tryit="1" list="1"> | |||
PREFIX wbt: <http://biodiversity.wiki.opencura.com/prop/direct/> | |||
SELECT ?scientific_nameURL ?scientific_nameIRILabel (COUNT(?scientific_nameIRI) AS ?counts) WHERE { | |||
?observationIRI wbt:P9 ?scientific_nameIRI . | |||
BIND (iri(replace(str(?scientific_nameIRI), "entity/", "wiki/Item:")) as ?scientific_nameURL) | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | |||
} | |||
GROUP BY ?scientific_nameURL ?scientific_nameIRILabel | |||
ORDER BY DESC(?counts) | |||
</sparql> | |||
== Observations of selected bird species as map layers == | |||
<sparql tryit="1" list="1"> | |||
# Observations of frequent bird species and their geoocoordinates | |||
# Species: | |||
# - Anas platyrhynchos (Q367) | |||
# - Larus occidentalis (Q37) | |||
# - Branta canadensis (Q345) | |||
# - Turdus migratorius (Q107) | |||
# - Zenaida macroura (Q257) | |||
#defaultView:Map | |||
PREFIX wbt: <http://biodiversity.wiki.opencura.com/prop/direct/> | |||
PREFIX wb: <http://biodiversity.wiki.opencura.com/entity/> | |||
SELECT DISTINCT ?s ?o ?layer WHERE { | |||
?s wbt:P8 ?o . | |||
?s wbt:P9 ?t. | |||
FILTER(?t IN (wb:Q367, wb:Q37, wb:Q345, wb:Q107, wb:Q257)). | |||
BIND(?t AS ?layer). | |||
} | |||
</sparql> | |||
= Federated queries = | = Federated queries = | ||
== Egg-incubation time of the bird observed with iNaturalist == | |||
<sparql tryit="1" list="1"> | |||
PREFIX wb: <http://biodiversity.wiki.opencura.com/entity/> | |||
PREFIX wbt: <http://biodiversity.wiki.opencura.com/prop/direct/> | |||
SELECT * WHERE { | |||
VALUES ?observation {wb:Q46561} | |||
?observation wbt:P8 ?coordinate_location ; | |||
wbt:P1 ?observation_id ; | |||
wbt:P9 ?scientific_name . | |||
?scientific_name wbt:P11 ?wikidata_iri . | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
?wikidata_iri wdt:P7770 ?egg_incubation_time . | |||
} | |||
} | |||
</sparql> | |||
== Plot observations based on an NCBI taxon id on Wikidata == | == Plot observations based on an NCBI taxon id on Wikidata == | ||
< | <sparql tryit="1" list="1"> | ||
#defaultView:Map | #defaultView:Map | ||
PREFIX wbt: <http://biodiversity.wiki.opencura.com/prop/direct/> | PREFIX wbt: <http://biodiversity.wiki.opencura.com/prop/direct/> | ||
Line 28: | Line 79: | ||
} | } | ||
</ | </sparql> | ||
== iNaturalist observations without a Wikipedia article (in any language) == | |||
<sparql tryit="1" list="1"> | |||
PREFIX wbt: <http://biodiversity.wiki.opencura.com/prop/direct/> | |||
PREFIX wb: <http://biodiversity.wiki.opencura.com/entity/> | |||
SELECT ?taxon ?taxonLabel ?wikidata WHERE { | |||
?taxon wbt:P13 wb:Q131918 ; | |||
wbt:P11 ?wikidata . | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
?wikidata wdt:P31 ?type . | |||
FILTER NOT EXISTS {?article schema:about ?wikidata .} | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | |||
} | |||
</sparql> | |||
== species observed through iNaturalist not being described by an English Wikipedia article == | |||
<sparql tryit="1" list="1"> | |||
PREFIX wbt: <http://biodiversity.wiki.opencura.com/prop/direct/> | |||
PREFIX wb: <http://biodiversity.wiki.opencura.com/entity/> | |||
SELECT DISTINCT ?taxon ?taxonLabel ?wikidata WHERE { | |||
?taxon wbt:P13 wb:Q131918 ; | |||
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> | |||
== species observed through iNaturalist in New Zealand not being described by an English Wikipedia article == | |||
<sparql tryit="1" list="1"> | |||
PREFIX wbt: <http://biodiversity.wiki.opencura.com/prop/direct/> | |||
PREFIX wb: <http://biodiversity.wiki.opencura.com/entity/> | |||
SELECT DISTINCT ?country ?taxon ?taxonLabel ?wikidata WITH { | |||
SELECT * WHERE { | |||
VALUES ?country {wd:Q664} # new zealand | |||
SERVICE wikibase:around { | |||
?observation wbt:P8 ?location . | |||
bd:serviceParam wikibase:center ?loc . | |||
bd:serviceParam wikibase:radius "100" . | |||
} | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
?country wdt:P625 ?loc . | |||
} | |||
} | |||
} as %result | |||
WHERE { | |||
INCLUDE %result | |||
?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 . | |||
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> |