603,740
edits
Project:SPARQL/examples: Difference between revisions
→Observations and their locations
| Line 8: | Line 8: | ||
} | } | ||
}} | }} | ||
</syntaxhighlight> | |||
== Species covered and counts == | |||
<syntaxhighlight> | |||
PREFIX wbt: <http://biodiversity.wiki.opencura.com/prop/direct/> | |||
SELECT ?scientific_nameURL ?scientific_nameIRILabel (COUNT(?scientific_name) 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) | |||
</syntaxhighlight> | </syntaxhighlight> | ||