Tag: Chicago

Rambling about automobile crash data and cellphone distraction

How often do bicyclists get involved with crashes because of cellphone distraction? See the table below. And how many crashes are caused by the bicyclist being distracted by a cellphone? We won’t and don’t know. 

The Chicago City Council will vote tomorrow on ordinance 02011-7146 to add a new section in Chapter 9 of the Municipal Code of Chicago: “9-52-110 Use of communication devices while operating a bicycle.”

In a Chicago Sun-Times article today, Matthew Tobias, the Chicago Police Department’s deputy chief of Area 3 patrol, reported on the number of citations that the department has issued to drivers in violation of the cellphone ban: “from 2,577 administrative violations in 2008 to 10,920 in 2009 and 19,701 last year” (known as “citations issued” in the table below).

I looked at the crash data to see how many crashes were coded as having been caused by “Distraction – operating an electronic communication device (cell phone, texting, etc)”.

Out of 274,488 recorded crashes in 2008, 2009, and 2010, there were 331 crashes which had a Cause 1 or Cause 2 of “Distraction – operating an electronic communication device (cell phone, texting, etc)”. The table below compares the rates of crashes to the rates of citations issued and the number of crashes that the police noted were caused by cellphone distraction. It also shows the number of these “cellphone distraction” crashes that involved bicyclists and pedestrians.

Year Citations issued Automobile crashes Cellphone distraction crashes % of cellphone distraction crashes Involved with bicyclists? Involved with pedestrians? National VMT (billions)*
2008 2577 111,701 91 0.081 3 10 2973.47
2009 10920 81,982 130 0.159 1 7 2979.39
2010 19701 80,805 110 0.136 6 8 2999.97

Maybe this data shows that the increased enforcement is causing fewer crashes?
However data for cyclists’ involvement in crashes and their cellphone use WON’T BE recorded unless there’s a rule change as the cause is only recorded for the vehicle involved in the crash, and bicycles are devices, not vehicles.

None involved fatalities.

*Yep, that’s 2 thousand billion. Read it like this, 2 trillion 973 billion and 470 million. VMT data from Bureau of Transportation Statistics.

Using Google Fusion Tables to create individual Chicago Ward maps

I wanted to create a map of the 35th Ward boundaries using Google My Maps for a story on Grid Chicago. I planned to create this by taking the Chicago Wards boundary shapefile and exporting just the 35th Ward using QGIS into a KML file. I ran into many problems and ended up using Google Fusion Tables as the final solution.

The problems

First, QGIS creates invalid KML files. Google Earth will tell you this. I opened the KML file in a text editor and removed the offending parts (Google Earth mildly tells you what these are; you can use this validator to get more information).

Second, Google My Maps would not import the KML file. I tried a different browser and a different KML file; a friend ran into the same issue. I reported this problem to Google.

The solution

I uploaded to Google Fusion Tables a KML file containing all wards. I did this instead of uploading the single Ward because, like a database, I can filter values in the column, selecting only the row I want with “ward=35”.

After applying the filter, the map will show the boundary for just that ward. I grab the HTML code for an embeddable map and voila, the article now displays an interactive map of the 35th Ward.

Whenever I want to create a map for a different ward, I go back to this Fusion Table, make a new filter and copy the new HTML code.

A screenshot of the embedded map, showing just 1 of 50 wards, in the Grid Chicago article. 

Elsewhere

I had the same problems with QGIS exporting and uploading the KML files to My Maps the other day when I was creating maps for the abandoned railroads for Monday’s Grid Chicago article. Not thinking about Fusion Tables, I drew on the map with my mouse the lines.

Screenshot of the map of abandoned railroads. 

On sucker poles

Twice in the past seven days I’ve encountered an unsecured sucker pole.

A sucker pole next to a highly-secure bike rack provided by the City of Chicago’s Bicycle Program. The adjacent placement of the two fixtures is an unfortunate side effect of construction crews who didn’t receive guidance on bike rack placement. 

What’s a sucker pole? Any sign pole that’s not embedded in concrete or securely fastened to the ground in another fashion. A simple hex nut on a bolt fastens the pole to the base.

So last Saturday I encountered my latest one in front of India House (59 W Grand), just hours after Alexis Finch of Thought You Knew pinup calendar fame mentioned a specific sucker pole at the Green Eye (2403 W Homer) – I could completely remove the pole from its base.

Alexis reported that when she visits that bar, she removes the pole from its base and lays it on the sidewalk to prevent others from locking their bikes there.

I want you to spread the word about sucker poles while at the same time requesting a bike rack for that spot. I invite designers to remake this crappy poster I created and thankfully never printed.

Remake this “beware of sucker poles” poster into something cool and I’ll pay to print a few copies for you to keep and give to friends or bike shops.