Use a local SQL Lite database with positional data to improve the performance of GIS applications

Evaluation of the Wyoming DOT's Road Condition Reporting Application

I-80 and I-25,Cheyenne,Wyoming,United States

Background (Show)

Lesson Learned

The initial implementation was evaluated from January through May 2015 to assess the effectiveness of the application installed on 20 tablets used by plow truck drivers and other staff operating on the I-80 and I-25. The evaluation included quantitative and qualitative analysis including "with-without" methodology. The methodology compared activities using the new application versus the traditional/standard method of using the radio for reporting. Quantitative analysis focused on time spent receiving, logging, and processing reports and actions between the two methods. Qualitative analysis focused on two surveys – one completed by TMC operators and the other by maintenance employees. The survey focused on perceptions, ease of use, overall impressions, and the benefits and shortcoming of the technology.

Key lessons learned are highlighted below.
  • Fully define requirements for positional information. Positional information is very important for maintenance employees (particularly in a blinding snowstorm). A local SQL Lite database with positional data may be required if a GIS application program interface is too slow to support near real-time road condition reporting applications.
  • Test communication systems early. Using the data channel of the WyoLink radio network proved to be more difficult than anticipated. Bugs in communications software not realized prior to the release of the application delayed the project by months.
  • Plan for extensive outreach and training. Significant effort should be invested to inform the TMC operators and maintenance staff about the new system.
Although the deployment was technically complex and required intense management attention, the application improved the effectiveness and efficiency of WYDOT road condition reporting activities and TMC operations.

Lesson Comments

No comments posted to date

Comment on this Lesson

To comment on this lesson, fill in the information below and click on submit. An asterisk (*) indicates a required field. Your name and email address, if provided, will not be posted, but are to contact you, if needed to clarify your comments.


Wyoming Department of Transportation (WYDOT) Road Condition Reporting Application for Weather Responsive Traffic Management: Final Report

Author: Kitchener, Fred (McFarland Management, LLC); Ali Ragan and Vince Garcia (Wyoming DOT); Murat Omay and Michael Waisley (Battelle)

Published By: USDOT Federal Highway Administration

Source Date: 10/1/2015

Other Reference Number: Report No. FHWA-JPO-16-266

URL: https://rosap.ntl.bts.gov/view/dot/3589

Lesson Contacts

Lesson Analyst:

Mike Mercer
(202) 863-3646


Average User Rating

0 ( ratings)

Rate this Lesson

(click stars to rate)

Lesson ID: 2017-00759