The City of Vancouver made its bike rack data public yesterday. The data is divided into 4 spreadsheets, which isn’t terribly useful. The only interesting tidbit is the exponential growth in bike lane installations. Vancouver now has 1468 bike racks at 1119 locations throughout the city.
In the all the years up until 2009, 676 bike racks were installed.
In 2010: 52
In 2011: 197
In 2012: 543!
But without a map, that doesn’t tell the full story. So I spent my lunch hour massaging the data and creating a map. It was surprisingly easy with map a list. Click on the image above to get an interactive version. Enjoy.
Note: The dataset uses addresses to identify the bike racks, so it’s not perfect when you zoom in.
For those looking to do more with this data, you can download the KML and play with it in Google Earth. Unfortunately Google Maps limits to 1000 locations, so you can’t just take this data and put into a Google Map. You need to use a tool on top that either cluster or limits the pushpins when you’re zoomed out.
Here’s the same data on a BatchGeo map. The interface is cleaner and you can filter by search criteria (like year or street name).