reteplayground
Aggregate

Which municipality has the most species diversity

MunicipalityTreesDistinct species
Jussy4,4791594
Genève-Petit-Saconnex20,2931064
Chêne-Bougeries14,859585
Meyrin9,717557
Run this query → no server · no download · no account
caviri.github.io/rete
Run this query in the playground → 20 rows · 1.6 s · 256.0 KB 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#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> SELECT ?muni (COUNT(?t) AS ?trees) (COUNT(DISTINCT ?tx) AS ?species) WHERE { ?t a tci:Tree ; tci:inMunicipality ?m ; tci:taxon ?tx . ?m rdfs:label ?muni } GROUP BY ?muni ORDER BY DESC(?species) LIMIT 20

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