NYC Parking Analytics

This project was built as part of CIS 9440 – Data Warehousing using NYC 311 and violation data to uncover enforcement gaps through KPI dashboards.

​

Overview

In a city as dense as New York, illegal parking poses daily operational and safety challenges. Residents actively report violations through NYC’s 311 system, while the city issues parking tickets through enforcement agencies. But are the most complained-about areas actually being enforced?

This project bridges the gap between public complaints and government action by building a data warehouse that integrates two key datasets:

• 311 illegal parking complaints

• NYC parking violation records

​

What We Built

​

• Extracted and cleaned 1.2M+ complaint and violation records.

• Built star schemas for both datasets, then created a unified model.

• Created fact tables and dimension tables for time, agency, vehicle, street, and violation type.

• Used Google BigQuery for warehouse creation and querying.

• Developed interactive Tableau dashboards to visualize complaint-to-violation trends.
  ​

Outcome

​

The data revealed that Brooklyn had the highest complaint volume, while Manhattan had more enforcement actions. Some heavily complained streets received few or no tickets, pointing to possible blind spots in enforcement.

Our dashboards highlighted:

• Streets and boroughs with mismatched complaint and violation patterns

• Peak violation types and enforcement activity over time

• Areas needing better resource allocation

​

Tools Used
Python (Google Colab), Google BigQuery, Tableau, Lucidchart