Ingest
Each month a Node job pulls street-level crimes from the police.uk API while the walkable street network comes from OpenStreetMap.
How it works
Each month a Node job pulls street-level crimes from the police.uk API while the walkable street network comes from OpenStreetMap.
Every street segment gets a risk_score from nearby incidents, weighted by category severity_weight.
Fastest, balanced and safest options are compared. The chosen route glows across the dark map.
DBSCAN with a haversine metric finds hotspots without needing a cluster count and ignores noise.
Tech stack
A production-shaped stack with a geospatial core.
Data sources: police.uk API for crimes and OpenStreetMap for the street network and pedestrian features.
Data model
Everything lives in PostgreSQL with PostGIS, in SRID 4326. Hover or tap a table to trace its links.