Skip to content

Converting a Snowplow’s Unconventional CSV into Timecards & Winter Operations Performance Metrics

Date
Wednesday, May 12, 2021
Presenters
Mark McCart
Presenter Company
Esri (Idaho Transporation Department)
Event
FME World Fair 2021
Session Type
User
Industry
Transportation

Presentation Details

Learn how Idaho Transportation Department (ITD) leveraged FME and FME Server to improve the processing of text-based log files from their snowplow fleet and turned them into timecards, integrated with their asset management system (Agile Assets) and automated winter operations metrics. This solution includes flattening out an unconventional CSV file, locating plows along a linear referencing system (LRS), generating a JSON Message and sending it to another system, polling live XML-based roadway sensors information service and finally automating a complex Excel-based algorithm and putting that data on a map. I will also cover some lessons learned along the way. This project had plenty of twists and turns along the way and I cant wait to share them with you.