News and events

Kognitio identifies the Worst Bus Stop in London

The worst bus stop in London has finally been revealed.

Kognitio has used Transport for London’s open data to assess the reliability of TfL’s bus schedules.

Kognitio analyzed 4,948,534,706 data points; 19,687 individual bus stops; 675 bus routes; and 9,641 buses, and can confirm that the worst bus stop in London is:

Ringway, Zone 4
(Towards Southall)

This stop only sees 3.62% of its buses arrive on time, based on the timetabled schedule.

The worst stops in each zone

The worst stops in each zone are:

ZoneStop NameTowardsBuses On-Time
Zone 1Percival StreetAngel, Islington7.57%
Zone 2Fulham Leisure CentrePutney Heath / Green Man7.12%
Zone 3Belthorn CrescentStreatham3.64%
Zone 4RingwaySouthall3.62%
Zone 5New Heston RoadEnfield Bus Garage / Southbury Station3.94%
Zone 6Quinta Drive ArkleyHigh Barnet4.6%
Zone 7Mount Vernon HospitalPinner, Northwood Hills or Ruislip9.49%

The best stops in each zone

For comparison, the best performing stops in each zone (which are still quite unreliable) are:

ZoneStop NameTowardsBuses On-Time
Zone 1Clerkenwell Road  Farringdon RdBlackfriars or Waterloo27.77%
Zone 2Stoke Newington CommonHackney Central or Newington Green22.4%
Zone 3Ealing BroadwayRuislip Station27.64%
Zone 4Wilbury WayRookwood Road28.82%
Zone 5Whitings RoadCockfosters Station32.83%
Zone 6Woodlands GroveWapses Lodge Roundabout30.68%
Zone 7Mount Vernon HospitalRickmansworth, South Oxhey or Uxbridge13.47%

Further findings, including the most reliable and unreliable routes and post codes, are available here. Kognitio also built a tool which allows users to check how reliable the buses in their post codes are, compared with the rest of London. See the postcode checker at the bottom of this page.

“This project is important” says Roger Gaskell, CEO at Kognitio. “It’s difficult to find interesting and meaningful samples of large data sets so that you can demonstrate big data analytics in action. By pulling data from the TfL API we were able to create a data set large enough to really show what Kognitio can do and to show how, when using Kognitio with a data visualization tool, in this case Tableau, it can run fast, interactive queries against large datasets held in Hadoop . The output is really fascinating as not only does it show the reliability of buses, it has also highlighted how TfL measures its timetables. They measure their performance based on the predicted times on the electronic boards rather than the published “scheduled” timetable.”

“The most interesting part,” continues Gaskell, “is that in some zones the timetable specifies ‘every x to y minutes’ from a given starting time. We wondered how accurate this was. We looked at the waiting times between buses and found that a lot of bus routes don’t arrive at anything like the timetabled intervals. More often than not you do wait ages and then two buses come along together!”