To evaluate city responsiveness while avoiding right-censoring bias, we filtered 311 complaints to mature records (at least 30 days old) and benchmarked the 30-day resolution rate against active restaurant rodent violations (code 04K). We found severe structural disconnects across neighborhoods: residential complaint epicenters experience longer resolution lag times despite lower routine commercial inspection coverage, whereas dense dining corridors rack up commercial pest citations with minimal residential 311 volume.
To prevent small-sample distortion and skewed per-capita metrics, we excluded non-NYC postal zones, invalid ZIP codes, and special-use or airport tracts with fewer than 10 distinct inspected establishments (COUNT(DISTINCT camis) < 10).
The primary limitation is that 311 records capture civic trust, language accessibility, and reporting propensity rather than true biological rodent density, while Health Department records reflect cyclical business inspection schedules rather than complaint-driven dispatches.
"If I worked for the city, I would reallocate proactive pest-control sweeps and cross-agency inspections into high-complaint residential ZIP codes that currently lag in routine commercial health oversight, because our data shows the city's slowest 311 resolution times and highest public calls for help occur precisely where proactive restaurant inspection presence is lowest."
Log in or sign up for Devpost to join the conversation.