Posts Tagged ‘data download’

Data Download: May 2013-2014 Metrorail Ridership by Origin and Destination

August 28th, 2014 2 comments

DataDownloadFuzzyMay2013 and 2014 Metrorail ridership data is available: what patterns do you see?

Following up on our last data download of rail ridership from May 2012, 2013 and 2014 are now available. These data now represents three “snapshots” in time of rail ridership, at a very fine level of detail.  This data can help answer questions, such as: where is ridership growth the strongest? Which destinations are becoming more or less popular?  How has off-peak vs. peak ridership changed? 

May 2013 Metrorail Ridership by Origin, Destination, TimePeriod, DayOfWeek (.xlsx, 3.3 MB)

May 2014 Metrorail Ridership by Origin, Destination, TimePeriod, DayOfWeek (.xlsx, 3.4 MB)

We invite you to tell us what you see, in the comments.

Technical notes on the data are the same as the last post.  This time, Saturdays and Sundays are shown in the same worksheet as weekdays.

Ridership Increases Expected for Cherry Blossom Festival

February 27th, 2014 2 comments

During the National Cherry Blossom Festival, Metrorail ridership increases on average by 7% on weekdays  and 50% on Saturdays. 

Metrorail ridership is impacted by a variety of factors, from special events to weather to government shutdowns.  One event that brings visitors to the region — and to Metrorail — in droves is the annual National Cherry Blossom Festival.   In anticipation of this year’s festival, we performed some analysis on how, when and where the blossom viewers impacted ridership on the Metrorail system.

In general, Metrorail ridership increases on average by 7% on weekdays and up to 53% on Saturdays during the festival.  On days with nice weather, ridership has increased up to 10% on weekdays and 70% on Saturdays!

As the figure below shows, during the weekdays there is no impact in the morning, a large (21%) increase of activity during the mid day and then a 7% increase thereafter.

Saturdays are another story all together.  Ridership increases up to 63% during mid day and afternoon periods on days during the festival, with a total ridership increase above 50%.  Even morning and “late” night ridership increases significantly during this period.

Cherry-Chart-Weekday-Saturday-w-Chart-2

Metrorail system entries by quarter-hour interval, Regular Weekday, Cherry Blossom Weekday, Regular Saturday and Cherry Blossom Saturday. Click chart for larger version.

 

When looking at change in ridership by station in the maps below, some obvious conclusions can be drawn. Read more…

What Will the Travel Times Be on the Silver Line?

September 20th, 2013 26 comments

The stations on the new Silver Line are two minutes apart in the Tysons area, and the Tysons-area stations are eight minutes away from both East Falls Church and Wiehle-Reston East.

Silver-Line-Travel-Times

Draft travel times for the new Silver Line stations.

Earlier this year we published a series of posts about the region’s newest rail line, the Silver Line, due to begin service in early 2014. Those posts included answering the questions, “Where will it go?“, “What will happen to rail schedules?“, and “What will happen to bus schedules?“.

Now it’s time to talk about preliminary travel times between Silver Line stations. The map above illustrates the estimated travel times between the five new stations. These times are preliminary and may be refined after operational testing has been completed.

Below is a widget that can be used to look up the travel times between any two stations, including the five new Silver Line stations.*

Read more…

Visualization of Metrorail Station Activity

July 19th, 2013 No comments

Metro planning staff have been working to showcase Metro data in new and unique ways.  We recently posted a visualization in a calendar format that displayed 9 years of rail ridership in one graphic.  We are currently working on animations of ridership data as well.  Below is our first volley into that arena, a visualization of one day’s worth of station-level activity in 15-minute intervals.

Before hitting play, please note the following:

  1. The video is available in high definition (720p), which is the recommended viewing resolution.
  2. The dots are sized according to total station volume (entries plus exits) per 15-minute interval.
  3. The color of the dot represents what percent of the volume is entries vs exits. Magenta dots are 100% exits, blue dots are 100% entries, and purple dots are 50/50, with other colors representing ratios between these three.

