A demo platform showcasing what a fully sovereign, open-source data warehouse for municipalities can look like. Explore the complete stack — from citizen letter intake to geospatial analysis — with zero cloud lock-in.
This is a demonstration platform showcasing what is possible with fully open-source tooling. Every component runs on your own infrastructure — no vendor lock-in, no cloud dependencies, full control over your data.
Ingest data from phone calls, website forms, and handwritten letters — processed by an open-source vision LLM for address extraction.
Self-hosted geocoding with Nominatim, spatial analysis via GeoServer and PostGIS, and a GeoNode data catalog.
Five pre-built Grafana dashboards monitor API performance, geocoding success rates, LLM extraction metrics, and pipeline health.
This platform demonstrates that municipalities and organizations can build a complete, production-grade data warehouse using only open-source, self-hosted components.
A fully functional data platform demo covering the entire lifecycle: citizen letter intake via drag-and-drop upload, AI-powered address extraction using an open-source vision LLM, self-hosted geocoding, a bronze-silver-gold data warehouse in ClickHouse, and geospatial analysis with GeoServer and PostGIS. Every component runs in Docker containers with zero cloud dependencies.
To prove that sovereign, open-source alternatives to commercial cloud platforms are not just viable — they are production-ready. This demo shows how municipalities can process citizen requests, run spatial analysis, and serve analytics dashboards without sending a single byte to a third-party cloud provider. Full control, full transparency, full sovereignty.
Browse the Tech Stack to understand the 17+ components and how they connect. Follow the Demo Walkthrough for a step-by-step tour from letter upload to geospatial output. Or explore the Components page to open any live service interface directly.
From ingestion to geospatial analysis — explore the full architecture or jump straight into the live service interfaces.