Category: Information

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

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.

High-speed rail in Illinois, February 2011 edition

View a map of the places described in this article.

A friend of mine traveled by Amtrak’s Lincoln Service from Chicago to St. Louis in January 2011. He reported, “It’s extremely smooth north of Alton and south of Lincoln. You can barely even hear or feel that you’re on a train.” Track replacement as part of President Obama’s economic stimulus and high-speed rail plan is complete between Alton and Lincoln, Illinois.

Photo shows a Union Pacific work train next to new track in Carlinville, Illinois. Photo by Tim Carman, taken in November 2010.

The next track replacement phase will take place between Lincoln and Dwight, scheduled to be completed in Fall 2011. A December 2010 press release from the Illinois Department of Transportation (IDOT) explains the next steps for the first state to begin construction on high-speed rail grants provided by American Reinvestment and Recovery Act (ARRA):

  1. Installation of new, enhanced grade crossing warning protection
  2. New cars and locomotives
  3. Station upgrades

Like all press releases, this one also seems to ooze idealistic endeavors by adding that the “public can expect to enjoy its first taste of 110 mile-per-hour train service when a 20-mile segment between Dwight and Pontiac is completed in 2012.” But this project has a high likelihood of being completed as described.

Read more posts on high-speed rail in Steven can plan.