Integrating MDOT’s business data with its geographic data using Oracle Spatial

Integrating MDOT’s business data with its geographic data using Oracle Spatial

Client: Michigan Department of Transportation

Challenge

The Michigan Department of Transportation (MDOT) is responsible for planning, designing, building and operating streets, highways, bridges, transit systems, airports, railroads and ports. MDOT used separate systems to manage the geographic data and the business data (using a linear referencing system) describing the state’s transportation network. Because, the LRS technology was not geographically referenced, MDOT’s ability to automate data validation procedures and perform real-time spatial analyses of the State’s transportation network was impaired.

Solution

The solution was to integrate MDOT’s business data with its geographic data. Given MDOT’s use of Oracle as its core database management system, Oracle Spatial (a module that enables a 10g database to manage and analyze geometry features, perform linear referencing and network analyses) offered an integrated means of solving MDOT’s data management and analysis problem.

Farallon Geographics performed an assessment to evaluate the viability of integrating MDOT’s LRS with Oracle Spatial. Farallon started with a small subset of MDOT’s data to determine how to optimally configure it. Based on this pilot, Farallon developed a data model capable of supporting MDOT’s transportation system workflows. Using findings from the pilot, Farallon created a roadmap for MDOT to approach the migration to an enterprise-scale Oracle Spatial environment, and then helped to integrate the Oracle Spatial platform with MDOT’s data.

In addition Farallon developed dynamic segmentation procedures that link tabular data (e.g., traffic reports) on-the-fly to visualization of road segments without building new geometry data. This approach enables MDOT users to access an integrated datastore to answer queries such as: how to optimally route traffic during construction or unusually high traffic conditions, or to find the shortest fastest route to take for oversized trucks to avoid low bridges.

Farallon enabled MDOT to access mapping and business data dynamically for the first time, resulting in a greatly enhanced ability for MDOT personnel to efficiently conduct business operations.