Category: Chicago

One day left to enter the Divvy Data Challenge

March 10, 2014 / / 0 Comments
Divvy dock post-polar vortex

Divvy bikes have been covered in snow frequently this winter. Photo by Jennifer Davis.

As self-proclaimed Divvy Data Brigade Captain* in Chicago’s #opendata and #opengov community I must tell you that all Divvy Data Challenge submissions are due tomorrow, Tuesday, March 11. Divvy posted:

Help us illustrate the answers to questions such as: Where are riders going? When are they going there? How far do they ride? What are top stations? What interesting usage patterns emerge? What can the data reveal about how Chicago gets around on Divvy?

We’re interested in infographics, maps, images, animations, or websites that can help answer questions and reveal patterns in Divvy usage. We’re looking for entries to tell us something new about these trips and show us what they look like.

I’ve seen a handful of the entries so far, including some to which I’ve contributed, and I’m impressed. When the deadline passes I’ll feature my favorites.

Want to play with the data? You should start with these resources, in order:

  1. Divvy Data Challenge – rules and data download
  2. divvy-munging – download an enhanced version of Divvy’s data, with input from several #ChiHackNight hackers
  3. Bike Sharing Data Hackpad – this is where I’m consolidating all of the links to projects, visualizations, analysis, data, and blog posts.
  4. Divvy Data Google Group – a discussion group with over 25 members
  5. #DivvyData – chat on Twitter

It’s not too late to get started now on a project about the bikes themselves. Nick Bennet has crunched the numbers on the bikes’ activity and posted them to the Divvy Data Google Group. Want to use his data and initial analysis? He said “run with it”.

Share your work ahead of time and leave a comment with a link to your project.

* This title is a play on Christopher Whitaker’s position as Code For America Brigade Captain and all around awesome-doer of keeping track of everything that’s going on in these communities and publishing event write-ups on Smart Chicago Collaborative.

Divvy activity in Wicker Park-Bucktown

February 13, 2014 / / 18 Comments
Divvy Bikes Outside Smoke Daddy

The Divvy bike-share station outside Smoke Daddy on Division Street at Wood Street is the fourth most popular in the Wicker Park & Bucktown neighborhoods. Photo by Daniel Rangel.

This is an analysis of the station use for Divvy bike-share stations in the Wicker Park and Bucktown neighborhoods (they blend together and it’s hard to know if the club or bar you’re going to is one neighborhood or the other).

Numbers represent a discrete trip, from one station to another (or the same station if the trip was greater than 3 minutes, to eliminate “hiccups” where the bike left the dock but didn’t actually go anywhere). Customer means someone who used a 24-hour pass and subscribers are annual members. Gender is self-reported on a member’s DivvyBikes.com user profile.

17 stations listed.

[table id=10 /]

This map of Wicker Park Divvy stations shows a residential service gap among the Damen/Cortland, Ashland/Armitage ( Metra) and North/Wood stations.

This map of Wicker Park Divvy stations shows a residential service gap among the Damen/Cortland, Ashland/Armitage (
Metra) and North/Wood stations.

Based on the popularity of the Ashland/Armitage station, which is right outside the Clybourn Metra station – a very popular train stop – I think there might be a residential service gap near Saint Mary of the Angels School. I recommend a Divvy station at Walsh Park this year because the Bloomingdale Trail will open and terminate there.

Notes

Not all of these stations were online when Divvy launched on June 28, 2013, but I haven’t yet looked into the history to see when each went online. Therefore direct comparisons are not appropriate until you have a trips per day number. Then, seasonality (very cold weather) has its own effect. At the very least, all stations were online by October 29th, with the final addition of the Lincoln Ave & Fullerton Ave (at Halsted) station.

Can someone use “R” to make a time series chart on the entire trips dataset so we can find the best cutoff time to eliminate “hiccups”?

Query used: SELECT count(`trip_id`), usertype, gender FROM `divvy_trips_distances` WHERE (start_station = ‘Claremont Ave & Hirsch St’ or end_station = ‘Claremont Ave & Hirsch St’) AND seconds > 180 GROUP BY `usertype`, gender

Where do Divvy riders go?

February 13, 2014 / / 14 Comments
Divvys

Divvy bikes fit people of almost all sizes. Photo by Mike Travis (mikeybrick).

Divvy released the 2013 trip data on Tuesday for their data challenge, and presented alongside me the data, basic system operations info, and existing visualizations and apps, at a Divvy data-focused Open Gov Hack Night I put together at the weekly meeting. Thank you Chris Whitaker at Smart Chicago Collaborative for writing the meeting recap.

I “ran the numbers” on some selected slices of the data to post on Twitter and they range from the useless to useful! I’m using the hashtag #DivvyData.

  • Average trip distance of members in 2013 is estimated to be slightly shorter than casuals: 1.81 miles versus 1.56 miles – tweet
  • Bike 321 has traveled the furthest: 989 miles. Beat the next bike by 0.2 miles – tweet
  • Women members on average took longer trips (but fewer trips overall) on @DivvyBikes than men in 2013. – tweet
  • The average trip distance of 759,788 trips (by members and casuals) in 2013 is an estimated 1.68 miles. – tweet
  • In 2013, 79.05% of member trips were by men and 20.95% by women. – tweet
  • On average in 2013, 24-hour pass holders (whom I call casuals) made trips 2.5x longer (time wise) than members. – tweet
  • Damen/Pierce Divvy station (outside the Damen Blue Line station) is most popular in Wicker Park-Bucktown – data

