Public Transport Data Management

Client: Otago Regional Council

Designer: IT Effect

IT Effect has developed a timetable data management system to overcome the existing challenges transport planners and communication teams face.


This system provides a single source timetable database which programmatically provides accurate, up to date data to:


  • Council’s transport website
  • Google Transport / Journey Planner
  • Regional Integrated Ticketing System
  • Programmatically generated updates of on-street timetables
  • Programmatically generated updates of route timetables

Users of public transport engage with timetabling information in a range of ways both on and offline. This creates a challenge for those managing the flow of timetable information.


With the upcoming introduction of the Regional Integrated Ticketing System, IT Effect was engaged by Otago Regional Council to streamline their public transport
data management.

ORC 1.png

A few of the challenges they faced were as follows:


  • There are multiple end sources for public transport timetable data, both electronic and hard copy.
  • Providing numerous transport data feeds to various sources increases the opportunity for errors and discrepancies between end sources.
  • There was no single source of the truth in relation to timetable data. This leads to double handling of data, errors and ultimately confusion among public transport users.
  • Cost inefficiencies to engage multiple suppliers every time a change is made to timetables.
ORC 2.jpg
ORC 4.jpg

The benefits of our timetable data management system:


  • Removes opportunity for errors to exist between timetable sources
  • Only need to update transport data in one place
  • Removes needs for a designer to update PDF’s, printed timetables and on-street timetabling
  • Changes to all outputs are now streamlined
ORC 3.png
Thanks to IT Effect the updates to all of our digital and printed timetables have been significantly streamlined. The timely and accurate communication of bus timetables has contributed to a significant increase in patronage and user satisfaction

Julian Phillips, Public Transport Team Lead

ORC 5.jpg
IT Effect delivers digital solutions for organisations across the country with offices in Wellington and Dunedin.


We provide bespoke software development, website development, design and user experience. We specialise in making sense of data so if you’d like to find out more about we can help you manage your public transport data, get in touch.