U.S. Department of Transportation
Federal Highway Administration
1200 New Jersey Avenue, SE
Washington, DC 20590

Skip to content
Facebook iconYouTube iconTwitter iconFlickr iconLinkedInInstagram

Federal Highway Administration Research and Technology
Coordinating, Developing, and Delivering Highway Transportation Innovations

This report is an archived publication and may contain dated technical, contact, and link information
Publication Number: FHWA-RD-03-088
Date: November 2003

Introduction to The LTPP Information Management System (IMS)

Previous | Table of Contents | Next


The following principles apply for release of LTPP data and information :


All requests for LTPP data and information should be made to the LTPP customer service center. LTPP customer service can be contacted via e-mail at ltppinfo@fhwa.dot.gov. Other contact information is posted on the LTPP Internet Web page.

LTPP data can be obtained through a variety of mechanisms, including standard data release, custom data extraction, and via the DataPave computer program and the Internet.

14.2.1 Standard Data Release

The most up-to-date data from the LTPP program are distributed in January and July in the standard data release format. These data are available free of charge to data requesters. No data restrictions are placed on the content of the data provided in the tables included in the release. The released tables include all data at all levels of RECORD_STATUS.

The standard data release is currently formatted as a series of Microsoft Access 2000 databases based on the North American software version. In the standard release, the pavement performance database is divided into multiple databases by data module. FWD and profile data modules are subdivided by highway agency to meet Microsoft Access database size limitations. The standard data release is currently formatted on five CD-ROMs. The first volume contains the majority of the data modules, while the other compact discs contain the subdivided FWD and profile data sets.

Use of the standard data release requires knowledge of relational database concepts, the relational design of the LTPP database, and features of the Microsoft Access software. Users of the standard release have the flexibility of performing both simple and complex joins between data elements stored in related data tables to create analysis data sets for many types of pavement performance analyses. Appendix C provides examples of how to extract and create an analysis database that can be conveniently queried by exporting tables from the distribution database files.

The structure of the standard data release format also allows users not familiar with the relational database concept to look at the data in separate tables from a spreadsheet viewpoint. Each table is formatted in columns and rows just like an electronic spreadsheet. This self-discovery feature facilitates progression of use of the expanded data manipulation functions offered by database software that is not available in some spreadsheet types of computational software.

LTPP Database Tip!

Because of the volume of LTPP data, LTPP database users should use modern database tools to examine, manipulate, and extract data. Some tables contain more than 1,000,000 records. LTPP customer service can provide limited technical assistance to database users on the use of these tools.

14.2.2 Custom Extractions

Data users can request partial extractions from the database and/or extractions in a nonstandard format. The support and availability of custom data extractions will be evaluated on a case-by-case basis. While users are encouraged to use the standard data release format, database extractions can be conveniently provided in ASCII, comma-delimited ASCII, or Microsoft Excel 2000 formats. Users interested in obtaining data in other formats must contact the LTPP customer service center.

14.2.3 DataPave

The LTPP DataPave program provides a static release of data from a majority of tables in a user-interactive format. The current version of the program is stored on two CD-ROMs and includes only data whose RECORD_STATUS equals E].

DataPave was designed as a training tool for users of LTPP data who are not acquainted with the use of modern database technology. Since it currently contains program modules based on a static data release, it is not possible to provide data updates to the program without a new release. The most current LTPP data can be obtained from the LTPP standard data release, which is updated every 6 months.

14.2.4 LTPP Data Over the Internet

Plans are underway to make LTPP data available for download over the Internet. Check the LTPP Web page for information on data availability over the Internet.

Previous | Table of Contents | Next

Federal Highway Administration | 1200 New Jersey Avenue, SE | Washington, DC 20590 | 202-366-4000
Turner-Fairbank Highway Research Center | 6300 Georgetown Pike | McLean, VA | 22101