Tag Archives: Data Portal

THREE YEARS OF PLANNED PROJECTS

A new UPLAN gallery of web maps and apps, with information about upcoming projects, is now available through UPlan.

The gallery makes data on the UDOT Three Year Plan available to project managers, UDOT employees, policy makers and the general public. Projects are organized by program funding source, year and UDOT region. The gallery also has a web map of future planning through 2020.

The live data advantage

The online information can be referenced by employees across the department, or by UDOT and local governments to assure that all are viewing and using the correct information. The project data is updated nightly, so data is kept as current as possible.

Having dynamic, easily accessible information via the gallery enhances collaboration across UDOT divisions so projects can be synchronized to use resources effectively and reduce impact to the public. The gallery improves agency transparency since anyone with a web connection can use the gallery to view planned projects.

What is UDOT’s Three Year Plan?

Screen Shot of the Three Year Plan WebsiteThe projects in the Three Year Plan have been identified and prioritized by each of the four UDOT regions. The projects address UDOT’s three strategic goals, Zero Crashes, Injuries and Fatalities, Optimize Mobility, and Preserve Infrastructure.  Funding sources have also been identified for each project.

The main advantage for UDOT in having a three year program of road construction projects is coordination, says William Lawrence, Director of UDOT Program Finance. The plan lets the department evaluate the program as a whole and “helps maximize efficiency,” he says. For example, two projects in close proximity in American Fork, each planned for different years, were recently combined into one project that will take place in 2017. In this case, combining projects is a better use of financial resources, and “construction will only impact the public once,” says Lawrence.

To find the Three Year Plan gallery, access the UDOT Data Portal at data.utah.gov, click the UPLAN thumbnail, then click the 3-Year Plan thumbnail in UPLAN. Instructions for searching for or sorting projects are included in the gallery.

Auto-generated summary sheets

Photo of John Guymon

John Guymon, UDOT Rotational Engineer

For each roadway preservation or rehabilitation project, UDOT designers fill out a summary sheet that provides a tally of measurements and material quantities needed for the project. Collecting data on-site, compiling data and figuring quantities can take a week or more. “You go out into the field with a wheel and tape, and you measure everything,” says UDOT rotational engineer John Guymon. His work to integrate online data with a spreadsheet is helping UDOT designers work more efficiently.

Guymon used coding and Microsoft Excel to create a form that uses asset management data and standard formulas for figuring material quantities to populate the summary sheet. The data sets are housed in the UDOT Data Portal, UDOT’s online data repository.

The Auto Report Generator is simple to use, and works along with the Linear Bench tool, both accessible on the UDOT Data Portal. Step-by-step instructions are available with the form. Once produced, the summary sheet shows:

  • Pavement type, surface area and material amounts for granular borrow and base course. The pavement type generated in the report is specific to the region, since climate differences around the state call for different pavement types.
  • Barrier in the project area, including location, total feet, and post type, all sorted into standard and non-standard types to show any areas in need of full replacement.
  • Signs, including location, sign type, size and any damage present during data collection.
  • Pavement marking type, paint amounts, messages, and rumble strips or grooved-in paint.

Once the summary sheet has been populated, the sheet can be used to verify measurements, barrier type, roadway geometry, pavement messages, etc.

So far, the new form has been downloaded over 600 times since it became available, about two months ago, and users have become instant fans. Kendall Draney says that one advantage is that using the form keeps employees out of harm’s way. Draney used the form as a design rotational engineer in Region Three. Sometimes getting measurements necessitates a dash across a busy roadway. “It’s really nice to have something that you’re using to verify,” says Draney. “It’s much safer to be on the shoulder.”

Engineering Tech IV Lynda Seckletstewa likes the consistency of the quantity amounts generated by the reports and “quantities for the existing features pulled by the report generator are within 2% of field quantities.”

The reports also provide “an instant checklist for field reviews,” says Seckletstewa. “Generated notes for various features point out deficiencies that we may have otherwise overlooked.”

The new summary form is an example of how UDOT is making good use of data collected on everything on a state roadway that can be viewed through a car window. “I didn’t realize how useful the Mandli data would be,” says Guymon. He views the tool as a first effort that can be improved over time.

Find out about other ways to view data, including the Linear Bench and Highway Reference Online, on the UDOT Data Portal.

Read about the Mandli data-gathering effort here.