Category: Transportation

Best ways to present bicycle crash data

I started some preliminary work on my crash reporting tool. I haven’t written any code, but I’ve been working on the logistics of analyzing and presenting the data to the public.

I obtained bicycle crash data for 2009 from the Illinois Department of Transportation’s Division of Traffic Safety. I’m not able to distribute raw data (you’ll have to ask for it yourself) and Illinois statutes prevent me from distributing personally identifying data (but it’s really hard to know what this is). In the meantime, based on Ben Sheldon’s suggestion, I loaded some of the data into a private Google Fusion Table that instantly maps geocoded data (it can also geocode the data for you).

Richard cautions me about way I choose to present data. I need to choose terms and descriptions carefully to avoid misinterpretations. Pete from the Boston Cyclist’s Union recommends against accepting self-reported data. I’ll be taking their advice into consideration as I move forward.

You see in the map (top) that a lot of crashes happen on Milwaukee Avenue (above). That’s where a lot of people ride (over 3,000 in 24 hours in the fall).

I have not begun to review the narrative details in the crash reports. Actually, they’re not very narrative because they’re fixed responses – no free writing allowed. And not every record represents a collision (meaning a crash with at least two parties). Many are self-crashes (is that a legit phrase)?

I’m not sure exactly what story I want the data to tell so it will probably be a while before I make anything public. One of my favorite geographic information books, Making Maps, talks about the endless ways maps can be designed and portrayed and that each tells a different story. It’s best if I know the story (a goal) ahead of time.

Another case for integrating biking and transit

Integrating biking and transit can reduce a user’s transportation costs.

A friend just instant messaged me to describe his “bike instead of transit” commute,

“I spent $440 on Chicago Transit Authority (CTA) this year and $300 on bike stuff. When I was just taking the CTA it was $1032 per year. I used to have the monthly pass deducted from my paycheck, $86 per month. Now I pay as a I go, and I go much less.”

In some places, and for other people’s situations, commuters could bike TO the train or bus and reduce their costs by eliminating a transfer. Transit also lengthens a bike rider’s possible trip distance when they combine the modes. In this sense, providing services or facilities for people riding bikes attracts new customers or maintains relationships with existing customers.

The Department of Transportation is now funding projects that improve bicycling (and walking) connections to bus and train stations. We should continue focusing on expanding and improving our bikeway networks by connecting them with our transit networks. By doing so, we make each system more robust and give people more options to choose the route that’s best for them.

Boarding northbound Caltrain at Palo Alto University Avenue station.

Some buses can hold three bikes (see Seattle and Silicon Valley). Highway 17 Express bus Santa Cruz bound at San Jose State University stop. Photos by Richard Masoner.

I Love Riding In the City

The magazine Urban Vélo features cool people in every issue who filled out this form. I don’t want to miss any opportunity to become famous in print! Here are my answers to the form:

Your Name

Steven Vance

Location

Chicago, IL

Occupation

Blogger.

Where do you live and what’s it like riding in your city?

I live in Bridgeport, a cool neighborhood a couple miles south of the Loop. I love riding in the city, but preferably at night when fewer people are driving. Weekends are annoying because the traffic changes – shopping is the name of the game and it makes for a different transportation environment. I want the city to construct protected bike lanes.

What was your favorite city to ride in, and why?

Portland, Oregon. Because there were so many other people riding. Riding a bike to get around was the normal thing to do – I didn’t get honked at or told to ride on the sidewalk. The grocery store I visited had their bike parking with 10 feet of the entrance. I was riding with a crowd of other bike people biking at 1 AM on a weekday.

(Dang it, now I’m wondering if New York City was my favorite city to ride in. NYCDOT has been throwing down bike lanes left and right in all boroughs for 4 years straight now. But I think Portland wins out because of its calm.)

Why do you love riding in the city?

It’s a lot easier than riding in the suburbs.

Or just say whatever you want about riding in the city… Poetry anyone?

If you need a ride, I’ll give you a seat on the back of my Yuba Mundo. No charge.

I submitted this photo with my application.

As far as bicycle magazines I know about go, they can be compared to conditions of the city like so:

  • Suburbs – Bicycling Magazine – boring, bland, the same every month. Thumbs down.
  • Urban – Momentum Magazine – diversity, families, becoming a more popular and convenient place to live. Thumbs up.
  • Hyperlocal – Urban Vélo – getting down to the nitty gritty, who lives here? who lives there? who does what? Thumbs up.

November snow

November snow photo by the Washington State Department of Transportation (WsDOT).

I rode this train, the Amtrak Cascades, from Portland to Seattle, but in April 2010. I would love to go back and ride it again, through the snow this time. It looks so beautiful.

I commend the Washington State Department of Transportation for its good presence on social media and social networking websites. I’m tracking where other DOTs are online.

I want to make a crash reporting tool

UPDATE 12-01-10: Thank you to Richard Masoner for posting this on Cyclelicious. I have started collecting everyone’s great ideas and responses in this development document.

Hot off the heels of making my “Can I bring my bike on Metra right now?” web application, I am ready to start on the next great tool*.

I want to create a bicycle crash reporting tool for Chicago (but release the source code for any city’s residents to adopt) along the lines of B-SMaRT for Portlanders and the Boston Cyclist’s Union crash map based on 911 calls.

I’d rather not reinvent the wheel (but I’m very capable of building a new web application based in PHP and MySQL) so I’ve been trying to get in contact with Joe Broach, the creator of B-SMaRT, to get my hands on that source code.

Not exactly the type of crash I’ll be looking for. Photo by Jason Reed.

I want the Chicago Crash Collector (please think of a better name) to have both citizen-reported data, and data from police reports. I just sent in my FOIA request for police data to the Chicago Police Department, but I’m not holding my breath for that.