Weekly Open Data: are SNCF’s TGV trains always late?

We have the pleasure to present you our brand new series « Weekly Open Data». At OpenDataSoft, we love to roam the Internet to find the best datasets there are. We have decided to launch this on-going series with an infographic about TGV trains lateness, based on SNCF (French National Railway Company) regularity barometer published earlier this month. SNCF made its first move towards Open Data and Open Innovation during 2011. Its Open Data portal data.sncf.com has been powered by OpenDataSoft since 2012 and has allowed the company to share up to 45 datasets.
Today’s story began when our mascot and customer Bruce complained at lunch about high-speed TGV trains being constantly late. Discussion raged in our office for a few minutes. Only listening to our courage, we braced ourselves and decided to investigate the matter. Thanks to the analysis features of our SaaS solution and the open data available at ressources.sncf.com, we have been able to cast some light on this mystery. So, are TGV trains always late?
The investigation
We first looked at the dataset “TGV trains monthly regularity” which compiles possible delays on every TGV. To get a contextual picture of the situation, we compared trains in circulation against those being late for July 2014. This first axis revealed strong differences between trains to and fro the East and the South of France.
Then, we focused on the Lille-Marseille line. A mere click on the « Départ » facet quickly showed that the line incurs more delays than the Lille-Paris or the Lille-Lyon ones.
As Bruce also takes the TGV to go and visit his parents in La Rochelle, we explored this line as well. Looking at the embedded visualization, you’ll see that Bruce will be more subject to delays than travellers going to Poitiers or Angoulême which both are on the same line. A quick search on Google will give us an explanation : SNCF is currently extending the high-speed line from Tours to Bordeaux which causes delays. However, when the high-speed line will be finished, Bruce will save a magnificent 25 minutes on his journey. Lucky Bruce!
And this is the story of how we proved Bruce that TGV trains are not always late.
Thanks to OpenDataSoft’s analytics features, users can understand complex datasets through interactive visualizations that can easily be embedded in any web page. Maps and graphs will automatically be updated every time the dataset will be modified.
With OpenDataSoft, data speak for themselves…
Learn more
SNCF Reseau uses private data sharing to make its engineers’ work easier
SNCF Réseau’s Quality and Methods department was looking for a way to help its engineers gather primary data (i.e. topographic data or core samples) more easily and to make the most out of the existing data within the organization. The division was looking for a solution capable of: Making internal data available to all project and study teams Encouraging data sharing between the various groups of engineers Cutting costs associated with data duplication within the division
Interview with Stéphane Avronsart from SNCF Réseau
We sat down for a chat with Stéphane Avronsart, Head of Quality & Methods for the Project and Engineering Division at SNCF Réseau, to find out more about why the company decided to pursue a private data sharing initiative.
How data sharing is shaping the future of mobility
In the relaxing seaside town of Pesaro, central Italy, moving around has never been more convenient – nor more sustainable. Imagine looking for a parking spot, paying for the actual time you occupied it, renting a bike, finding your way through the Bicipolitana – through just one app.
SNCF Reseau uses private data sharing to make its engineers’ work easier
SNCF Réseau’s Quality and Methods department was looking for a way to help its engineers gather primary data (i.e. topographic data or core samples) more easily and to make the most out of the existing data within the organization. The division was looking for a solution capable of: Making internal data available to all project and study teams Encouraging data sharing between the various groups of engineers Cutting costs associated with data duplication within the division
Interview with Stéphane Avronsart from SNCF Réseau
We sat down for a chat with Stéphane Avronsart, Head of Quality & Methods for the Project and Engineering Division at SNCF Réseau, to find out more about why the company decided to pursue a private data sharing initiative.
How data sharing is shaping the future of mobility
In the relaxing seaside town of Pesaro, central Italy, moving around has never been more convenient – nor more sustainable. Imagine looking for a parking spot, paying for the actual time you occupied it, renting a bike, finding your way through the Bicipolitana – through just one app.