Hubhacks

This is the Vermonster team's repository for Hubhacks challenge.

We are using Tableau for the visualizations. In this repository, we are:

adding links to the raw data we're using
committing any data-munging scripts we write
adding links to processed data for importing into Tableau
adding graph screenshots and ideas for integrating the graphs into a flow, if it's useful

Take a look at our Trello board, too.

Our Project

Our project utilizes:

Runkeeper's data on running and biking in Boston between 2010 and 2015
- Link to request the full runkeeper dataset
The Boston Area Research Initiative's Bicycle Collision dataset (between 2009 and 2012)
- Geocoded
Boston Bike Network (http://maps.cityofboston.gov/bikenetwork/) dataset on bike lanes and when they were added or plan to be added (from 2009)
- Existing Bike Network

We are looking for insight into:

where do people run/bike, when, and what accounts for the differences?
what streets are most and least safe for biking?
what is the effect of adding a bike lane?
- to total ridership?
- to total collisions?
- to collisions per biker?

Now live on Amazon. We hope you find it useful!

Name		Name	Last commit message	Last commit date
Latest commit History 87 Commits
.gitignore		.gitignore
BostonBikeSafety.twb		BostonBikeSafety.twb
Existing_Bike_Network.json		Existing_Bike_Network.json
Gemfile		Gemfile
Gemfile.lock		Gemfile.lock
README.md		README.md
add_indexes_and_years_to_cycling_data.rb		add_indexes_and_years_to_cycling_data.rb
bike-path-data.csv		bike-path-data.csv
bike_collision_geo.csv		bike_collision_geo.csv
boston-bike-trips-crashes-and-bike-paths-may2010-dec2012.csv		boston-bike-trips-crashes-and-bike-paths-may2010-dec2012.csv
collisions_by_street.csv		collisions_by_street.csv
combine_collision_route_and_bikepath_data.rb		combine_collision_route_and_bikepath_data.rb
combined-path-route-and-collision-data.csv		combined-path-route-and-collision-data.csv
consolidate_bikepaths.rb		consolidate_bikepaths.rb
convert-path-data.rb		convert-path-data.rb
correlate_collisions_and_routes.rb		correlate_collisions_and_routes.rb
esri1.json		esri1.json
esri2.json		esri2.json
esri3.json		esri3.json
esri4.json		esri4.json
events_by_street.csv		events_by_street.csv
flatten_runkeeper_data.rb		flatten_runkeeper_data.rb
geocode_collision_data.R		geocode_collision_data.R
geocode_cycling_data.rb		geocode_cycling_data.rb
geocoded_cycling_data.csv		geocoded_cycling_data.csv
helpers.rb		helpers.rb
index.html		index.html
joined-bikepaths.csv		joined-bikepaths.csv
route_summary.csv		route_summary.csv