Case Study - LTPP DataPave Online

Home > About > Case Studies > LTPP DataPave Online

Pavement Design Improvements through Analysis of Performance Data

WITH THE ADVENT OF LTPP DATAPAVE ONLINE, DISTRIBUTION OF PAVEMENT PERFORMANCE DATA IS CONVENIENTLY ACHIEVED THROUGH LEVERAGING INTERNET TECHNOLOGIES. THE WEB SITE MAKES IT POSSIBLE TO CIRCULATE EVERY NEW RELEASE OF LONG TERM PAVEMENT PERFORMANCE DATA AT ONLY A FRACTION OF THE PREVIOUSLY REQUIRED COST AND TIME.
 
Client

The Federal Highway Administration (FHWA) is a part of the Department of Transportation and is headquartered in Washington, D.C., with field offices across the United States. The vision of the FHWA is to create the best transportation system in the world for the American people through proactive leadership, innovation, and excellence in service.

Challenge

The Long-Term Pavement Performance (LTPP) program that is managed by the Federal Highway Administration (FHWA) is the largest pavement study ever conducted. The objective of this study is to increase pavement life through investigation of the long-term performance of various designs of pavement structures and rehabilitated pavement structures using different materials under different loads, environments, sub grade soils, and maintenance practices.

Establishing a national long-term pavement database to support SHRP objectives and future needs was envisioned as one of the major strategies towards achieving this goal. The LTPP DataPave was developed as a desktop application that allowed users to explore LTPP database. The software along with the database was distributed using CD-ROM media. However, this approach had a few inherent issues.

 

  1. The distribution of LTPP DataPave Software and LTPP database on CD-ROM involved extensive investment of time and other resources into production of CD-ROM packages and delivery to local and international users.
     
  2. The LTPP data are updated very frequently. Thus, every new release of updated data involved further investment in the production and delivery of CD-ROMs to all existing users. In addition, it rendered existing undistributed LTPP packages obsolete.

 

FHWA contracted iENGINEERING to provide a suitable solution to these issues.

Solution

iENGINEERING delivered the LTPP DataPave Online web site to FHWA. This web site has enormously simplified the task of providing worldwide access to LTPP data. It allows users to access all the required features through their web browsers. The online database can be quickly updated with each release of LTPP data, thus providing the latest data access to users at all times. The web site also provides additional features that allow users to download LTPP reference documents and to provide their comments and feedback.
 
The LTPP DataPave Online web site is designed to act as a key enabler of strategies aimed at achieving the LTPP Program objectives by making the LTPP data accessible to the worldwide transportation community. The LTPP DataPave Online web site provides the following features to users:

Vi sualization – Graphical Depiction of Pavement Performance: The LTPP DataPave Online web site provides users with the ability to select and view section-specific information. The objective is to provide mid and upper level managers and other users with quick and easy-to-use presentations to illustrate the value and potential of the LTPP data. This information includes section location, experiment type, pavement layers, and falling weight deflectometer profiles. In addition, performance histories of several key distress indicators can be viewed for the selected sections.
 
Users have the option to select LTPP section of interest through an online US/Canada map to graphically view section specific pavement characterization and performance information.
Users can also select LTPP sections of interest using criteria filters to graphically view section specific pavement characterization and performance information.

Database Tools – Instruments for Utilizing Data: The LTPP DataPave Online Tools provide a user-friendly format for exploring, extracting, and organizing the extensive LTPP data for in-depth analysis.

Data Dictionary – Understanding LTPP Data Elements: Users can explore the LTPP database Data Dictionary to find information on data elements stored in the LTPP database. Data Dictionary provides detailed information on data tables and data attributes. They can also explore LTPP data codes used for numerical coding of data attributes.

Data Export – Freedom of Taking LTPP Data Anywhere: Comprehensive features are provided for exporting data for LTPP sections of interest in Microsoft Access and Excel formats. Users can export data using complex SQL statements to create customized analysis data sets, and combine relational data from multiple database tables to create custom reports for data analysis in Microsoft Access and Excel formats.
 
Support – Providing Help Whenever Needed: The LTPP DataPave Online Help feature provides users with the necessary information to fully utilize the LTPP DataPave Online Web Site.  It also allows users to provide comments and feedback based on their usage experience.

Technology

The LTPP DataPave Online website has been developed using the Active Server Pages (ASP) technology that uses server side processing of information. ActiveX Data Objects technology has been used for database connectivity. The LTPP data is stored in an SQL Server database. Data can be exported in Microsoft Access database format or Microsoft Excel spreadsheet format. A third-party component Chart FX has been used for generating online graphs. Another third-party component Image Toppings has been used for handling section selection from on-screen map.

Additional Information

The LTPP DataPave Online can be accessed at http://www.datapave.com.

Contact Antonio Nieves at (202) 493-3074 or e-mail antonio.nieves@fhwa.dot.gov for additional information on the LTPP DataPave Online or the LTPP Program.

 

If you would like more information regarding the product/service described above or if you would like to implement a similar solution within you organization, please contact Riaz Ahmad at (703) 430-5570 or e-mail rahmad@iengineering.com