Today we celebrate National Bike to Work Week and Infrastructure Week with some visualizations of bike commuting in Charlottesville. This is a very simple visualization where we mash up Census ACS data on who bikes to work in Charlottesville with the city’s bike lane GIS maps. There are a variety of threads to pull on from each of these maps and we hope that it informs people about bike infrastructure and commuting rates in the city. For more information on bike infrastructure, take a look at the Federal Highway Administration Design Guide. See below for data and technical notes.
Percentage of people biking to work and existing dedicated bike lanes
Embed
<iframe src="https://www.google.com/fusiontables/embedviz?q=select+col6+from+1b5GlCnEpZqre2-TGFI6snGne6rfmRmGm34GK7xJd+where+col3+in+(''%2C+'Lane')+and+col4+in+('Existing'%2C+'')&viz=MAP&h=false&lat=38.032677528923955&lng=-78.48658125659176&t=1&z=13&l=col6&y=2&tmplt=2&hml=KML" width="700" height="600" frameborder="no" scrolling="no"></iframe>
Percentage of people biking to work and existing, shared, and dedicated bike lanes
Embed
<iframe src="https://www.google.com/fusiontables/embedviz?q=select+col6+from+1b5GlCnEpZqre2-TGFI6snGne6rfmRmGm34GK7xJd+where+col3+in+(''%2C+'Lane'%2C+'Shared')+and+col4+in+('Existing'%2C+'')&viz=MAP&h=false&lat=38.032677528923955&lng=-78.48658125659176&t=1&z=13&l=col6&y=2&tmplt=2&hml=KML" width="700" height="600" frameborder="no" scrolling="no"></iframe>
Proposed bike lanes, dedicated
Embed
<iframe src="https://www.google.com/fusiontables/embedviz?q=select+col6+from+1b5GlCnEpZqre2-TGFI6snGne6rfmRmGm34GK7xJd+where+col3+in+(''%2C+'Lane')+and+col4+in+(''%2C+'Proposed')&viz=MAP&h=false&lat=38.032677528923955&lng=-78.48658125659176&t=1&z=13&l=col6&y=2&tmplt=2&hml=KML" width="700" height="600" frameborder="no" scrolling="no"></iframe>
Proposed bike lanes, dedicated and shared
Embed
<iframe src="https://www.google.com/fusiontables/embedviz?q=select+col6+from+1b5GlCnEpZqre2-TGFI6snGne6rfmRmGm34GK7xJd+where+col3+in+(''%2C+'Lane'%2C+'Shared')+and+col4+in+(''%2C+'Proposed')&viz=MAP&h=false&lat=38.032677528923955&lng=-78.48658125659176&t=1&z=13&l=col6&y=2&tmplt=2&hml=KML" width="700" height="600" frameborder="no" scrolling="no"></iframe>
Future network, city of Charlottesville (proposed, existing, shared, and dedicated)
Embed
<iframe src="https://www.google.com/fusiontables/embedviz?q=select+col6+from+1b5GlCnEpZqre2-TGFI6snGne6rfmRmGm34GK7xJd+where+col3+in+(''%2C+'Lane'%2C+'Shared')+and+col4+in+(''%2C+'Proposed'%2C+'Existing'%2C+'Exisiting')&viz=MAP&h=false&lat=38.032677528923955&lng=-78.48658125659176&t=1&z=13&l=col6&y=2&tmplt=2&hml=KML" width="700" height="600" frameborder="no" scrolling="no"></iframe>
Technical Discussion
We combined the data from the Census Bureau with Charlottesville bike infrastructure maps. The city’s maps were converted to KML files and imported into Google Fusion Tables. We manually inserted the bike to work data for Charlottesville from the Census. We had trouble getting only city Census tract maps but fortunately Chris Gist, University of Virginia was able to share those maps with us based of the data provided by the US Census. We converted them into KML format for Google.
Data notes
We took freely available GIS data from the city of Charlottesville for the bike lanes. The city GIS maps are one of the best open data sources the city offers. We caught at least one typo error in this data and notified Amanda Poncy, but did not get a response. For the bike to work data, we used the Census Explorer, Commuter Edition. We wish the Census Explorer allow for direct data extrapolation and exporting, it would make using this data easier. You can embed these Census Explorer images, but mashing up the data with local information as we did here is not possible given the current export offering from Census. Data from the commuting survey comes from 2013. Unfortunately, city data on bike lanes does not the include year bike lanes were completed. Armed with this, we would like to do a 2013 versus 2013 comparison to help analyze the “if you build it they will come” theory.