2SCL – Smart City Platform (City SDG)
Smart city platform and city platform for tracking all 17 UN SDG indicators with AI assistance, API ingestion, and year-over-year comparison.
The Problem
City governments had no unified tool to track SDG progress across departments. Data lived in disconnected spreadsheets and external APIs with no way to compare year-over-year or see budget and resource allocation alongside indicator performance.
Architecture
- →
Full-stack web application with a data-dense dashboard and a separate presentation site
- →
Automatic API integration for real-time data ingestion with manual data entry fallback
- →
Calculation engine covering all 17 UN SDG indicators and their sub-indicators
- →
AI assistant for interpreting results and surfacing recommendations
Technical Challenges
- →
Unifying heterogeneous data sources (live APIs + manual CSV) into one consistent indicator view
- →
Implementing indicator calculations that match official UN SDG methodology
- →
Designing the data model to support multi-year comparison across changing city boundaries
Results
- ✓
Single platform for SDG indicator tracking, budget management, and automated alerts
- ✓
Year-over-year and cross-period comparison for all 17 goals out of the box
- ✓
Unified ingestion pipeline eliminates manual data entry for connected sources
