The commonest trees in Geneva

SELECT ?species (COUNT(?t) AS ?n) WHERE {
  ?t a tci:Tree ; tci:taxon ?tx .
  ?tx skos:prefLabel ?species
}
GROUP BY ?species ORDER BY DESC(?n) LIMIT 20

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) WHERE { ?t a tci:Tree ; tci:taxon ?tx . ?tx skos:prefLabel ?species } GROUP BY ?species ORDER BY DESC(?n) LIMIT 20

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