Page 57 of 171

On Active Transportation Alliance’s transportation summit

Active Transportation Alliance invited Eric Hanns and I to speak about “using data for advocacy” at their first annual transportation summit held after a member meeting two Saturdays ago. My and Eric’s talks were complementary and centered around the data tool I built and which Eric and the other volunteers in the 46th Ward participatory budgeting program used to prioritize and market infrastructure projects in Uptown.

The tool in question is the Chicago Crash Browser I made last year and improved this year to load data faster, with great help from the Smart Chicago Collaborative and several members of the OpenGov Hack Night group I cherish.

Click or tap a spot in Chicago to retrieve the number of bicyclist-car and pedestrian-car crashes within 150 feet. With this information, the PB volunteers could show the alderman how important it was for him to support bike and pedestrian infrastructure projects in the ward, and to persuade ward voters to fund these projects.

Find more information about the four other summit “breakout groups” on Active Trans’s website. Eric and I prepared a “Using Data for Advocacy: Making the Case with Compelling Facts” handout which you can download as a PDF or see on our Google Doc. I’ve conveniently listed the links from the handout below but if you want more pointed advice on where to look for specific data, or get an answer to questions you have but don’t grok the context of each of these tools, leave me a comment.

Chicago’s train stations are dead zones

Perhaps not all of them: Millennium Station, serving Metra Electric and South Shore Line trains, was rebuilt and given a facelift and new tenants (including a few restaurants) when the City of Chicago constructed Millennium Park atop it. And not Northwestern Station since it has two food courts, activity from the thousands of workers above, and the new(ish) French Market.

But look at Union Station and LaSalle Station – they tell passengers to stay away. It’s obnoxious (and noxious) to be in them. These two stations have quite the space available for pleasant activities and waiting areas. Union Station has the Great Hall and a bar but it’s also a Great Distance away from the platforms. LaSalle Station is probably the worst: a dozen machines squawk at waiting passengers – if there are any – to tell people who are blind where each track is. Every 3 seconds.

I made a video to demonstrate a little of how unlovable train stations are in the United States. Not every station has the squawk boxes right in the main, but empty, waiting area, but the desolation and difficult access is widespread.

There’s a whole lot of nothing at LaSalle Station. Photo by Jeff Zoline. 

Google Maps’s lies are why I made my own bike map

http://goo.gl/maps/BlIZF

Bright green lines indicate trails while darker green lines indicate bike lanes.

Because Google Maps lies about where bike facilities are. Check out the bicycling layer at 16th Street and Wood Street in Pilsen, Chicago, Illinois.

Google Maps bicycling layer legend

Google Maps bicycling layer legend

The bright green lines represent trails, but the ones in this part of Pilsen are not trails. All of the north-south “trails” you see are actually sidewalks underneath railroad viaducts. The east-west trails…well, I’m not sure what they are but they are on elevated railroad property. Don’t go up there.

I created my own bike map to deal with the inaccuracies across Google Maps. I used my local knowledge (“ground truth”) and high-quality bike facility data from the Chicago Department of Transportation.

I also used contributions to OpenStreetMap, mainly for trails. I’ve been correcting and adding new bike lane data to OSM as CDOT installs them. View this area with OpenCycleMap’s tiles, which shows only bike lanes on 18th Street.

If you’re an editor on Google’s Map Maker data editing platform, please correct these errors. I would do it except that Google doesn’t allow others to benefit from my data contributions like OpenStreetMap does, where anyone can give and take. (I also had a negative experience on Map Maker, getting myself into a tiff with an unnamed user who disagreed with my changes, based on a personal visit to the location, that were not visible on the satellite imagery because that location had outdated imagery.)

 

How to convert bike-share JSON data to CSV and then to shapefile

Update January 4, 2013: The easiest way to do this is to use Ian Dees’s Divvy API as it outputs straight to GeoJSON (which QGIS likes). See below.

For Michael Carney’s Divvy bike-share stations + Census tract + unbanked Chicagoans analysis and map he needed the Divvy station locations as a shapefile. I copied the JSON-formatted text of the Divvy real-time station API, converted it to CSV with OpenRefine, and then created a shapefile with QGIS.

Here’s how to create a shapefile of any bike-share system that uses hardware from Public Bike System Co based on Montréal and is operated by Alta Bicycle Share (this includes New York City, Chattanooga, Bay Area, Melbourne, and Chicago): Continue reading

San Francisco is an expensive place to get around

$8.15 if you want to exit the San Francisco airport via public transit.

In June I visited friends in San Francisco and attended the State of the Map US conference. I spent a lot of money on transit and bicycle rentals. This doesn’t exclude the cost of driving to Davis, California.

BART

Airport to 16th/Mission: $8.15
Union City to North Berkeley: $4.10
16th/Mission to Berkeley (roundtrip): $7.60
16th/Mission to airport: $8.15

I needed to travel from Stanford University (where my friend Stefano does research) to Berkeley (to visit Rock The Bike) and the cheapest and soonest way to get there was to take the Dumbarton Express bus across the lower San Francisco Bay to the Union City BART station. 

Dumbarton Express
Bus from Stanford to Union City BART: $2.10

Caltrain
22nd Street to Stanford (Mountain View): $7.00 (Google Maps says it would cost $21.99 to drive this trip)
Stanford (Mountain View) to 4th/King: $7.00

Total for 8 transit trips: $44.10

In Chicago, if I had taken all trips individually (no transfers), my cost would be about $31.75. To compare Caltrain to Metra, I calculated the cost of a trip from downtown Chicago to Geneva, which is $6.75 each way. This includes the $5.00 trip cost to get out of O’Hare airport, significantly less than BART’s $8.15.

I didn’t ride Muni trains (they’re kind of slow compared to bicycling) but I took a lot of photos of them arriving at Duboce Park. 

Bicycling

Bike rental in Davis, California for 3 hours: $10
Bike rental via Spinlister for 4 days: $72

This is the Surly Long Haul Trucker I rented via Spinlister, seen on the BART train in the roomy bike spot. For the most part, the bike can rest here without any securement. 

This is the charge I’m least concerned with, except that Spinlister charges me a 12.5% service fee). I also picked it up in Stanford because that’s where the bike owner lived; it was the best alternative of the available bikes for people my height as it was a bike I liked (Surly Long Haul Trucker) and it was $16 per day, the cheapest by $9 per day!

Part of the OpenStreetMap conference included a trip to the California Academy of Sciences on the Friday before the meetings started. The SCUBA diver on the left is cleaning the glass while the diver on the right is talking to the museum worker outside the pool. 

Not having a bicycle in a place I visit makes me feel naked. Having the bicycle reduced my potential fees on getting around. I had to move from my friend’s house to the OpenStreetMap conference (which would have required two transit trips or a taxi), between the conference and downtown for the World Naked Bike Ride, and between the conference and Sunday Streets in Dog Patch and Mission Bay. I also biked to Golden Gate Park to visit the California Academy of Sciences, pedaled over to see the Aether shop made with three shipping containers, joined SF Bike Party on Friday night, and biked around Berkeley to see Paul Freedman at Rock The Bike.

I left the OpenStreetMap conference during Sunday’s lunch to check out Sunday Streets. Even though I sold my Yuba Mundo for a WorkCycles Fr8, I love seeing families on cargo bikes.