Category: Information

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.

Converting Google My Maps to KML and GPX

Convert your routes that you made in Google My Maps to GPX so that you can view them on Garmin GPS devices, or upload them to MapMyRide.

  1. Access your My Map. Your My Map must have lines or routes in it. It appears that a My Map with only points doesn’t convert correctly.
  2. Click on View in Google Earth. Your web browser will download a KML file. It may automatically open in Google Earth, but this is not necessary.
  3. Visit GPS Visualizer to convert your KML file to GPX
  4. Select GPX as your output.
  5. For the input, choose the KML file you just downloaded from Google My Maps.
  6. Click Convert. Your file will be uploaded and your GPX file will be presented for download on the next page.
  7. Download your GPX file from the link on the page.

You can now transfer the GPX file to your GPS device, or upload it to MapMyRide. I confirmed that MapMyRide successfully imports the Google My Map I converted following these instructions.

The faces of Midwest urban innovation

From the UPPSA-sponsored Urban Innovation Symposium at University of Illinois at Chicago on Friday, February 4, 2011. See all 22 photos.

Informatics in health care

Dr. Annette L. Valenta
Professor
Biomedical and Health Information Sciences, UIC

Deconstruction and reusing building materials to reduce waste

Elise Zelechowski
Deputy Executive Director
Delta Institute

Let nature handle our waste water systems instead of circumventing it

James Patchett
President and Founder
Conservation Design Forum

Community-driven planning – sometimes you can excuse the City’s input

Marcia Canton Campbell
Director of Center for Resilient Cities in Milwaukee

Break out of the organization chart, let innovation rise from anywhere

Aaron Renn
Urban issues blogger