The objective of this task was to implement a custom data viewer window for the PHT Analysis tool user interface that provides rich features for editing HPMS2010 formatted data, specifically the PHT required data subset.
HPMS is the official source of data on the extent, condition, performance, use, and operating characteristics of the nation's highways. In 2010 the FHWA completed its reassessment of the HPMS data and produced a specification that significantly changes its format, content, and nature from the previous 2000 format specification. The 2010 specification designates the HPMS data to be stored in an active relational database, but still provides a flat file export format. The previous version of the PHT analysis tool used the flat file format and displays it using a simple table viewer with no HPMS-specific capabilities. An HPMS customized viewer window as developed to provide both the HPMS data and the PHT analysis results, with features designed specifically to augment the user experience.
The following features are provided.
The PHT database is the source data for the RSL analysis. It contains the data fields that describe the condition of each highway section. Each record in the database represents a highway section and can be individually selected for analysis. The PHT database window is shown in Figure 80.
The table interprets enumerated values and translates them into human readable text. It also provides for a customizable layout that allows the columns to be arranged and hidden in any why desired by the user. The table is normally in read-only mode to prevent unintentional changes to the highway data, but can be placed in an edit mode if needed.
A vertical oriented panel is available that displays the data items of the selected highway section in a convent format that allows all of the data items to be seen at once. The vertical panel is located on the left of the window and can be expanded by dragging the slider bar to the right.
The PHT database window provides layout formatting, editing, and validation testing through popup menus. The menus are activated by RIGHT-clicking on individual records or on the column headers. Each menu is described in the following paragraphs.
When validation testing has been performed, individual highway sections that have violated one or more validation tests are highlighted with a red shaded background. When one of these errant records is selected, a list of its validation errors is displayed in the panel at the bottom of the window. DOUBLE-clicking on an error message entry will cause the application to jump focus to the specific record and data item that has caused the error. Individual validation rules can be enabled or disabled from the PHT properties window.
The error message panel for the validation rules normally displays the validation errors for the selected highway section; however it can also show all the validation errors of the entire dataset or a list of each unique error message in that dataset. To change how the validation errors are displayed, RIGHT-click on the panel to display its popup menu and select an option under the View menu item.
The first column in the table determines if a highway section will be included in the PHT analysis. If this field is checked, the record will be analyzed by the PHT tool when the analysis is run; otherwise the record will be ignored. To select or unselect a highway section, you can manually click on its checkbox or use the selection commands available from the menu that is activated by RIGHT-clicking on the Select column header. This menu provides the following options for selecting records.
When selecting highway sections by Query, the query builder shown in Figure 81 is used.
The Filter Wizard tab provides an interface to select the data fields and enter the selection criteria to select the records that meet the criteria. The selection can either add to the current selection or replace it entirely.
Users that are comfortable working directly with the SQL language may also enter the SQL text using the SQL text window. The SQL text represents the WHERE clause of a SQL statement and must comply with all SQL syntax rules. This window provides a list of available data fields, operators, built-in functions, and a list of unique values for the selected field.
Normally the Highway Data Viewer window is in a read-only mode with the only edit that are allowed are the setting of the selection column. However, when the need arises to modify the highway data to address validation issues, the highway data viewer can be placed into edit mode which will allow the use r to make any necessary changes.
Placing the Highway Data Viewer window into edit mode is done using the popup menu which appears when you RIGHT click on any record in the table. The items in the Record menu apply to the selected record, while the items in the Table sub-menu apply to the entire table.
These menu items are provided in the Record menu:
|Select||Select the record for analysis|
|Unselect||Unselect the record so it will not be included in the PHT analysis|
|Validate||Perform validation testing on the selected record|
|Table||Displays the Table sub-menu|
|Copy Row(s)||Copy the selected row(s) to the clipboard|
|Copy with Headers||Copy the row(s) along with the column headers to the clipboard|
|Paste||Paste the contents of the clipboard to the table|
These menu items are provided in the Table menu:
|Begin Editing||Place the PHT database window in edit mode to allow user editing of the highway data table. If already in edit mode, this item will labeled End Editing and will terminate the PHT database window edit mode|
|Save||Save all changes to the highway data table|
|Validate All||Validate all records in the highway data table|
|Save Layout||Save the current layout of the table|
|Restore Layout||Restore the default layout of the table|
Each data item provides a popup menu that appears when by RIGHT-clicking on the column header. Items in this menu apply only to the column that was clicked.
|Fill Data||Display a dialog window that allows you to fill the selected column with a new value, overwriting all previously existing values in the column|
|Search and Replace||Display a dialog window that allows search the selected column for a particular value and replace it with a new value|
|Sort||Sort the selected column in ascending or descending order|
|Hide||Hide the selected column|
|Show||List hidden columns so that individual columns can be re-shown|
|Show All||Show all hidden columns|
The Search and Replace window allows you to search a column of data for a particular value and replace it with a new value. The search operation can apply to a selected range or to the entire column. The Fill Data window allows you to fill a column of data with a new value overwriting all previously existing values in the column. The fill operation can apply to a selected range, from the current record to the end of the table, or the entire column.
The Highway Data Viewer window provides a summary of the highway records in the data set to summarize the percentage of highway sections that already have a failing measured distress or have exceed their maximum service life as well as the minimum, maximum, and average distress values and surface age for the rigid, flexible, and composite pavement types. This summary is useful to help assess the highway data set prior to running the analysis.
The distress thresholds and maximum service life durations are defined as part of the PHT analysis parameters. To perform a summary analysis, first select the PHT parameters metrics from the drop-down list at the top of the window and click the Refresh button.
Only the highway sections that are selected in the data set are used when performing the summary analysis. This allows summaries of different subsets of highway sections, by first selecting only the sections of interest and then clicking the Refresh button.
The Copy button on the toolbar will copy the summary analysis results to the Windows clipboard in a format that is compatible with Microsoft® Word or Excel.
After the PHT analysis is complete, the results are displayed in a viewer similar to the highway data viewer window as shown in Figure 84.
The Result Viewer window displays the original highway data that was analyzed by the PHT tool using the same interface as the PHT Database window. The vertical oriented panel on the left of the window provides information about the analysis for the highway data record selected in the table including the RSL estimates, a summary report, and an analysis log. All data items in this window are read-only and cannot be modified.
The Data tab in the vertical panel provides a view of the PHT analysis results for the highway data record selected in the table. All the RSL data items can be displayed, or you can filter the display into categories using a popup menu that appears when you RIGHT-click anywhere on the data list. The filtering options include RSL by years, by ESALs, and user-defined fields
The Log tab is only available if a log file has been captured during the analysis and the file is available for display. The content of the log file is determined by the logging properties that are set as part of the PHT properties. It displays the log entries created in the log file for the highway data record selected in the table. The log entries are useful to track the analysis process to aid in understanding the results. Each log entry is identified as an error, warning, or informational message.
The Summary tab provides a user-friendly readable summary of the analysis results for the highway data record selected in the table as shown in Figure 85. The summary highlights the estimated RSL for the pavement surface and illustrates the distresses and service life limits that contributed to the RSL estimate. It also annotates the analysis with notes that describe the pavement construction and any unusual conditions in the data.
The result summary can provide the following annotations.