Tag: data

Two new beta apps for Chicago geography

I think 2011 is going to be the year of apps for me. I developed one for bikes and one for politics.

Bikes

I made the “Chicago Bike Data Portal” app on Saturday night. It gets your location via the HTML5 geolocation API and loads a list and map of all the reported bike crashes within half a mile. It works on some mobile phones, too (at least Android and iOS). Expect to see more data in the future, like ped and automobile crashes.

Politics

Then on Monday I made an app called, “Who is my Chicago Alderman?” where people can type in their address (or any address) and retrieve the alderman’s name, addresses, and phone numbers. I’ve already identified a problem where the app returns the wrong information for an address. I think this is a problem with the geocoder. Ever since CivicFootprint (a project of Center for Neighborhood Technology) disappeared, the city’s been missing an easy-to-use app for finding alderman. The city clerk’s website takes too long to use and is not as informative.

Other apps I built or worked on

Commuting rates in Chicago – a conversation

I had this conversation last night with a friend from Chicago. Enjoy. Data is from the American Community Survey, Table S0801. If you were to rate how much we bike, from a “typical Chicagoan’s” point of view, he would be “eccentric” and I would be “psychotic.”

Photo by Joshua Koonce.

Me
A friend of mine in Europe asked for bicycle commuting statistics for Chicago.
Man, the numbers were sad.

Friend
No shit.

Me
if we look at the 3-year estimates for work trips, then it’s
-2005-2007: 0.9%
-2006-2008: 1.0
-2007-2009: 1.1

Friend
Chicago is also a gigantic, sprawling modern city of hundreds of square miles and wide roads designed for masses of cars.

Me
And if we look at the 1-year estimates, which Matt argued on my blog are useless, it’s
-2005: 0.7%
-2006: 0.9
-2007: 1.1
-2008: 1.0
-2009: 1.1
The 3-year estimate has a MOE of ±0.1 so essentially, it could mean no change from year to year.
And the 1-year estimate has a MOE of ±0.2, so again, it could mean no change from year to year
UGH

Friend
Comparatively, old European cities don’t have a lot of bandwidth for autos and have density where people take short trips.
That’s still probably two or three times the distance people in Copenhagen or Cambridge or Amsterdam.

Me
So let’s say 50% of trips are 5 miles or less, and 25% of trips are 2.5 miles or less.
Yet 1% of all trips are taken by bike
If we could just DOUBLE that, it would be a miracle
The Bike 2015 Plan’s goal is to have 5% of all trips under 5 miles by bike.

Friend
That’s an ambitious goal.

Me
We don’t have any baseline data to show how many trips under 5 miles in 2006, at the inception of the Bike 2015 Plan, are by bike. In the end, we’ll never know if our ambitious goal was attained!

TransportationCamp West

TransportationCamp West was an unconference that took place on March 19th and 20th in San Francisco at Public Works SF and other locations (restaurants, the street, online).

I only went on Saturday and attended four topic sessions (view the full schedule with 28 topic sessions). These are the writeups of my notes and links to others’ writeups.

My writeups

Others’ writeups

Better bike crash map now available for Chicago

I met Derek at a get together for “urban geeks” last Tuesday where he told me he was making a filterable/searchable version of my Chicago bike crash map using the Google Fusion Tables API. It essentially allows you to perform SQL-like queries to show different results on the map than one view. It’s possible to do this yourself if you open the bike crash map in the full Google Fusion Tables interface (do that now).

You can use it now!

New bike crash map, click through to view

Derek’s map has the benefit of great interface to drill down to the data you want. You can select a day, a surface condition, and the injury type. To download the data yourself, you’ll still have to access the full Fusion Tables interface.

Door lane photo and graphic by Gary Kavanagh in Santa Monica, California.

And since the data is the same as my original map, crash reports involving motor vehicle doors are not included. Here’s why doorings are excluded.

Why the Chicago bike crash map doesn’t show doorings

The data on the Chicago bike crash map comes from the Illinois Department of Transportation (IDOT) after reports are made to the Chicago Police Department, but it’s missing certain types of crashes. IDOT currently will not collect data about doorings.

Some Chicago cyclists created this sticker to alert drivers and their passengers to the dangers of the door. “Someone opened a door and killed my friend.” This is version 1 of the sticker; see version 2. Photo by Quinn Dombrowski.

Here’s a summary of the process:

1. Police officers make the reports

Chicago police officers collect information on dooring (outlawed by MCC 9-80-035) because of a recent agreement with the Chicago Department of Transportation (CDOT) – the importance of reporting doorings became a bigger priority after someone died after being doored on LaSalle Street in 2008.

When there is a dooring, Chicago police officers use an “Additional Units Form” in addition to SR-1050 (standard reporting form for Illinois motor vehicle crashes) and write “dooring” where the IDOT barcode would be on the Additional Units Form.

2. How the Chicago Police Department records it

When the Chicago Police Records Office sees that there’s no barcode they know they can’t send it to IDOT, but they see “dooring” and scan it for their own records (so they can provide it to crash parties later) and then email that number to the CDOT Bicycle Program. (There was a general order put out by CPD on this procedure and, yes, they actually send them– at least some of them.)

The CPD also knows that doorings, according to IDOT, are not a “reportable” crash. In addition to doorings, IDOT doesn’t consider the following as “reportable” crashes:

  • Any crash in which the first point of impact does not involve a moving motor vehicle.
  • Any non-injury crash which causes less than $1500 in property damage, unless one or more of the drivers was uninsured.

3. CDOT and Chicago Police Department connect

CDOT can then connect to the Police Departments records system, download a scan of the crash report, reads it and enters specifics into a tracking spreadsheet.

This is how dooring data is collected in Chicago because IDOT will throw away reports or attachments without barcodes. This should change. This process affects ALL cities in the State of Illinois but as far as I’m aware, only Chicago records doorings. It’s unfortunate that local agencies are forced to bear this additional task and provide special training for thousands of officers outside of statewide practices because IDOT doesn’t acknowledge the importance of this issue and revise its reporting policy.

Below is the SR-1050 form and you can see the IDOT barcode with the case number below it. The bike and pedestrian crash data I have from IDOT includes those case numbers.

Read more about doorings on Grid Chicago.