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.
Bike Crash Conditions Data from 2007-2009
A wireless device designed to fit into the air vent on the top of a helmet is used in combination with sensors in the fabric of the helmet. Specific data analysis algorithms process injury information from the sensors to quantify clinically significant impacts. Then the wireless device transmits a signal to the user’s smartphone via Bluetooth technology. The phone is programmed to alert medical services. The SenseTech hardware will also use data from personal information on the phone or other personal IDs to provide emergency contact information and medical information. This is particularly useful when a cyclist is riding alone.
Another innovative idea to help with helmet safety is to build in a motivator for cyclists to realize when they need to buy a new helmet. Helmets often get damaged when they prevent impacts which can continuously reduce the effectiveness of the helmet in protecting against head injury. There’s almost no point of wearing a helmet if its structural integrity is too compromised. Therefore, a way to motivate cyclists to replace their helmets and let them know when the equipment is too compromised, is to make it stink by inserting chemical capsules into the foam of a helmet. When the foam cracks or moves too much, the capsules will rupture and release an odor around the cyclist’s head. Each time the structure is compromised it will stink and remind the cyclist that they should buy a new helmet.
Danny Tirado, Rob Schulz, Kimi Oyama
“Bike Safety in Chicago”
In the last decade, Chicago has majorly evolved as a bike friendly city . This may correspond to recent improvements in bike lane structures, or the newly implemented bike share program Divvy. Since 2000, the number of bicycle commuters has increased by 150 percent with an estimated 15,000 cyclists daily. However, growth in cycling has not come without challenges and tragedies. There has been an increased concerned about bicycle safety as motorists have been forced to share the road more and more. An average of 1,500 bicycle crashes are reported each year and that number has been rising. While crashes that result in major injuries or fatalities are reported, minor crashes are often not reported or recorded by the cyclist community. Although focused programs and efforts by the city to improve bicycle safety are underway, more can be done to highlight and reduce preventable hazards. By continuing to support and improve bike safety in Chicago, cyclists can be freer to enjoy the healthy, environmentally friendly trend of cycling in Chicago.
Primary Research Questions:
1) To Law Enforcement: Can traffic camera footage be pulled up to investigate hit and run cycling accidents if a specific time frame and location is given? (What is the standard procedure for investigating hit and run incidents involving cyclists?)
2) To Cyclists: How many times have you been hit or doored by a vehicle this year? Out of those incidents, how many have you officially reported. How many were serious injuries?
3) Whom or what is responsible for crash incidents? Motorists? Cyclists? Road conditions? A combination?
4) What current initiatives or plans are in place to help reduce the number of bike accidents around the city?
5) What neighborhoods of Chicago or specific intersections have the heaviest rate of bicycle accidents, categorized by fatality or level of injury?
6) What times of the day are accidents happening the most?
Q1: How are agencies compelled or enabled to share their data in accordance with the Open Data Policy? How do they even decide what to collect data on and how does it get formatted for the portal?
Q2: What is the most interesting data set you have ever seen from Chicago?
Q3: Has anyone ever been angry about or resisted the release of certain data?
Q4: Is data verified by third parties at all?
Topic #1: Bike Safety In Chicago
Source #1: “How Dangerous Is It To Bicycle Commute in Chicago?” by Chelsi Moy, Curious City, WBEZ, September 25, 2013 (http://www.wbez.org/series/curious-city/biking-chicago-risky-proposition-108762)
Thesis: An attempt to assess the statistical risk of injury or death when bicycle commuting in Chicago.
Data Point: In 2011, there were 336 dooring crashes in Chicago
Source #2: “2012 Chicago Bike Crash Analysis”, by Chicago Department of Transportation, http://www.cityofchicago.org/content/dam/city/depts/cdot/bike/general/BikeCrashReport2012.pdf
Thesis: Summary of data collected from various sources from 2005-2010 to analyze bike safety issues and incidents in an attempt to create policies moving forward to reduce occurrences.
Data Point: In the six-year period between 2005 and 2010, there were nearly 9,000 injury crashes involving bicyclists, with 32 bicyclistfatalities. As a percentage of all traffic crashes, bicycle crashes are on the rise: from 6.7 percent of all crash types in 2005 to 9.8 percent of all crash types in 2010.
Source #3: “City’s Most Dangerous Streets for Bikers”, by NBC5 Chicago, July 16th, 2013, http://www.nbcchicago.com/news/local/Report-Shows-Diagonal-Crossing-Areas-Worst-Place-For-Bikers-215251811.html
Thesis: This article names and outlines the most dangerous intersections reported in Chicago with the highest rates of crashes.
The street with the highest crash rate per mile during the six years studied was a 0.7-miles stretch on Milwaukee Avenue between North Avenue and Division with 50 crashes. Clark Street between Racine and Fullerton Avenues came in second place with 78 collisions in 1.6 miles and Milwaukee Avenue between Fullerton and Armitage came in third with 34 crashes in 0.7 miles, according to DNAinfo.com.
Data Set: http://www.cmap.illinois.gov/mobility/walking-and-bicycling/safety maps and data collected for Chicago, and the state by IDOT and local agencies on pedestrian/motor/bicycle collisions.
Topic #2: Divvy Bike-share Usage
Source #1: “Divvy bike-share expansion delayed until spring” by Jon Hilkevitch, Chicago Tribune, August 21, 2014 (http://www.chicagotribune.com/news/local/breaking/ct-divvy-new-stations-bikes-met-0821-20140821-story.html)
Thesis: The Divvy bike-share program has had plans to further expand their program which has only been delayed, apparently, by the bankruptcy of an equipment supplier.
Data Point: Divvy has grown to more than 2.3 million individual trips since the bike-share program was launched in June 2013.
Source #2: “Divvy Map Shows How Commutes Vary in Chicago’s ‘Hoods” by Lizzie Schiffman, DNAinfo Chicago, July 3, 2014 (http://www.dnainfo.com/chicago/20140703/loop/divvy-data-visualization-map-charts-routes-trips-other-biking-behavior)
Thesis: Attempt to infer traffic patterns for all cyclists using Divvy usage data to possibly come up with ways to move cyclists around Chicago better.
Data: data….is the map (below).
Source #3: “New Data Reveals How Hyde Parkers Use Divvy”, by By Jeffery Bishku-Aykul and Jessica Kim Cohen, The Hyde Park Herald, July 23rd, 2014, http://hpherald.com/2014/07/23/new-data-reveals-how-hyde-parkers-use-divvy/
Thesis: An analysis of how Hyde Park residents are using the Divvy system.
Data Point: Divvy data also revealed a stark gender imbalance: among subscribers riding within Hyde Park, around 81 percent of trips were taken by men. This breakdown is reflected citywide, according to Greenberger.
Data Set: https://www.divvybikes.com/data
Divvy’s Data Portal