Category: Information

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

Divvy considers my suggestions in bike-share kiosk map redesign

The new design that will appear at the newest stations first and then rolled out to all stations. 

I posted two months ago a critique of the Divvy bike-share maps, seen at 284 stations scattered around Chicago, focusing on the clutter of having so many maps (with the third being useless), unclear labels and labels that covered map objects, and the low prominence of the smartphone app and map legend. Two weeks ago the Divvy public relations manager emailed me a screenshot of the new map design and said that these points had been changed. He said they considered four of my suggestions:

  1. Make CycleFinder, the official Divvy smartphone app, more prominent
  2. Change “You are here” design to make it clear where you are
  3. Make streets and streets’ label text smaller
  4. Removed service area map and make legend more prominent

I replied to the manager and suggested that the “You are here” label be made slightly transparent to show that the road does continue beneath it.

Close-up of the original “you are here” design that covered up other objects and wasn’t centered in the walking distance circle.

Department of Road Diets: the carbon tax

Grand Avenue over the Kennedy Expressway. Its four lanes look like this – empty – most of the day. But then there are times of the day where people who bike, take the bus, and drive all need to “share the road”. That failed strategy has led to increased road rage, slow transit, and dead bicyclists. Time to put roads like this on a diet. 

My friend Brandon sent me an article about the one-page solution to (mitigating) climate change in the United States that NPR posted this summer.

But Henry Jacoby, an economist at MIT’s business school, says there’s really just one thing you need to do to solve the problem: Tax carbon emissions.

“If you let the economists write the legislation,” Jacoby says, “it could be quite simple.” He says he could fit the whole bill on one page.

Basically, Jacoby would tax fossil fuels in proportion to the amount of carbon they release. That would make coal, oil and natural gas more expensive. That’s it; that’s the whole plan.

This new carbon tax would support different infrastructure construction and expanded government agencies with which to manage it. It would support a Department of Road Diets. Road diets are projects that reduce the number of lanes for cars on a roadway, either by reducing the width of the roadway, or converting the general purpose lanes to new uses, like quickly moving buses or giving bicycles dedicated space.

See, in the carbon taxed future, people will want to drive less and use more efficient modes of transportation like transit and bicycles. And those uses will need their own space because the status quo in our cities (except the ones in the Netherlands) of having each mode compete for the same space isn’t working. It results in frustration, delay, and death.

Enter the Department of Road Diets. We have millions of miles of roadways that will need to go on diets so a department dedicated to such transformation would be useful. The agency would be in charge of finding too-wide roads and systematically putting them on diets, I mean, changing their cross section to less carbon-intensive uses.

Creating a bike map for Richmond, Indiana

A cycle map of Richmond, Indiana, before I added the city’s signed routes as a “relation”.

I visited Richmond, Indiana, in early August with my friend who grew up there. There isn’t much to do there, but there are a lot of neat places to bike to. Richmond had more features mapped than I expected, but I was happy to contribute via Pushpin and JOSM. With Pushpin OSM, an app for iOS, I added a couple of venues I visited, including Firehouse BBQ & Blues.

With JOSM, though, I wanted to add the city’s bike routes so they would appear in OpenCycleMap and could then be immediately embedded as a (somewhat) interactive map on the Bike Richmond website. I asked a city planner for a bike map and he gave me a GIS printout that showed the “recommended routes” (which are unsigned) and then he drew on the signed route that augment the recommended routes. The signed route essentially creates a loop.

I tagged all of the recommended routes as “bicycle=designated”. After the tiles in OpenCycleMap updated to include my work in Richmond I realized that OCM doesn’t symbolize “bicycle=designated” unless they’re in a relation. I created a relation, calling it the “City of Richmond Signed Bike Route“.

The new cycle map of Richmond, Indiana. 

This was cross-posted to my OpenStreetMap diary. My next project for OSM in Richmond is to map all the murals with the tag “tourism=artwork”. The mural below was designed by my friend, Ryan Lakes. There are murals painted on the sides of many buildings. One motif is to paint realistically, so it appears that the building really has the Wright brothers bicycle shop.

Mural in two-point perspective. 

A painted fire on the side of Firehouse BBQ & Blues. 

NIMBYs can’t have it all: Student instructor at West Town Bikes supports wheel-friendly park

Lebster, far left, three students at West Town Bikes, and executive director Alex Wilson, head to Open Streets on State Street. 

Update August 27:  Lebster was interviewed by RedEye reporter Leonor Vivanco today.

Lebster Pabon, an instructor at West Town Bikes in Humboldt Park (it used to be in West Town!), attended an important Chicago Park District board meeting yesterday and brought one of his high school students and that student’s mother. They spoke up to support what would be the city’s first wheel-friendly park, where people can skate, bike, and… which would be new to Chicago… use wheelchairs in the park. Neighbors of the Bloomingdale Trail were in attendance to oppose the park.

Lebster called me to say that another attendee spoke up to say he would like to bring his grandchildren to such a park, and that a board member added he has to take his kids out of Chicago to use bikes in a park like this. Lebster mentioned that since it’s at the end of the Bloomingdale Trail it would be very accessible: ride up Rockwell from West Town Bikes, a low-traffic “side street”, hop on the Bloomingdale Trail, and ride 10 minutes over to Walsh Park. When asked if the park would attract people from other suburbs, Lebster said it would attract people from around the country because it could host events.

Finally, a Chicago Park District board member asked if bikers and skaters coexist. Lebster told me he said, “Yes, the culture is very disciplined in skate parks”. I’ve witnessed it myself and I didn’t expect it, imagining that teenagers are unruly. Rules aren’t needed, though, as each person has learned to take a turn in the park and then respect the time and talent of the other skate park users.

This is a very special and unique moment for young Chicagoans who are active outside as this proposed park would be the first to accommodate bicycles and wheelchairs. The Chicago Park District’s first core value is “Children first”. The website says, “Our most important task is to bring children and families into our parks and give them great reasons to stay and play for a lifetime”. Lebster’s contributions to the meetings, and the conversations around the park, were integral to that value and the District’s mission.

About West Town Bikes

West Town Bikes and I have a good history. I came into contact with the organization in 2006, the year I moved to Chicago. I joined a scavenger hunt in October that ended at the shop. I met a lot of people there that have shaped my bicycle advocacy future, including Kevin Monahan, who put John Greenfield and I together after which we started Grid Chicago, Jim Freeman, Kevin Conway, Gin Kilgore, and countless other people. West Town Bikes is also the host and a sponsor of my annual Cargo Bike Roll Call events.