Iowa DOT wanted to build APIs to make their real time public data more accessible, and open it to innovative applications.

The team worked with David Runneals (Lakeside Engineering) and Mark McCart (HNTB) to create FME workflows that read traffic operations XML feeds like cameras, DMS, 511 events, and Waze, along with Oracle databases containing additional real time data. These workflows then transform the data through filters and formatters, pushing them out in useable formats, such as Oracle Spatial, ArcGIS Online Feature Services and Feature Collections, and email. They also make the data available to the public via REST services in these formats.

Unlike XML feeds that require a lot of work to visualize, these RESTful services provide Iowa DOT and their external data customers – the traveling public – with the ability to create map mashups of their data with little effort. The processes can also write events to a live Oracle Spatial table and archive the resulting data for future analyses projects.

Iowa DOT maintains over 9,400 miles of roadway and 4,092 bridges to serve the transportation needs of the state’s citizens.

“FME is the cherry on top the ice cream sundae that helps bring data together and customize it for your needs.” – David Runneals, Iowa DOT