Category: Cities

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.

Is this the sign of things to come for the CTA?

The Mayor of Chicago has considerable influence over the Chicago Transit Authority. Mayor-elect Rahm Emanuel let Chicagoans know on Tuesday, April 19, 2011, partially how he intends to wield that influence. This post is a look into the recent announcements regarding transit in Chicago.

1. Forrest Claypool “appointed” as CTA president*

During the press conference, Rahm had some choice words and expended a little of his still-growing political capital:

He shares my belief that (the CTA) is our most critical piece of infrastructure. Forrest has the experience to capitalize on the CTA’s strengths and the creative mind to guide its future.

He didn’t mention our roads, highways, or airports. While Mayor Daley may have shirked finding the best funding solutions for the Chicago Transit Authority, saying it’s the state legislature’s responsibility, Rahm and his choice for president staking a bigger role in leading the CTA. Chicago Tribune, April 19, 2011

2. Gabe Klein at CDOT

The Chicago Department of Transportation supports the CTA in many respects. It owns the downtown subways and subway stations. It can renovate or build stations for the CTA. For example, CDOT is currently renovating the Grand/State Red Line station and building the completely new Morgan/Lake Green/Pink Line station. Gabe is a very transit-friendly DOT commissioner. In Washington, D.C., he helped launch a streetcar project to supplement the city’s bus and subway networks.

Robert Thomson, or “Dr. Gridlock” from the Washington Post, defended Klein from a letter writer with a windshield perspective on traveling within the city:

Klein was trying to restore an old balance that would allow everyone to move around more easily. “People think about having to move X number of cars,” he said. “We’ve tried to think about how we’re moving people. . . . We want to provide people with attractive choices.” Washington Post, December 11, 2010 (just days after Gabe announced his resignation)

3. Ray LaHood and the Red Line Extension

Rahm says he’s gung ho about extending the Red Line from 95th to 130th, a project that will cost over $1.2 billion. The plans are waiting for funding. On his campaign website, Rahm expressed his interest in the project: “Rahm will make it a major priority of his administration” and mentioning how he would leverage every available funding opportunity to get it built.

During his visit on Thursday to Chicago, reporters asked U.S. Department of Transportation Secretary Ray LaHood about funding this project. As I expected, he offered no clear answer:

LaHood made no commitment to fulfill Mayor-elect Rahm Emanuel’s stated plan to line up federal funding in his first year in office to extend the south branch of the CTA Red Line from its current terminus at 95th Street another 5.5 miles to 130th Street. [LaHood said he] would invite incoming CTA President Forrest Claypool and Gabe Klein, whom Emanuel selected to head the Chicago Department of Transportation, to Washington to lay out their project priorities and present cost estimates for the work. Chicago Tribune, April 21, 2011

Currently, the CTA has not applied for funding for this project so Ray couldn’t provide any different answer.

See all of my 500+ Chicago Transit Authority photos.

*It should be noted that the Transit Act requires the board to choose the president, not the Mayor of Chicago. From (70 ILCS 3605/27) (from Ch. 111 2/3, par. 327): “The Board may appoint an Executive Director [president] who shall be a person of recognized ability and experience in the operation of transportation systems to hold office during the pleasure of the Board. The Executive Director shall have management of the properties and business of the Authority and the employees thereof, subject to the general control of the Board…”

You may have heard me on the radio this morning in Chicago

Here’s the audio clip of my interview with WGN 720 AM producer Rob Hart about biking in Chicago and the bike crash map I made. It aired this morning – I had no idea until someone left me a comment on a Flickr photo that they heard me.

Listen now: Steven Vance on biking and bike crashes in Chicago on WGN.mp3 (will play in your browser).

I am too nervous to listen to this. I’m sure I said something wrong or misspoke.

Biking in Chicago is fun and you should do it. You don’t need special gear or equipment and you can buy a cheap bike at Working Bikes in Pilsen, at 2434 S Western Avenue.

Transcript

[ding, ding]

A little bell may be what comes to mind when you think of riding your bike, but the reality is more like this.

[sounds of traffic]

A busy street full of cars, trucks, and buses. With drivers who are looking at something else.

Me: There’s a lot of driveways. A lot of drivers are making right and left turns and if you ride too close to the curb they will probably not see you, so you have to ride sometimes outside the bike lane if you want to be noticed.

Steven Vance ditched his car 5 years ago. He rides his bike all over the city and he says sometimes it’s a white knuckled experience.

Me: It can be. It does take a little bit of resolve. Sometimes your nerves will get frayed, but I think the benefit outweighs the cost.

After a newspaper [Bay Citizen] in San Francisco mapped out bike crashes on its website, Vance decided to plot bike crashes in the Chicago area on his.

Me: I saw that, and I thought, “You know what, I think I can do that.” I asked the Illinois Department of Transportation for the data and they promptly sent it over and I, as quickly as possible, put it online.

The diagonal streets are the worst, he found, and that includes Milwaukee Avenue.

Me: You could find Milwaukee just by the number of dots representing the crashes. You didn’t need a label to say that this was Milwaukee Avenue. You could tell simply by the string, the constant string of dots.

 

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.”

The stories the IDOT automobile crash data can tell

Lots of stuff to learn from the 2007-2009 car crash data, with 309,425 crash reports.

What I noticed

  • SUV drivers do not cause all crashes, contrary to some stereotypes. That vehicle type (for both vehicle 1 and vehicle 2) is only involved in 45,776 crashes (14.79% of all crash reports)
  • The vehicle type most commonly involved in crashes is “personal passenger,” with 294,941 “personal passenger” vehicles involved in 208,888 crashes (67.51% of all crash reports)
  • 1,465 crash reports report “unknown” for both vehicle 1 type and vehicle 2 type (0.47% of all crash reports)
  • 61,645 crash reports have vehicle 1 hitting a parked car (19.92% of all crash reports)
  • There were 16,554 taxis involved in 15,223 crashes (4.92% of all crash reports). And there were 1,311 “taxi on taxi” crashes (0.42% of all crash reports)
  • 3,861 CTA transit buses (that can hold more than 15 passengers) were involved in 3,853 crashes (1.25% of all crash reports). And there were 8 “bus on bus” crashes (0.003% of all crash reports)
  • 1,644 school buses were involved in 1,635 crashes (0.53%). And there were 9 “school bus on school bus” crashes (0.003% of all crash reports)

Data does not include estimated cost of property damage.

Not all vehicles may be unique – some vehicles may be involved in more than one crash.