Public Sector Case Study

  • Google
  • PS

The Challenge

The customer approached Cloudreach to create a cloud-based analytics platform to their transport network to create a safer, more reliable traffic system. This system was designed to leverage Smart Devices across its highways. With multiple data sets, the first challenge was to assess, organize and enrich their data. The second challenge was to democratize access to the data for various internal teams, allowing the data to be used for new purposes.

The Solution

The customer was drawn to Google as a leading provider for consumers, demonstrated through solutions such as Google Maps, Waze and Waymo. With Google Cloud Platform, the customer can leverage the strength of their technologies to build a robust, future-proof data analytics platform that, over time, can be used for machine learning and AI. The solution leverages a serverless architecture that takes advantage of multiple GCP technologies, from data ingestion to through to data analysis with Views on BigQuery and Looker.

In the initial foundational phase, Cloudreach constructed the initial architecture, and developed several data pipelines with a focus on providing an operational view of speed, weather, and incident data. In addition, we migrated a large enterprise data warehouse from Oracle into BigQuery. This helped justify the business case for continued investment into the project.

In the second phase, Cloudreach continued to refine and build the data platform to ingest multiple sources of data, from historical and real-time data gathered from the State’s fleet of IoT devices and events logged by operators into their traffic management system, to third party datasets such as Waze James and weather data provided by NCAR. 

The key technologies used were BigQuery, BigTable, Cloud Spanner, Dataflow, Edge TPU (Planned), BigQuery GIS, Cloud ML, Pub/Sub, and Cloud IoT Core.

The Outcome

The traffic management platform can now be leveraged to enhance situational awareness based on traffic patterns, help coordinate responses based on real-time insights and also predict road and device maintenance.  The utilisation of third party tooling, such as Looker, further democratizes access to the data across various teams and reduces dependence on aging on-premise data center infrastructure. Over time this platform can be used to enable purposes such as public notifications, real-time signaling based on traffic events, variable speed limits and autonomous cars.

Public Sector

Our customer is the Department of Transport for a large US State. Their objective is to ensure a safe and efficient highway system. Rather than building more roads to meet increased congestion and use, they are keen to leverage technology to optimize traffic management - from winter operations to preparing for autonomous vehicles.