Champion trees, and the tallest of each species

SELECT ?species (COUNT(?t) AS ?n) (MAX(?h) AS ?tallest) W…
  ?t a tci:Tree ; tci:champion true ; tci:taxon ?tx ; tci…
  ?tx skos:prefLabel ?species
}
GROUP BY ?species ORDER BY DESC(?n) LIMIT 15

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

caviri.github.io/rete

Run this query in the playground → 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