Context
A client specialized in public lighting management for municipalities and their service providers needed a single platform to manage public lighting, adjust 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
The application is consulted every morning by network managers. Consumption and incident measurements are dynamically adjusted, with predictive maintenance and alerting deployed across more than 40 territories.
Measurements/day
>100 M
Territories
+40
What we delivered
- Continuous collection of lighting meters with optimized S3 + Parquet storage.
- Shell/Cron pipelines to refresh the cache.
- DuckDB analytics delivering KPIs instantly over multi-year history, with dynamic visualizations to display results.
- Mandate management system for data owners and users.
- 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.