And other stats, presented as embedded tweets:

 

 

What if Metra employees were late to work as often as Metra passengers?

February 10, 2014 / / 8 Comments
trainmageddon

A malfunctioning Metra Electric train in January. Photo by Eric Rogers.

It was a big deal to news media this morning when new Metra CEO Don Orseno reported at an Illinois House mass transit committee hearing that the commuter-focused rail system experienced a 30% on-time rating in January, when the “polar vortex” hit. (Apparently polar vortex is not an event that happens to a place, but is the name of a climate pattern that’s always there hovering above Canada and occasionally dips down over the United States.)

Most Metra passengers are commuters, going to work. A hair over 300,000 travel each weekday; service is drastically lowered on weekends and holidays, offering less than half the service of weekdays.

What if the organization of Metra, including all 2,500 employees in addition to the contracted railroad workers (let’s say 3,000 people), showed up to work with the same performance rating that their passengers experience?

First, Orseno – a career railroader who drives to work from Manhattan where a train comes leaves three times each day – would miss 11 work days of work each year (of 260 work days), based on their overall 95.8% on-time rating in 2012. Some routes are worse and others better. But collectively 3,000 people would miss 32,760 work days each year. That’s a lot of missed work.

Put another way, everybody – all 3,000 of them – is going to show up 20.16 minutes late to work because they’re missing 87.36 hours each year (of 2,080 hours they’re supposed to work and being 4.2% hours late). But again, I have no idea who’s working 8 hours and who’s working longer. (One of the problems Metra had during #Chiberia is that many workers hit the federally mandated limit and there weren’t always workers to take their place.)

Thankfully the Chicago Transit Authority, Pace, and ever-expanding highways and tollways are available to pick up the slack in Chicagoland’s transportation supply.

Another thing, this post is full of averages of averages, so it’s really imprecise. Today, Metra was reporting delays on a single train run of 16-100 minutes – a pretty broad estimate, but another train had a possible delay of 26-110 minutes. During the worst storm Metra experienced on January 5th and 6th, some train runs dumped passengers on platforms in subzero temperature.

Orseno reported today at the committee hearing that a “I don’t want to say middle-level” manager at Union Pacific made the call to dump the passengers. This has been “corrected” by only allowing a senior level staffer at Union Pacific make this call. Metra, which doesn’t have any performance-related incentives in its contracts with the freight railroads, apparently cannot stop this decision.

I’m waiting for the day when Metra is run like a transit system and not a railroad.

Note: I excluded vacation days because, well, no law requires organizations to offer paid or unpaid vacation days and there are probably several tiers of vacation-giving at Metra that I don’t know about.

Can you rely on Metra after hearing a story like this?

February 7, 2014 / / 6 Comments

Tweet shows a different Metra line but is representative of experiences since #Chiberia began in January. 

My friend Shaun relayed this story to me about his coworker who rides Metra’s BNSF line from the Aurora/Naperville area, the commuter train in Chicagoland that carries over 300,000 people each weekday but fractions on weekends (because it rarely runs).

The train he was about to board Wednesday morning with several other people arrived and when the doors opened only one of the two sliding doors opened. The other one was stuck shut. So he “touched” it to get it to open up and the conductor yelled at him.

The conductor said “we’ve told you several times to not do that!” seemingly referring to other people who had done so, not my coworker himself. The conductor told him a guy at the last stop did that and it “broke the door.” (sounds like it already was!])

The conductor told him it would be a $500 fine if it happened again. At that point my coworker said he just shut up. When my boss tried to get on the train the conductor told him he wasn’t allowed to board! There was apparently plenty of room to get on so this was at the “conductor’s discretion.” Coworker had to wait 20 min for the next train [in single digit temperatures, no less], missed a meeting, etc…

Just completely shocked me that they wouldn’t let him on the train for pushing the door open (no sign, conductor wasn’t at the broken door to tell people not to touch it, etc.).

This started a conversation about our perceptions of Metra.

Steven: “It’s right that the new Metra CEO [Don Orseno]* wants to work on communication, but I think he needs to emphasize customer service overall.”

Shaun: “In Ogilvie Transportation Center tonight, same announcement played: ‘some trains are delayed. We will continue to update you.’

Every few minutes — no actual information. Lot of work to do I’m guessing. Wonder how many Metra people in charge ride their trains.”

Steven: “I rarely ride Metra for ‘important’ reasons (like going to work or for meetings). The last time was on the Electric to a meeting in South Shore in October.

Every time I ride I feel that the lumbering of the trains as they exit the stations (switching tracks, they sway side to side) is analogous to how Metra operates: ‘move in a slow, heavy, awkward way’.”

Shaun: “It reminds me of a novelty train ride. Like at an amusement park.

I only take it from work to home. To work is too risky. CTA is consistent (lately actually, Red Line at morning rush is so frequent I don’t even check the arrival times while walking to the station).

Kind of funny how you say you can’t rely on Metra for work or meetings, considering that’s what people use it for.

* Orseno, who’s been there for decades, said at the Metra board meeting where he was promoted to executive director from his interim position that he drives to work because the SouthWest Service “doesn’t get him to the office early enough, or home late enough” (Chicago Tribune).

However, Orseno lives in Manhattan so you can see how the infrequency would be a problem: this station only has three trains per direction per day. Remember from my previous post that Chicago rapid transit service has only shrunk since 1950. I wonder what he can do about that…