Crime Hotspot Map
Chennai Metropolitan Area — 0 active risk zones
Risk 7–10Risk 4–6Risk 1–3
Zone Intel
| Area | Incidents | Risk Level | Coordinates |
|---|
Core Engine Query // PostgreSQL
SELECT
l.location_id,
l.area_name,
l.latitude,
l.longitude,
l.risk_level,
count(c.crime_id) as incident_count
FROM public.locations l
LEFT JOIN public.crimes c ON l.location_id = c.location_id
GROUP BY l.location_id
ORDER BY incident_count DESC;
Authenticated Audit Trail Enabled