Chicago's Top-10 Worst Ticket Collection Wards (2017)

This project does a quick pull of the City of Chicago's 2017 Parking Ticket data, summarized by ward.

Then uses python to join those features to a GeoJSON Ward map so I can present which wards have the worst proportion of "Paid" tickets, over the respective set of issued tickets for that ward. The map was made by dropping the final transformed dataset ticketing_wards_2017.geoJSON into Felt.

Datasets Used

• City of Chicago Parking and Camera Ticket Data, via ProPublica Data Store
  • Uploaded to personal bigquery project and queried with 2017_ward_ticketing_stats.csv
• Boundaries - Wards (2015-2023), via Chicago Data Portal
  • GeoJSON saved in Project as Boundaries - Wards (2015-2023).geoJSON

Felt Visualization

https://felt.com/map/Chicagos-Top-10-Worst-Ticket-Collection-Wards-2017-raJta09BUR5aVConjo28MBB?loc=41.8552,-87.5456,10.81z&share=1