Projects that are built on top of trilogy for data curation, refresh, or presentation.
Featured project
GCAT Space Dataset Explorer
Interactive chat + visual exploration for launches, vehicles, satellites, and operators based on a rich space exploration dataset. Data from GCAT (J. McDowell, planet4589.org/space/gcat) - see link.
Open live project·View repository
- Data wrangling: scheduled github actions jobs uses trilogy to shape public source files into analysis-ready datasets and output curated sets for presentation.
- Chat analytics: uses text-to-trilogy to power a chat experience over the full raw dataset.
Featured project
About Urban Trees
An interactive browser-based map of US Urban forests. Explore hundreds of thousands of street trees by location, species, and ecological attributes across sities like NYC and SF.
Open About SF Trees·View repository
- Data sources: SF and NYC Open Data Portal Street Trees and Landmarks datasets, CARTO Dark Matter basemap, plus species enrichment from Wikipedia APIs, POWO (Kew), GBIF, and SelecTree.
- Structured enrichment: species attributes are extracted into fields including native status, evergreen, mature size, growth, lifespan, drought tolerance, bloom season, wildlife value, and fire risk using Gemini 2.5 Pro.
- Tech stack: Vue 3, Vite 6, MapLibre GL 4, DuckDB WASM, Claude Sonnet, and Trilogy/PreQL query workflows.
- See also: SF Urban Forestry.
