Context
Municipalities and their operators needed a single platform to manage public lighting schedules, detect anomalies and plan maintenance.
Approach
Development of a web application serving as a management portal and analysis dashboards. AWS S3 + DuckDB/Parquet real-time stack, Shell/Cron pipelines, FastAPI backend and TypeScript/SvelteKit UI.
Impact
Application consulted every morning by network managers. Dynamic lighting schedules and predictive maintenance deployed across 40+ territories.
Measurements/day
>100 M
Territories
+40
IoTDuckDBSvelteKitPostgreSQLFastAPI
What we delivered
- Continuous collection of lighting meters with optimized S3 + Parquet storage.
- DuckDB analytics delivering KPIs within seconds over multi-year history.
- Alert dashboards for operators (failures, consumption, schedule anomalies).
- Open REST API to plug operator and city systems.
- Multi-tenant management with granular permissions and per-city segmentation.
Want to explore a similar use case?
Let's align on your next data, app or AI priority and draft an actionable roadmap in days.