An interactive analysis of 369,000+ service requests from Q1 2025, built from public open data.
311 is the City of Los Angeles non-emergency service line. Residents use it to report issues like illegal dumping, graffiti, potholes, and homeless encampments. Every request is logged as public data.
We pulled 369,000+ of these requests from Q1 2025 and built an interactive dashboard that breaks them down by type, neighborhood, response time, and geography. The goal: show how raw public data can be turned into something a city official, journalist, or community organizer can actually use to spot patterns and drive decisions.
This dashboard was built to demonstrate the full pipeline: raw public data, transformed through our data engineering process into clean aggregations, then visualized as an interactive experience. No manual data entry, no static screenshots.
Automated extraction from the City of LA SODA API with server-side aggregation queries, transforming 369K+ raw records into optimized static datasets.
Recharts-powered visualizations with responsive layouts, animated transitions, and hover tooltips for detailed exploration.
Mapbox GL JS clustered point map showing request density across the city, with click-to-zoom and popup details.
Pre-computed aggregations served as static JSON. No runtime API calls, no spinners, no loading delays. The dashboard loads instantly.
Next.js 16, React 19, TypeScript, and Tailwind CSS. Fully static generation with client-side interactivity where it matters.
Raw numbers become actionable insights. Key findings are highlighted between charts to demonstrate how data drives decisions.
Data source: City of LA Open Data Portal | Interested in our other work? View all projects | Read the full blog post
This project combines our data engineering and GIS analysis capabilities into a single interactive experience. For another example of geospatial visualization, explore FlightPulse, our interactive flight tracking map built with Mapbox.
Every week without analytics is another week of decisions made on gut instinct. Book a free 30-minute call and we'll show you exactly where your data can drive revenue.
or email us directly at mazen@figmentanalytics.com