Mapping Frustration in San Francisco, Zurich, and Geneva

Last month, I worked on a project for the 2013 Urban Data Challenge, a competition to visualize a week’s worth of transportation data for three cities: San Francisco, Zurich, and Geneva. (My team won second place in the challenge so I’ll hopefully be visiting Switzerland some time soon!)

At the outset of the competition, I was fortunate to meet with some talented  people with experience in civil engineering, data science, architecture, programming, and visual design.  We considered a number of different ideas, but finally decided upon a way to quantify, rank, and then visualize the frustration of transit users in each city.

Our final application visualizes frustration on a Monday in each city. At different times of day, you can view frustration in terms of speed, the crowdedness or capacity of vehicles, and delay. Then, if you zoom in on one transit stop,  a total grade of the frustration is calculated for this stop.  There are a variety of other factors that I would have liked to consider, which are summarized along with our project methodology.

The application is here:

Incidentally, frustration is a word that summarizes my experience wrangling with the raw transit data for these cities. The tasks of formatting, normalizing, analyzing the data and formulating output required much more effort than I had anticipated. The dataset for San Francisco was particularly challenging. I spent a number of restless nights trying to correlate real data from October 2012 with the Google Transit Feed for the same time period. With the exception of a few hundred outlying buses, I was finally able to sync the Google schedules with the raw dataset. This was tremendously rewarding, but there were still countless other issues that our team had to figure out.

The Google Maps Javascript API,  Transit API and Transit Feed are quite powerful. It would be nearly impossible to do this same project over a few weeks without the assistance of these or similar tools. I was especially impressed by the customizability of Google map’s presentation layer. You can style the map just about any way you desire and there are a number of different data layers that you can turn off or on.

I’ll be writing a separate post about findings and trends in the data, as well as remaining questions, issues,  ideas, et cetera that I would like to return to. For instance, I would love to apply theories of computer networking to this data, such as  vehicle queuing and routing and channel flow, capacity, congestion, and reliability.

But enough banter, here’s a video.


10 thoughts on “Mapping Frustration in San Francisco, Zurich, and Geneva

  1. Many times unable to work, or perhaps unable to
    care for a loved one that you “thought” was covered
    by their medical plan. Health Insurance Texas can be banked on
    for their great and impartial advice. For example, say a person has a large family, the mortgage reversals or normal house loans payments will continue to run.

  2. With approaching deadlines and looming ambiguities on health insurance exchanges, tthe competition for insurers is
    likely to heighten that would in turn impact establishd
    cost estimates and market stategies for insurers. * Eye Problems: Eye problems are usually caused by injury, infection, or an irritating object in
    the eye. In mokst cases,you cann gget generics, and generally there isn’t a difference between these and the brand
    names anyway.

  3. Swiss Re clearly features a have to havbe to disllay us that this really is a big
    company, oriented on worldwide enterprise.
    With the right website, you can compare thee home insurance quotes of different agencies and compaznies in the matter of minutes.
    Consistent use of a thorough pre-inspection agrwement can often lower the cost of your E&O

  4. ” It is crucial to have highly trained experts in informatics who are able to work across both the disciplines of health and information technology, and who understand and are expert in both. This involves failing to do a thorough research on the many companies offering cheap premiums that end up having grave ramifications afterwards. In Florida, almost one in 10 residents has diabetes.

  5. You may also have to board up windows and doors to stop theft of
    any oof your possessions. You should learn basic featurfes and coverages
    for a home insurance policy before making a purchase.
    To lower your homeowners insurance, you should have a
    security system installed.

  6. The portion of the policy that belonged to thee
    deceased beneficiary woiuld pass as per the bove stated requirements;.
    Since companies offer discounts for multiple plans, iit iss possible that the person obtained vehicle, house, andd life policies from the same place.
    • Compare to othewr savings policies, equity indsxed universasl
    life insuranhce policies have a bit off a high fee base.

  7. Addingg several web sites that use the identical content.
    The chief importance of SEO service has naturally resulted in
    a lot of speculations. Depending on which engine is being used wikl determine the
    order of the results displayed.

  8. Failing to understand any one of these, or misinterpreting tthe goals
    can lead to utter chaos. As with anyy other type of good writing, you should know yur
    audience and have an understanding of what they would want to read.
    Gone are those days where the tedious and long duration of painting wass the luxury and symbol of aristocracy; nowadays advent oof technology has launched a new way of accurate and precision made copy of a painting.

  9. The recession has seen a spike in ‘reluctant landlords,’ real
    estate owners who intended too sell, but have decided to
    sign a lease agreement instead of a sales contract.
    Tornado, hurricane, snow), damage incirred by fire or earthquake (ie.
    4) The tenant shall keep the premises clean, and shall repair damage caused by a willful or negligent act of the tenant or of a person whom the tenant
    permits on the premises.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s