Skip to contentU.S. Department of Transportation/Federal Highway Administration
Asset Management | Bridge Technology | Operations | Pavement
FHWA > Asset Management > Pavement Health Track > Working with Highway Data

PHT Hands-On Workbook

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, Route 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 as defined in the HPMS Field manual, appendix G. 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.

Tasks:

  1. Read highway data from an HPMS 2010 formatted file.
  2. View and manipulate the highway data.
  3. Select records for analysis.
  4. Create copies of the highway data.
  5. View a summary of the highway data.
A screen shot highlights the tool bar item Read HPMS Database. A screen shot highlights the directory structure for browsing files in the PHT installation CD. A screen shot highlights the selected file and the open button.
A screen shot shows the window where the user can open a file in the Databases directory. A screen shot shows the data table where the user can review the data and edit the list showing the records that are selected.
A screen shot shows the data table where the user can access a drop down menu of options, with the option to select by query highlighted. A screen shot shows the Filter Wizard tab under the Selection Query tool.
A screen shot shows the Filter Wizard tab under the Selection Query tool with the drop down menu associated with Field. A screen shot shows the Filter Wizard tab under the Selection Query tool with the Function button highlighted in the Criteria cell. A screen shot shows the Filter Criteria drop down menu where the user can select the field, operator, function, and value for the filter operation.
A screen shot shows the Filter Criteria drop down menu where the user can apply or cancel the selected filter query.
A screen shot shows the data table where the user can confirm that filter criteria have been applied to appropriate rows, and a count of the selected highway sections in the table.
A screen shot shows the data table where the user can review options for handling records in the table, including validate all. A screen shot shows the popup information screen that provides a message about the Validation procedure.
A screen shot shows the data table where the user can review the records that are highlighted for validation errors, and select how the error messages are displayed.
A screen shot shows the data table where the user can access the Data panel by double clicking in the left column.
A screen shot shows the data table, with the data panel displayed, where the data items for a selected row are provided in a vertical format.
A screen shot shows the data table, with the Summary tab displayed, where the user can review the values for parameters that are selected.
A screen shot shows the Summary tab, with options Refresh and Parameters highlighted, where the user can select a set of analysis parameters.
A screen shot shows the Settings tab where the user can select a data set and perform a copy operation.
A screen shot shows the Settings tab after a copy operation has been performed and a new file appears in the directory.
Updated: 11/22/2013