Skip to contentUnited States Department of Transportation - Federal Highway Administration FHWA Home
Research Home   |   Pavements Home
Report
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

14.1 DATA RELEASE POLICY

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

14.2 OBTAINING LTPP DATA

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


The Federal Highway Administration (FHWA) is a part of the U.S. Department of Transportation and is headquartered in Washington, D.C., with field offices across the United States. is a major agency of the U.S. Department of Transportation (DOT).
The Federal Highway Administration (FHWA) is a part of the U.S. Department of Transportation and is headquartered in Washington, D.C., with field offices across the United States. is a major agency of the U.S. Department of Transportation (DOT). Provide leadership and technology for the delivery of long life pavements that meet our customers needs and are safe, cost effective, and can be effectively maintained. Federal Highway Administration's (FHWA) R&T Web site portal, which provides access to or information about the Agency’s R&T program, projects, partnerships, publications, and results.
FHWA
United States Department of Transportation - Federal Highway Administration