Category Archives: _Drawing Machine

Chicago Potholes, Real-Time Drawing Machine

ChicagoPotholes Zip Processing Folder

The source file for the open 311 requests is over 80mb of a csv text file!!! Therefore, I just took a sample of 2860 records out of the full 357,588 dating back to 2009 and used a static csv file for the full 311 listing. I used a current, real time link to a record of potholes patched in the last 7 days, because that only has an average of 1000 records at a time and can load without much delay.

potholes_01 potholes_02 potholes_03

Data Drawing Machine

Bike Crash Conditions Data from 2007-2009


Screen Shot 2014-12-11 at 11.55.10 PM

Basic state showing tiers of crash amounts within the circle.

Screen Shot 2014-12-11 at 11.55.30 PM

When you click on a button category, it displays the amount of crashes that occurred with that condition. There were just over 3000 crashes between 2007-2009 that happened in daylight.

Screen Shot 2014-12-11 at 11.55.54 PM

Around 550 crashes with wet pavement.

Screen Shot 2014-12-11 at 11.54.19 PM

1000 crashes in darkness.