Visualize this: 32,000 DC Bikeshare Trips (VIDEO)

The Capital Bikeshare in Washington, D.C. has been on my dataviz short list since I first took a crack at Boston’s Hubway data last fall. At the urging of a fellow Urban Planning student and bona fide NYC bike nut, I set out to bring the D.C. system’s open data to life. (The Capital Bikeshare is run by Alta, who will also be implementing Citibike in NYC this year)

In the 32,000 trips included in the 5-day sample, rush hour surges, pulses of local traffic, cross-river commutes, and 3 a.m. Sunday morning “Rides of Shame” can be seen throughout the city.  Trip starts are represented by Blue dots, which quickly fade away.  If the trip ended at a different bikeshare station (as most do), a moving yellow dot appears, covering a straight-line path between the start and end station.  Weekday peaks occur at 9 am and 6 pm, and system appears to be well-used all day long on the weekends.

Capital Bikeshare opened their data in early 2012 and has been useful for visualizers and transit developers alike.

Chris Whong is an Urbanist, Mapmaker, Data Junkie and Opengov Enthusiast in New York, New York. He is currently pursuing a Master's Degree in Urban Planning at New York University's Wagner School of Public Service.


Thank you

Every day I get to engage with entrepreneurs, public sector innovators and journalists on re-imagining and re-energizing how government works, what it means to be “civic,” and this year has been an incredible one for many friends and colleagues.

Funding government technology

I’m always inspired talking and working with entrepreneurs trying to solve big civic problems, especially those who realize much of the challenge lies within modernizing and empowering internal government operations, so it was great to finally meet with Govtech Fund Founder and Managing Partner Ron Bouganim this week.

Government and the ’empowered product owner’

The 18F Delivery team released a “Partnership Playbook” that aims to help federal agencies understand what to expect when working with 18F, and the gem within is play number two, “We work with an empowered product owner.”

Benchmarking for better government

Citizens simply glaze over when they are confronted by a sea of large numbers with many zeros. These figures need to be relatable to the person reading the data. Otherwise, open data is just more data that dies on the vine.

Why local government must go digital

The Welsh Government released a report of its findings on how local government in Wales can better leverage digital technologies and realize significant savings while still providing quality, scalable citizen services.

‘No ugly, old IT.’

“No ugly, old IT” jumped out at me when I first reviewed DataSF’s strategic plan, “Data in San Francisco: Meeting supply, spurring demand,” and it still sticks, mostly because someone inside government was so bold as to make this a priority and openly communicate it and also because this should be a mantra for everyone building civic technology.

Why is a big deal

Enabling internal government tech shops to quickly stand up applications in a secure testing environment is fundamental to quick prototyping, and 18F’s new is a major step in realizing ultimate IT flexibility.


Follow GovFresh