Pavement Health Track Remaining Service Life (RSL) Forecasting Models, Hands-On Workbook
Chapter 3 - Working with Highway Data
Objective: Become familiar with the features of the PHT tool for reading, viewing, editing, and selecting highway data records for the PHT analysis.
Specifics: The Highway Data file is a user-provided data file which describes several different characteristics and variables associated with each road section in the user’s system.
The characteristics include:
- identification information such as State, County, Section ID;
- pavement characteristics, such as pavement type, thickness, roughness, rutting, faulting, cracking, etc.
- traffic/capacity data such as AADT, speed limit, peak capacity, percent trucks and future year AADT forecasts.
Formatted similar to the highway performance monitoring system (HPMS 2010) data, the data needs to be in the same order and same structure as HPMS. The source highway data can also be in other formats such as comma-delimited CSV or DBF files or other ODBC connective data sources that can be manually mapped to the PHT database schema.
Use: The PHT tool provides very powerful features to allow a user to view and select highway sections for analysis both manually and automatically using SQL queries and GIS maps.
Tasks:
- Read highway data from an HPMS 2010 formatted file.
- View and manipulate the highway data.
- Select records for analysis.
- Create copies of the highway data.
