By Balazs Krich and Daniel Molnar
This is a project existing yet in three different components which are waiting to be integrated.
Data analysis (see attachment, hubway.pdf) For crunching your data we used Tableau - there are a limitless number of variations you could come up with, so we just threw in a couple of snapshots that looked interesting or insightful. Note that these charts are clickable and interactive in their original format. This is especially useful when combining interactive charts - for this we also included an example, just to forecast this component's function in the final integration (since the data is well over 100.000 rows, we can't share it with you on Tableau Public). You seriously need to do some campaigning within the Harvard community!
Mapping time (http://dl.dropbox.com/u/1026064/torque/examples/boston.html) Since you log a lot of data with timestamps, it is a pretty straightforward idea to make that data animated, i.e. move in space and time. This visualization concept shows all bike routes started or ended on October 1st 2012. All routes visualized as points derived from Google Directions API. Timing is based on default timing given by the API added to the start time, no time stretch has been done to fit the API provided timing to the real start-end timing. The visualization is generated with CartoDB Torque using a free account. Table contains 31435 rows.
You own tileset (http://a.tiles.mapbox.com/v3/krichb80.map-wsefjhjk.html#10.00/42.3418/-70.8382) That's right: since we couldn't find a decent outdoor/biking map for Boston, we decided to make one on our own! Most of the work went into defining this tileset, and even though this hasn't got a lot to do with analyzing your data (which is what the challenge is really about!), we still thought that you should get something that you can make use of in the future. This map could easily be a basis for a smartphone app or a platform that hosts the visualization of all your exciting data - as a map it only needs few perfections - i.e. names/text and a decent legend. It's a solid 1.74 GB tileset which has 13 different layers, including 12 different kind of road types, etc.
Though a tile set should only be consisted of map data, we marked the Hubway stations (colors and size represent usage) just to give you and idea what we mean when saying that the three components should really be integrated into one.
Sources: Besides the Hubway data we downloaded mapdata from Oliver, MassGIS's awesome online data repository, and used satellite images for shaded relief from NASA’s Shuttle Radar Topography Mission.
Additional download: balazs_Hubway.pdf