April 11, 2007 By Government Technology
Programs like the Utah Department of Transportation's (UDOT) field book application are at the heart of the state's drive toward exceptional technology services. UDOT has used mobile applications to support field staff for nearly a decade, eliminating duplicative processes, cutting costs, and improving employee and contractor experiences.
Ahead of the Curve
"The electronic field book was set up to replace the manual, paper-based information that DOT inspectors were having to collect out in the field to document the work of the contractor," said Blaine Bailey, former UDOT business lead on the field book project. "This enabled us to get rid of hardbound books that they were using to document daily work activities. It also rid the inspectors of having to take that information in those books and manually enter it into a database to get the contractor paid."
Officially launched in 2000, the electronic field book application used HP iPAQ handheld PDAs connected to UDOT's enterprise database using SQL Anywhere's UltraLite database and MobiLink synchronization technology from Sybase iAnywhere. MobiLink allows for easy bidirectional data exchange between UDOT's central and remote databases.
UDOT's goal was to give field inspectors a tool that not only eliminated virtually all manual data entry, but also eliminated duplication. By giving inspectors the power to bring their entire office into the field and allowing single data entry capability, the department hoped to decrease costs and increase job satisfaction, as well as improve business relationships with contractors.
Considering Utah's rugged terrain, it's no surprise that sometimes wireless connectivity is impossible. Six years ago, wireless connectivity was a luxury. To work around that, Utah worked with Sybase iAnywhere to deploy a solution that ensured a break in connection would not spell the end of a field inspector's productivity.
"You can load data onto the handheld from the desktop system and do all your work offline no matter where you are located. Then all you have to do is find a connection back to our desktop system, our Project Development Business System (PDBS)," explained Bob Krum, a programmer analyst for the state Department of Technology Services. The PDBS, built with Sybase PowerBuilder, serves as UDOT's enterprise database. "We were among the first to develop a handheld application talking to an Informix database, and it took a SQL Anywhere database to translate."
Using PDAs instead of laptops saved money while supporting a tremendous number of features. Using the PDA's dropdown menus, a UDOT field inspector has instant access to the contractor's bid items, item stationing on a job site, pay items, quantities of work, labor, what equipment is used, weather and temperature, even what guests have been to the site and when. Field inspection requires extensive documentation, and UDOT eliminated almost all of the manual documentation and data entry processes. In addition, the PDAs include a help menu for every item, adding to the virtual field office and virtual IT staff.
"The hours inspectors previously spent doing manual entry can now be done in minutes," said Bailey. "We've set up a number of locations where they can synchronize with the PDBS. It automatically updates everything directly into
You may use or reference this story with attribution and a link to