Page 117 of 172

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.

Some lessons learned in bike parking placement at train stations

Flickr user Jeramey posted the photo below showing empty bike racks inside the Damen Blue Line station in Wicker Park, Chicago. He took it on Wednesday, April 14, 2010, when the high temperature was 82°F – good riding weather.

He linked to a photo taken in July 2009 showing the full bike racks inside the Sox-35th Red Line station in Bridgeport/Bronzeville. It’s hot in July as well.

Both bike racks were installed in the same project in 2009. Two other stations received high-capacity bike racks: Jefferson Park Blue Line, and Midway Orange Line.

Jeramey’s implied question is, “Why are people using Sox-35th bike racks, but not Damen bike racks?” I have some hypotheses.

Damen Blue Line station bike racks

1.  The number of physical barriers someone with a bicycle must cross to access this space is too high. First there’re the narrow doors to the station house; second is the gate that must be unlocked by the station attendant (but is often found unlocked);third is the stairs; fourth is the high frequency of passengers in the staircase and first landing that the passenger with a bicycle must navigate through.

2. The lack of knowledge about this parking space’s existence. While there are small signs pointing towards these bike racks, they are easily ignored. Additionally, people riding bikes in Chicago tend not to look for signs as bike parking is almost always in view of the final destination (this is one of the rules of successful bike parking).

3. There is often available bike parking outside the station house. If the racks outside are available, those are more convenient. See hypothesis 1.

4. The station is too close to downtown, the destination of a majority of people bicycling to work. Instead of biking to the train station, they ride directly to work without riding the CTA. This map shows where people who bike to work call home and where they work. To test this hypothesis, I think some usage counts should be taken on multiple days per season. Expected results: In colder weather, people would combine modes and ride to the station and then to work. In warmer weather, they would only ride their bicycle.

Sox-35th Red Line station

Now let’s look at the Sox-35th Red Line station bike racks in the same categories.

1. No barriers. The station is newer, has wide doors, no stairs, and a wheelchair turnstile that people with bikes can use.

2. No need for signage or direction. As soon as one enters the station, the bike racks are visible.

3. They’re the only bike racks available. You can’t park securely outside the station house.

4. The route between Sox-35th and the center of Chicago is not as bike friendly as that between Damen and downtown. Milwaukee Avenue offers a direct connection between Damen and downtown, a critical mass of other people bicycling, and bike lanes for a majority of the length. State Street is the most direct to downtown from Sox-35th, but lacks bike facilities (not even a wide outer lane; King Drive has a bike lane but only goes so far as Cermak Road), or other people bicycling.

In future installations of bike parking like these two, we should look at the difficulty of accessing the bike rack as well as considering who will use them and what trips they may take (will people bike past the station to their destination?). Additionally, planners should count the number of bicycles parked at the stations before and after new parking fixtures are installed to better understand how and when it’s used.

Disclaimer: I was involved in 2009 and 2010 in selecting four CTA and Metra stations for the second round of Bike To Transit. The Regional Transportation Authority (RTA) awarded CDOT a $375,000 grant as part of its Innovation Coordination Enhancement program.

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

Trying out uDig, a free, multi-platform GIS application

ArcGIS is the standard in geographic information system applications. I don’t like that it’s expensive, unwieldy to install and update, and its user interface is stymying and slow*. I also use Mac OS X most of the time and ArcGIS is not available for Mac. It doesn’t have to be the standard.

I’ve tried my hand at Cartographica and QGIS. I really like QGIS because there’re many plugins, it’s open source, there’s a diverse community supporting it, and best of all, it’s free. I’ve written about Cartographica once – I’m not a fan right now.

My project

  • The data: Bicycle crashes in the City of Chicago as reported to IDOT for 2007-2009
  • Goal: Publish an interactive map of this data using Google Fusion Tables and its instant mapping feature.
  • Visualizing it: Added streets (prepared beforehand to exclude highways), water features, and city boundary (get that here)
  • Process: Combine bike crash data; reproject to WGS84 for Google; remove extraneous information; add latitude/longitude coordinates; export as CSV; upload to Google Fusion Tables; map it!
  • View the final product

Trying out uDig

In reaching my goal I had a task that I couldn’t figure out how to complete with QGIS: I needed to combine three shapefiles with identical table schemes into one shapefile – this one shapefile would eventually be published as one map. The join feature in fTools wasn’t working so I looked for a new solution, uDig, or “User-friendly Desktop Internet GIS.”

The solution was very easy. Highlight all the records in the attribute table of one shapefile, click Edit>Copy, then select the destination table and click Edit>Paste. The new records were added within a couple seconds. I could then bring this data back into QGIS to finish the process (outlined above under Project). I did use fTools later in the process to add lat/long coordinates to my single shapefile.

After adding more data to better visualize the crashes in Chicago, I noticed that uDig renders maps to look smoother and slightly prettier than QGIS or ArcGIS. See the screenshot below.

A screenshot of the three bicycle crash datasets (2007, 2008, 2009) with the visualization data added.

The end product: three years of police reported bicycle crashes in the City of Chicago on an interactive map powered by Google Fusion Tables, another product in Google’s arsenal of GIS for the poor man. View the final product.

*I haven’t used ArcGIS version 10 yet, which I see and read has an improved user interface; it’s unclear to me and other users if the program’s been updated to take advantage of multi-core processors. ESRI has a roundabout way of describing their support.