Category: Transportation

The power of the letter

If you want something changed, chances are you’re going to have to write to someone about it.

I wanted a few things changed last year. I first wanted Dominick’s (Safeway) to install a bike rack at their store after they removed the shopping cart gates (which was doing a decent job of serving as bike parking). If you follow the blog, you saw the positive results from my letter to the CEO. When you want something done and you need someone else to do it, the first step is to tell someone (like calling 311 to report a pothole). But even that has its own prerequisites: You have to know what to say and who to say it to.

A friend and I wanted a bike lane “pinch point” removed from Halsted just north of the 16th Street BNSF viaduct that separates University Village and Pilsen. It wasn’t just us who wanted it out, though. We talked to our friends and I talked to some bike shop employees – they were aware of the issue and supported its removal.

It’s in the 25th Ward – my friend lives in the 25th Ward but at the time I lived in the 11th Ward). So he sent a letter explicitly and calmly describing the problem and a proposed solution to Alderman Danny Solis (now in a runoff against Cuahutemoc Morfin), cc’ing Mayor Richard M. Daley, and Ben Gomberg, coordinator of the Bicycle Program.

Demonstrating the pinch point. Not as dramatic as it is when there’s a bus or semi-truck or when the driver doesn’t drive as far to the left.

A before and after photo showing where cars could legally park and now where they cannot. The City added a tow zone sign next to the “no left turn” sign to mostly eliminate the pinch point at the start of the bike lane.

“Fast” service

The letters were mailed on October 13, 2010. The sign was installed on or before December 13, 2010. The change was felt immediately. Drivers simply stopped parking their cars in the newly created tow zone and the bike lane and this part of Halsted Street became just a little bit more pleasant to use – so thank you, Alderman Solis!

I’m finally writing this blog to tell you about the experience on March 4, 2011. Sorry – I got delayed!

You asked for it, you got it – Chicago bike count data

Note: This post doesn’t have any analysis of the data or report, nor do I make any observations. I think it’s more significant to hear the ideas you have about what you see in the map or read in the data.

A lot of people wanted the Chicago bike crash and injury data overlaid with bike counts data.

In 2009, Chicago Department of Transportation (CDOT) placed automatic bike counting equipment at many locations around the city. It uses pneumatic tubes to count the number of bicyclists (excludes cars) at that point in the street – it counts ALL trips, and cannot distinguish between people going to work or going to school. This is dissimilar from Census data which asks respondents to indicate how they go to work.

Well, good news for you! CDOT today released the bike counts report from data collected in 2009 (just in time). There has been overwhelming response about the bike crash map I published – this shows how rabid the public is for information on their environments (just yesterday someone told me that they switched bike routes based on the crash frequency they noticed on their original route).

The size of the blue dot indicates the bicycle mode share for that count location. Mode share calculated by adding bikes and cars and dividing by bikes.

Get the data

A photo of the EcoCounter counting machine in action on Milwaukee Avenue (this was taken during testing phase, where CDOT compared automatic and manual counts to determine the machine’s accuracy).

How to use this map:

  1. Find a blue dot (count location) in an area you’re interested in.
  2. Zoom into that blue dot.
  3. Click on the blue dot to get the number of bikes counted there.
  4. Then observe the number of purple dots (crashes) near that count location.

What do you see that’s interesting?

What else is coming?

Now let’s hope the Active Transportation Alliance and the Chicago Park District release their Lakefront Trail counts from summer 2010. CDOT may have conducted bicycle counts in 2010 as well – I hope we don’t have to wait as long for that data.

I hope to have a tutorial on how to use GeoCommons coming soon. You should bug me about it if I don’t post it within one week.

Photos of Chicago bike commuters by Joshua Koonce.

Bike crash map in the press

Thank you to the Bay Citizen, Gapers Block, and the Chicago Bicycle Advocate (lawyer Brendan Kevenides). They’ve all written about the bike crash map I produced using Google Fusion Tables. And WGN 720 AM interviewed me and aired it in April 2011.

View the map now. The map needs to be updated with injury severity, a field I mistakenly removed before uploading the data.

The Bay Citizen started this by creating their own map of bike crashes for San Francisco, albeit with more information. I had helped some UIC students obtain the data from the Illinois Department of Transportation for their GIS project and have a copy of it myself. I quickly edited it using uDig and threw it up online in an instant map created by Fusion Tables.

A guy rides his bicycle on the “hipster highway” (aka Milwaukee Avenue), the street with the most crashes, but also has the most people biking (in mode share and pure quantity).

Why did I make the map?

I made this project for two reasons: One is to continue practicing my GIS skills and to learn new software and new web applications. The second reason was to put the data out there. There’s a growing trend for governments to open up their databases, and your readers have probably seen DataSF.org’s App Showcase. But in Chicago, we’re not seeing this trend. Instead of data, we get a list of FOIA requests, or instead of searchable City Council meeting minutes, we get PDFs that link to other PDFs that you must first select from drop down boxes. But both of these are improvements from before.

I would love to help anyone else passionate about bicycling in Chicago to find ways to use this data or project to address problems. I think bicycling in Chicago is good for many people, but we can make it better and for more people.

Read the full interview.

Why did women in Chicago stop bicycling to work? And other stories about data

Why did women in Chicago stop bicycling to work?
Or is our data unreliable?

Showing relative cycling-to-work rates between 2005 and 2009 in Chicago. Data from table S0801 in American Community Survey, 1-year estimates. Read the comments on this post for why this is not the best data source – 3-year estimate shows same decline in women cycling to work.

Note: The sample size is puny – data was collected from 80,613 housing units in Illinois. I don’t know how many of those were in Chicago (and we have 1,063,047 housing units). The American Community Survey only collects data on transportation modes to work for ages 16 and up.

But we simply have no other data! Maybe the Chicago Metropolitan Agency for Planning can release the Chicago data they collected for the 2008 household travel survey to show us bicycling rates for all trip purposes (they divided the report into counties). The sample size would still be small, but we could compare the work rates to find some support between the datasets.

We should look into how New York City counts bicycling as an additional way to gauge trends in Chicago (it has limitations of geography and area).

They conduct two types of counts. The first is the screenline count for bridges, Staten Island Ferry, the Hudson River Greenway, and all Avenues at 50th Street. They do this three times per year. Then, seven more times a year, they count at the same places (except the Avenues) from April to October.

While this data does not give them information on who cycles in the boroughs, it does give them a good indicator of cycling levels in Manhattan. It also disregards trip purpose, counting everyone going to work, school, or for social activities.

Sidenote: The New York Police Department will begin making monthly statistical reports on bicycle crashes in the city.

Interview with Bay Citizen on bike crash map

Thank you, Tasmeen, for asking about my bike crash map that your newspaper inspired me to create.

Read the interview.

Read about the bike crash map for Chicago.

View the bike crash map for Chicago (2007-2009).

It’s not this sunny yet, but today it was 49°F in Chicago. This photo was taken on Milwaukee Avenue, where the most people bike, and where the most people have bike crashes.