NYC Rodent Data Analysis

​

Overview
 

This project examines how rodent-related 311 complaints and housing maintenance violations have evolved across New York City boroughs. Using open datasets from NYC’s 311 service requests and housing violation records, we examined spatial trends, resolution times, and enforcement gaps.
The goal was to help city agencies pinpoint rodent hotspots and improve response strategies using data visualization.

​

 What was built
 

• Filtered and cleaned two large public datasets for rodent complaints and rat-related housing violations

• Created borough-level aggregations, complaint timelines, and resolution metrics

• Developed Tableau dashboards to visualize
  - Rodent trends by borough and year
  - Complaint status breakdowns
  - ZIP code hotspots and resolution speed
  - Bivariate maps of complaint + violation overlap
  - Dual-axis chart for violations vs. resolution time
   

Outcome
 

• Brooklyn had the highest number of rodent complaints, followed by Manhattan

• Several ZIP codes had high complaints but low violations, indicating potential under-enforcement

• Violation resolution times have improved overall, but some areas still face delays

• The bivariate map effectively highlighted neighborhoods needing targeted attention

• The project demonstrates how visual analytics can uncover enforcement blind spots in urban public health
  
  ​View Interactive Dashboard on Tableau

​