Champion trees, and the tallest of each species

Species	Champions	Tallest (m)
Quercus robur subsp. robur	491	33
Quercus robur	434	35
Sequoiadendron giganteum	174	46
Populus nigra subsp. nigra 'I…	128	35

Run this query → no server · no download · no account

caviri.github.io/rete

Run this query in the playground → 15 rows · 350 ms · 2.0 MB of 23.9 MB read over HTTP range · no server, no download — the query runs in your browser.

The query

PREFIX tci: <https://data.graphplaza.com/tree-city-inventory/ns#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> SELECT ?species (COUNT(?t) AS ?n) (MAX(?h) AS ?tallest) WHERE { ?t a tci:Tree ; tci:champion true ; tci:taxon ?tx ; tci:heightM ?h . ?tx skos:prefLabel ?species } GROUP BY ?species ORDER BY DESC(?n) LIMIT 15

rete playground · documentation · github.com/caviri/rete