🇬🇧United Kingdom·Public management · MobilityActive engagement
County-wide traffic and origin-destination analytics
UK county council
Problem
Fourteen local authorities, fragmented ANPR/Bluetooth feeds, and an annual commercial GPS licence the council wanted to replace.
Approach
Doubly-constrained gravity models fused with UK Census and DfT open data, served through an interactive dashboard and REST API. Methodology published on GitHub as open-od-toolkit.
Capability
Open-source replacement for commercial mobility data; no vendor lock-in.
PythonGeoPandasFastAPIH3open-od-toolkit
🇫🇮Finland·Public management · MobilityActive engagement
Real-time traffic situation picture with anomaly alerting
Major Nordic capital city
Problem
City operators needed a unified situation picture for floating-car data with speed-anomaly detection and historical trend context.
Approach
Streaming ingestion of anonymised probe data, statistical change-point detection on corridor speeds, and LLM-assisted incident summaries delivered into the operator console.
Capability
From raw signals to operational insight — within one fused control surface.
LangGraphDuckDBPlotlyWebSockets
🇳🇱Netherlands·Public management · JusticeActive engagement
Criminal-justice data platform for a three-agency consortium
National probation service, partnered delivery
Problem
Consolidate probation-process data for three justice organisations into one analytics platform supporting 200+ dashboards and 200+ custom analyses per year.
Approach
Partnered delivery with an NL-based prime covering Dutch language and justice-sector clearance; we own the data-engineering, AI-insight, and dashboarding layers.
Capability
Delivery in the most sensitive public-sector domains, under clear data-protection control.
PythonPostgreSQLdbtPower BIAirflow