Part 4 in a series mining a recently crowd-sourced pile of trip-level data on Capital Bikeshare. This post focuses on flows around the city, the top travel markets, and how certain areas are more in balance than others. If you’re bored, need sleep, or both, read Part 1, 2, or 3.
So, where are the Bikeshare bikes going to, and from? While we can’t tell people’s final destinations, we can tell what docks they use. So, I did a quick look at usage by dock, but unfortunately, with 142 stations, it’s impossible to visualize cleanly at the station level:
But, I will say it’s interesting how the most popular station at Dupont Circle is the winner by a long shot. As has been discussed elsewhere, this is likely because there are few other stations around, it’s a big station, and it was one of the first installed.
Dividing Into Zones: I divided up the Bikeshare stations into 12 big groups, kind of like “super neighborhoods,” to get a sense of where the riders are going to and from. This is more art than science, but I basically drew lines based on my knowledge of biking around the city, and a healthy dose of arbitrariness.
You can argue with how I drew the lines, and how I had to wing it when a station was right on the line, etc. But I just needed some rough groupings of stations to make sense of travel patterns. Wards seemed a little too blunt, e.g. Ward 6 encompassing everything from Shaw to the Ballpark. So, I drew Downtown as roughly the CBD from Constitution Ave. to Mass. Ave., Mid-City as everything in the middle south of Woodley Park and U Street over to Union Station, and then the others kind of fell in mostly logical groups. I put the station at L’Enfant under Mall, and Woodley Park under Upper Northwest – eh, it was a judgment call. I also totally made up the zone names. The main thing is, we can now look at a manageable amount of numbers.
The numbers shook out so that every zone had between 4 and 30 stations, with most about 10-20. More on that later.
Origin-Destination Matrix. Interestingly, this produces an 12×12 origin-destination matrix, or 144 different possible combinations of origins and destinations. Here’s the full table, just showing 2011 trips, if you’re interested:
Now, a few observations with this stuff. A caveat – I haven’t accounted for the fact that stations were added over time, so neighborhoods that first got stations installed are going to look more popular than more recent arrivals, such as Rosslyn-Ballston. And, different zones have different number of stations – although more station could be a symptom of demand just as much as cause. Nevertheless:
- Trips to and from downtown dominate bikeshare patterns, at one third of all trips in 2011.
- Trips tend to be short, as we saw earlier, making inter-zone trips popular (that’s the diagonal line running from top left to bottom right. Especially in Capitol Hill, Mid City, and others.
I halfheartedly attempted to draw this table on a map, with admittedly third-rate arrows in PowerPoint. It’s a little clunky, but it does (sort of) give a visual representation of the table above. For this illustration, I suppressed all flows less than 30,000 trips or so. I am clearly not a graphic designer – anyone want to help make this look better?
In Balance, or Net Sender/Receiver? From the zone totals, I think you can also tell whether a zone is more or less in balance over the year (same number of trips beginning and ending), or whether it is a net “sender” or “receiver” of Bikeshare trips. If more trips ended at a zone than began at it, I believe the difference is the re-balancing crews.
So, over the course of 2011, 5% more trips ended downtown than began downtown, meaning that the rebalancing vans, on net, took bikes away from downtown. Contrast that with neighborhoods to the north and west (places like Cleveland Park, Petworth, Mt. Pleasant, and others in Upper Northwest, Mid-City North) where it’s mostly downhill to downtown, and more trips began than ended. Here is the final column, graphed in terms of absolute trips:
Okay, that’s all for now. Until next time, keep the comments and reactions coming! It’s nice to hear your thoughts.
P.S. – one further thought on the “balanced-ness” (is that a word?) of individual stations.