Exceeding Customer Expectations
The agency extracts about 1TB of data monthly from the train CCTVs and at least 8PBs of data weekly from street cameras mounted at intersections. In addition, the Microsoft SQL Server-based warehouse holds around 3TBs of data. The IDOL data analytics platform processes CCTV video analytics, integrating that data into the incident management system, also on the IDOL platform.
Approximately 200 video analytic schemes run in real time, enabling staff to respond to issues that make 1.4 million citizens safer on the road. Agency personnel can detect traffic violations, congestion, and parking problems, as well as harness patterns uncovered by the IDOL platform.
“The public safety is a huge step increase,” Jones admits. “That has financial ROI across the medical and broader community spectrums. As a transport agency, our IDOL analytics platform is helping us exceed customer expectations and shape positive perceptions.”
Putting the data to work, the agency has gained an integrated ticketing system with insight on travel times, patterns, trip frequen - cies, and demographics.
“We can now start to tailor our messaging, especially for transport, to the stops where people are at the right time of day,” Jones says. Instead of conducting ad-hoc surveys, city planners can use the real-time data from license plates to construct heavy transport and trucking options.
“This is very much about the planners having reliable information,” Jones says.
Enabling Strong Analytics
Current statistics and other significant volumes of data—such as the parking system— reside on the Micro Focus Vertica analytics platform, which processes structured data quickly. IDOL accelerates the delivery of relevant knowledge, linking statistics with historic corporate information and financials in the SQL warehouse.
The warehouse data integrates with the Vertica and API Management Solution data stores to provide integrated reports at the front end. The data analytics platform provides faster end-toend batch file processing. Previously, batch processing took 4.5+ hours. As a result, service, bus, and ferry operators could not leverage needed information when starting their work day. Now, batch processing finishes in 2 hours.
“We have a huge performance increase,” Jones explains. “When the operators come in to work, they have yesterday’s information, and they can make the right business decisions. The API Management Solution platform can manage streaming of high data volumes at high velocities.”
Through its investment in big data technologies from Micro Focus, Auckland Transport is building upon its “Future Cities” vision, one in which developers and officials employ all types of data, sensors, and technologies to improve products and services for their citizenry. Jones sees the agency continuing to enhance resident experiences as more agency stakeholders and partners fully grasp the potential of big data.
“We are looking to enable them to take that data and do something with it, find patterns we don’t have the expertise to find, and deliver value back to us and to everyone else. We’ve provided the platform and enabler. They must pick it up and run with it,” he concludes.