The visualization is of data from April 10, 2013, which hit the 4th highest ridership mark that day.   A combination of cherry blossom peak bloom and two sporting events ratcheted ridership up to 871,000 for the day, compared to an average weekday ridership of around 750,000.  Note the high level of activity at the Smithsonian station all day long, and big dots that grow and shrink as the sports games begin and then end near Gallery Place and Navy Yard-Ballpark stations.

What other unique activity can you spot in this animation?  What other types of animations of Metrorail and Metrobus would be informative?

A zip file containing the base data for this animation is available for download:  Metrorail Station Activity at 15-Minute Intervals, April 10 2013


Special thanks to Michael Schade at Mobility Lab for hosting the recent Data Visualization Hack Day and guiding me through some of the tricks and tips.  Check out his lesson plan for animating data using Processing.

 

Data Download: October 2012 Rail Ridership

June 12th, 2013 6 comments

downloadOptionA_256PlanItMetro saw great interest in our last full data download of O/D data last year. We thought we’d provide an update with data from October of 2012. This enhanced data download contains the following files:

  • Full O/D trip data MS Access, including service type (weekday, Saturday, Sunday Special), travel period (AM Peak, mid-day, etc.), entry hour, Origin Station, Destination Station, rider class (full fare or discounted), media type (SmarTrip vs paper farecard), fare instrument type (stored value vs benefits vs pass), average travel time and average number of trips.
  • Subset of O/D trip data “No Details” CSV, includes all trips like the first file above but doesn’t include details on rider class, media type or fare instrument

Download either of these data files and let us know what you find!

 

Categories: Engage Tags: , ,

Share of Reverse Commute Trips Growing

May 6th, 2013 13 comments
Rev Commute Diagrams-01

Metro is focused on solving one of the region’s most pressing mobility issues – increasing the capacity of the system to handle more trips through the core (defined below) of the Metrorail system.  While Metro’s planning staff has been conducting technical analyses and searching for the best solutions for some time, we also asked for ideas for increasing core capacity from you as well as discussed the potential for  new lines, new connections and expanding to all 8-car trains during peak periods.

There are also operational strategies Metro could employ to provide more trips on the rail system without expanding capacity.  Among the various options is to promote and encourage more “reverse commuting” where commuters travel opposite the peak travel direction in seats that would otherwise be empty.  Data show that reverse commuting has already increased over the past 10 years and many speculate that it will only increase further as the region builds more suburban town centers near Metro and as Metro begins operations on the Silver Line later this year.
Read more…

Data Download: Metrorail Ridership by Origin and Destination

October 31st, 2012 18 comments

Photo courtesy Josh Bancroft (click for original context)

Every day, Metro gathers a vast amount of information on how customers use the system – where and when they pass through turnstiles and board buses, how they pay, and more. There’s much to be learned from this data, and many in the past have done so.  We’ve heard through MindMixer, Metro’s new online community engagement site, that more detailed ridership statistics would be useful.  So in the spirit of open data and collaboration, here’s a data download of rail station-to-station passenger counts, by time period, by day of the week, for May 2012.

May 2012 Metrorail OD Table by Time of Day and Day of Week (.xls, 6.8 MB)

This data can answer many questions, such as: Where do passengers entering at one station go? Where do late-night riders enter the system? How does Saturday ridership differ from Sunday? Which stations are most commuter-oriented, and which are most lively at midday and evening hours?

What does this data tell you? Do you see any patterns? Feel free to post a link in the comments!

What other data that would help answer additional questions?

Technical notes about this data:

  • The data show average ridership, averaged across all days in May 2012, excluding Memorial Day. (We typically use May as an “average” month, since it falls in the middle of seasonal swings, is relatively unaffected by extreme weather, etc.)
  • Time period shows the time the passenger entered (not the time they exited).
  • AM Peak = opening to 9:30am
  • Midday = 9:30am to 3:00pm
  • PM Peak = 3:00pm to 7:00pm
  • Evening = 7:00pm to midnight
  • Late-Night Peak = Friday and Saturday nights only, midnight to closing