Tag: safety

Initial intersection crash analysis for Milwaukee Avenue

Slightly upgraded Chicago Crash Browser

This screenshot from the Chicago Crash Browser map shows the location of bike-car collisions at Ogden/Milwaukee, an intersection that exemplifies the yellow trap problem the city hasn’t remedied.

List of the most crash-prone intersections on Milwaukee Avenue in Chicago. Using data from 2007-2009, when reported to the Chicago Police Department. Dooring data not included on the bike crash map. I used QGIS to draw a 50-feet buffer around the point where the intersection center lines meet.

Intersecting street (class 4*) Bike crashes
Chicago Avenue (see Ogden below) 12 (17)
California Avenue 9
Halsted Street & Grand Avenue 7
Damen Avenue & North Avenue 6
Western Avenue 6
Ogden Avenue (see Chicago above) 5 (17)
Ashland Avenue 5
Diversey Avenue 5
Fullerton Avenue 5
Elston Avenue 5
Augusta Boulevard (not class 4) 5

Combine the six-way (with center triangle) intersection of Ogden, Milwaukee, Chicago, and you see 17 crashes. Add the 6 just outside the 50-feet buffer and you get 23 crashes. Compare this to the six-way (without center triangle) at Halsted, Milwaukee, Grand, where there’s only 7 crashes.

What about the two intersections causes such a difference in crashes? Let’s look at some data:

Ogden, Milwaukee, Chicago Halsted, Milwaukee, Grand
Automobile traffic Approx 58,000 cars per day Approx 50,000 cars per day.
Bicycle traffic Not counted, but probably fewer than 3,100 bikes More than 3,100 bikes per day*
Bus traffic Two bus routes Three bus routes
Intersection style Island; three signal cycles No island; one signal cycle

*Notes

Traffic counts are assumed estimates. Counts are taken on a single day, either Tuesday, Wednesday, or Thursday. Bike counts at Halsted/Milwaukee/Grand were actually taken on Milwaukee several hundred feet northwest of the intersection so DO NOT include people biking on Halsted or Grand! This means that more than 3,100 people are biking through the intersection each day.

Intersection style tells us which kind of six-way intersection it is. At island styles you’ll find a concrete traffic island separating the three streets. You’ll also find three signal cycles because there are actually three intersections instead of one, making it a 12-way intersection. Also at these intersections you’ll see confusing instructional signage like, “OBEY YOUR SIGNAL ONLY” and “ONCOMING TRAFFIC HAS LONGER GREEN.”

These intersections are more likely to have a “yellow trap” – Ogden/Milwaukee definitely has this problem. The yellow trap occurs at that intersections when northbound, left-turning motorists (from Milwaukee to Ogden) get a red light but they still need to vacate the intersection. Thinking that oncoming traffic has a red light but are just being jerks and blowing the red light (when in fact they still have a green for 5-10 more seconds) they turn and sometimes hit the southbound traffic. The City of Chicago acknowledged this problem, for bicyclists especially, in summer 2013 but as of November 2014 the issue remains.

Here’s a more lengthy description of one of the problems here as well as an extremely simple solution: install a left-turn arrow for northbound Milwaukee Avenue. The entire intersection is within Alderman Burnett’s Ward 27.

Source and method

I can’t yet tell you how I obtained this data or created the map. I’m still working out the specifics in my procedures log. It involved some manual work at the end because in the resulting table that counted the number of crashes per intersection, every intersection was repeated, but the street names were in opposite columns.

Crash data from the Illinois Department of Transportation. Street data from the City of Chicago. Intersection data created with fTools in QGIS. To save time in this initial analysis, I only considered Milwaukee Avenue intersections with streets in the City of Chicago centerline file with a labeled CLASS of 1, 2, or 3.

Using Google Refine to get the stories out of your data

Let’s say you’re perusing the 309,425 crash reports for automobile crashes in Chicago from 2007 to 2009 and you want to know a few things quickly.

Like how many REAR END crashes there were in January 2007 that had more than 1 injury in the report. With Google Refine, you could do that in about 60 seconds. You just need to know which “facets” to setup.

By the way, there are 90 crash reports meeting those criteria. Look at the screenshot below for how to set that up.

Facets to choose to filter the data

  1. Get your January facet
  2. Add your 2007 facet
  3. Select the collision type of “REAR END” facet
  4. Choose to include all the reports where injury is greater than 1 (click “include” next to each number higher than 1)

After we do this, we can quickly create a map using another Google tool, Fusion Tables.

Make a map

  1. Click Export… and select “Comma-separated value.” The file will download. (Make sure your latitude and longitude columns are called latitude and longitude instead of XCOORD and YCOORD or sometimes Fusion Tables will choke on the location and try to geocode your records, which is redundant.)
  2. Go to Google Fusion Tables and click New Table>Import Table and select your file.
  3. Give the new table a descriptive title, like “January 2007 rear end crashes with more than 1 injury”
  4. In the table view, click Visualize>Map.
  5. BAM!

I completed all the tasks on this page in under 5 minutes and then spent 5 more minutes writing this blog. “The power of Google.”

Do you want this facility? Where?

Take a look at this protected two-way bike lane in Brooklyn, New York City.

Some people are suing to remove (or change it). If you’re someone who doesn’t live there, here’s why this fight could still be important for you. Or maybe you want to know why the bike lane was installed.

If your city’s transportation or public works department proposed a protected bike lane or cycle track for your town, where should the first one go?

I propose 11 locations for Chicago (see link for ideal segments):

  • Blue Island Avenue
  • Chicago Avenue
  • Fullerton Avenue
  • Grand Avenue
  • Halsted Street (in some discrete locations)
  • King Drive (connecting downtown/South Loop to Bronzeville, Hyde Park, Washington Park)
  • Ogden Avenue (the entire street, from the city boundary on the southwest side to its dead end at the Chicago River near Chicago Avenue)
  • Wabash Street (connecting downtown and IIT)
  • Washington Boulevard/Street
  • Wells Street – this may be one of the easiest locations to pull off, politically at least, especially if Alderman Reilly pays for all or part of it with his annual appropriation of $1.32 million (“menu funds”).
  • Western Avenue

    Notice how I didn’t propose Stony Island. Here’s why.

    P.S. This will not be like the case of high-speed rail in America, where if one governor refuses money for an HSR project, other governors can compete for that money. The Prospect Park West bike lane will not be picking up and moving to another state 😉

    Look at all that room for people to go about their business, whether by car, bike, roller skates, wheelchairs, or their own two feet. Photos by Elizabeth Press.

    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.