U.S. Department of Transportation
Federal Highway Administration
1200 New Jersey Avenue, SE
Washington, DC 20590
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
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 firstname.lastname@example.org. Other contact information is posted on the LTPP Internet Web page.
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.
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.
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.
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.
Topics: research, infrastructure, pavements and materials
Keywords: research, infrastructure, pavements and materials, Asphalt concrete, continuously reinforced concrete pavement, database, database user guide, deflection measurements, dynamic load measurement, general pavement studies, jointed plain concrete pavement, jointed reinforced concrete pavement, LTPP, pavement distress, pavement material properties, pavement performance, pavement profile, portland cement concrete, seasonal variations, specific pavement studies, traffic load
TRT Terms: Pavements--Performance--Databases--Handbooks, manuals, etc, Pavements--Performance--Databases--Management--Handbooks, manuals, etc, Pavements--Maintenance and repair--Management--Handbooks, manuals, etc, Pavement performance, Relational databases