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


Skip to content
Facebook iconYouTube iconTwitter iconFlickr iconLinkedInInstagram

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

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)

PDF Version (1.56 MB)

PDF files can be viewed with the Acrobat® Reader®

FOREWORD

This document provides information to aid in understanding and using the Long-Term Pavement Performance (LTPP) program pavement performance database. This document provides an introduction to the structure of the LTPP program, the relational structure of the LTPP database, a description of the location of various data elements, contents of the data tables, tips on efficient means of manipulating data for specific types of investigations, and examples of Structured Query Language (SQL) scripts that can be used to build user-defined custom extractions.   The LTPP program is an ongoing and active program. To obtain current information and access to other technical references, LTPP data users should visit the LTPP Web site . LTPP data requests, technical questions, and data user feedback can be submitted to LTPP customer service via e-mail at ltppinfo@fhwa.dot.gov .    

T. Paul Teng, P.E.

Director, Office of Infrastructure
Research and Development

 

NOTICE

This document is distributed under the sponsorship of the U.S. Department of Transportation in the interest of information exchange. The U.S. Government assumes no liability for its contents or use thereof. This report does not constitute a standard, specification, or regulation.   The U.S. Government does not endorse products or manufacturers. Trade and manufacturers' names appear in this report only because they are considered essential to the object of the document.


Technical Report Documentation Page

Form DOT F 1700.7 (8-72)

1. Report No.
FHWA-RD-03-088

2. Government Accession No.

3. Recipient's Catalog No.

4. Title and Subtitle
LONG-TERM PAVEMENT PERFORMANCE
INFORMATION MANAGEMENT SYSTEM
PAVEMENT PERFORMANCE DATABASE USER GUIDE

5. Report Date
November 2003

6. Performing Organization Code

7. Author(s)
Gary E. Elkins, Peter Schmalzer, Travis Thompson, and Amy Simpson

8. Performing Organization Report No.

9. Performing Organization Name and Address
MACTEC Engineering and Consulting, Inc.
12104 Indian Creek Court, Suite A
Beltsville, MD 20705-1242

10. Work Unit No. (TRAIS)

11. Contract or Grant No.
DTFH61-02-C-00007

12. Sponsoring Agency Name and Address
Office of Infrastructure Research and Development
Federal Highway Administration
6300 Georgetown Pike
McLean, VA 22101-2296

13. Type of Report and Period Covered
Final Report, August 2002- June 2003

14. Sponsoring Agency Code

15. Supplementary Notes
Contracting Officer's Technical Representative (COTR): Aramis Lopez, Jr., HRDI-13

16. Abstract
This document provides information to aid in understanding and using the Long-Term Pavement Performance (LTPP) program pavement performance database. This document provides an introduction to the structure of the LTPP program, the relational structure of the LTPP database, a description of the location of various data elements, contents of the data table, tips on efficient means of manipulating data for specific types of investigations, how to obtain data, and example Structured Query Language (SQL) scripts that can be used to build user-defined custom extractions.

17. Key Words
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.

18. Distribution Statement
No restrictions. This document is available to the public through the National Technical Information Service, Springfield, VA 22161.

19. Security Classif. (of this report)
Unclassified

20. Security Classif. (of this page)
Unclassified

21. No. of Pages
171

22. Price

Reproduction of completed page authorized

SI* (Modern Metric) Conversion Factors


TABLE OF CONTENTS

CHAPTER 1. LTPP PROGRAM OVERVIEW

1.1 BACKGROUND

1.2 OBJECTIVES AND SCOPE OF THE LTPP PROGRAM

1.3 TEST SECTION DESIGNATIONS

1.3.1 General Pavement Studies

1.3.2 Specific Pavement Studies

1.4 TEST SECTION LAYOUT

1.5 REFERENCE MATERIALS

CHAPTER 2. INTRODUCTION TO THE PAVEMENT PERFORMANCE DATABASE

2.1 RELATIONAL DATABASES AND STRUCTURED QUERY LANGUAGE

2.2 QUALITY CONTROL

2.3 GPS AND SPS SECTION IDENTIFICATION

2.4 MODULES

CHAPTER 3. ADMINISTRATION MODULE

3.1 EXPERIMENT_SECTION TABLE

3.2 LTPPDD TABLE

3.3 CODES

3.4 COMMENTS_GENERAL

3.5 REGIONS

CHAPTER 4. AUTOMATED WEATHER STATION MODULE

4.1 IMPORTANT FIELDS

4.2 AWS TABLES

CHAPTER 5. CLIMATE MODULE

5.1 IMPORTANT FIELDS

5.2 CLM TABLES

5.2.1 Online CLM Tables

5.2.2 Offline CLM Tables

5.2.3 Tables in Other Modules

5.3 CALCULATIONS

5.3.1 VWS Calculations

5.3.2 Freezing Index

CHAPTER 6. DYNAMIC LOAD RESPONSE MODULE

6.1 IMPORTANT FIELDS

6.2 DLR TABLES

CHAPTER 7. INVENTORY MODULE

7.1 INV TABLES

CHAPTER 8. MAINTENANCE AND REHABILITATION MODULES

8.1 IMPORTANT FIELDS

8.2 MNT TABLES

8.3 RHB TABLES

8.3.1 Nonrehabilitation-Specific Tables

8.3.2 RHB Tables for AC Overlays

8.3.3 RHB Tables for PCC Overlays

8.3.4 Non-Overlay RHB Tables

8.4 TABLES IN OTHER MODULES

CHAPTER 9. PAVEMENT MONITORING MODULE

9.1 PHOTOGRAPHIC AND MANUAL DISTRESS

9.1.1 MON_DIS Tables

9.2 TRANSVERSE PROFILE DISTORTION

9.2.1 MON_T_PROF Tables

9.2.2 MON_RUT_DEPTH_POINT Table

9.3 LONGITUDINAL PROFILE

9.3.1 MON_PROFILE Tables

9.4 DEFLECTION MEASUREMENTS

9.4.1 MON_DEFL Tables

9.5 BACKCALCULATION TABLES

9.6 FRICTION

9.7 DRAINAGE

CHAPTER 10. SEASONAL MONITORING PROGRAM MODULE

10.1 DATA TABLES

10.1.1 Ambient Temperature and Precipitation

10.1.2 Subsurface Temperature

10.1.3 Subsurface Moisture Content

10.1.4 Frost Penetration

10.1.5 Depth to Water Table

10.1.6 Surface Elevation Data

10.1.7 Joint Opening and Faulting

10.1.8 Additional SMP Tables

CHAPTER 11. SPECIFIC PAVEMENT STUDIES MODULE

11.1 IMPORTANT FIELDS

11.2 GENERAL SPS TABLES

11.3 NUMBERED TABLES COMMON TO MULTIPLE EXPERIMENTS

11.4 TABLES SPECIFIC TO INDIVIDUAL EXPERIMENTS

CHAPTER 12. TRAFFIC MODULE

12.1 IMPORTANT FIELDS

12.2 TRF TABLES

CHAPTER 13. MATERIALS TESTING MODULE

13.1 BACKGROUND

13.2 MATERIALS TEST TYPES

13.3 IMPORTANT FIELDS

13.4 UNDERSTANDING THE MATERIALS TESTING DATA STRUCTURES

13.4.1 Test Results Tables

13.4.2 Sampling Information Tables

13.4.3 Layer Tables

13.4.4 SPS Complications

13.5 KEY TABLES

13.5.1 TST_L05B

CHAPTER 14. OBTAINING LTPP DATA

14.1 DATA RELEASE POLICY

14.2 OBTAINING LTPP DATA

14.2.1 Standard Data Release

14.2.2 Custom Extractions

14.2.3 DataPave

14.2.4 LTPP Data Over the Internet

APPENDIX A. LTPP OPERATIONS REFERENCE DOCUMENTS

A.1 GENERAL

A.2 PAVEMENT MONITORING

A.3 MATERIALS SAMPLING AND TESTING

A.4 SEASONAL MONITORING PROGRAM

A.5 GPS EXPERIMENTS

A.6 SPS EXPERIMENTS

A.7 TRAFFIC DATA

A.8 CLIMATIC DATA

A.9 DYNAMIC LOAD RESPONSE DATA

A.10 SITE REPORTS

A.10.1 SPS Materials Sampling, Field Testing, and Laboratory Testing Plans

A.10.2 SPS Construction Reports

A.10.3 SMP Installation Reports

APPENDIX B. EXPERIMENT DEFINITIONS

B.1 GPS EXPERIMENTS

B.1.1 GPS-1: Asphalt Concrete on Granular Base

B.1.2 GPS-2: Asphalt Concrete on Bound Base

B.1.3 GPS-3: Jointed Plain Concrete Pavement (JPCP)

B.1.4 GPS-4: Jointed Reinforced Concrete Pavement (JRCP)

B.1.5 GPS-5: Continuously Reinforced Concrete Pavement (CRCP)

B.1.6 GPS-6: Asphalt Concrete Overlay of Asphalt Concrete Pavement

B.1.7 GPS-7: Rehabilitated Portland Cement Concrete Pavement

B.1.8 GPS-9: Unbound PCC Overlays of PCC

B.2 SPS EXPERIMENTS

B.2.1 SPS-1: Structural Factors for Flexible Pavements

B.2.2 SPS-2: Structural Factors for Rigid Pavements

B.2.3 SPS-3: Preventive Maintenance Effectiveness of Flexible Pavements

B.2.4 SPS-4: Preventive Maintenance Effectiveness of Rigid Pavements

B.2.5 SPS-5: Rehabilitation of Asphalt Concrete Pavements

B.2.6 SPS-6: Rehabilitation of Jointed Portland Cement Concrete (JPCC) Pavements

B.2.7 SPS-7: Bonded Concrete Overlays of Concrete Pavements

B.2.8 SPS-8: Environmental Effects in the Absence of Heavy Loads

B.2.9 SPS-9: Validation of SHRP Asphalt Specifications and Mix Design

APPENDIX C. DATA EXTRACTION EXAMPLES

C.1 SMP DATA

C.1.1 Ambient Temperature and Precipitation

C.1.2 Subsurface Temperatures

C.1.3 Subsurface Moisture

C.1.4 Electrical Resistance and Resistivity

C.2 BACKCALCULATION

C.2.1 MON_DEFL Database Tables

C.2.2 Temperature Tables

C.2.3 Deflection Tables

C.2.4 Layer Information Tables

C.2.5 Laboratory Materials Testing Data

INDEX

 

LIST OF FIGURES

Figure 1. Layout of a generic GPS test section

Figure 2. Example layout of a generic SPS project

Figure 3. Relational structure of data stored in the DLR module

Figure 4. Illustration of how transverse profile measurements are normalized to lane edges

Figure 5. Illustration of LTPP transverse pavement distortion indices based on 1.8-m (6-ft) straightedge reference. Distortion indices are computed for each half of the lane, including depth, offset to point of maximum depth, and depression width

Figure 6. Illustration of LTPP transverse pavement distortion indices based on lane-width wireline reference. Distortion indices are computed for each half of the lane, including depth, offset, and depression width

Figure 7. Relational structure among tables in the MON_T_PROF module

Figure 8. Structural relationship between tables used to store FWD data

Figure 9. Illustration of relationships among TST_AC07* tables

Figure 10. Illustration of relationships among TST_UG07_SS07* tables

Figure 11. Plan view of hypothetical SPS project (not to scale)

Figure 12. Cross-sectional view of hypothetical SPS project

LIST OF TABLES

Table 1. List of GPS experiments

Table 2. List of SPS experiments by category

Table 3. IMP_TYPE and expected location of data in MNT and RHB tables

Table 4. FHWA 13-bin vehicle classification system

Table 5. Materials testing designations and protocols

LIST OF ACRONYMS AND ABBREVIATIONS

AADT Annual average daily traffic

AASHO American Association of State Highway Officials

AASHTO American Association of State Highway and Transportation Officials

AC Asphalt concrete

ASTM American Society for Testing and Materials

ATB Asphalt-treated base

AVC Automated vehicle classification

AWS Automated weather station

BBR Bending-beam rheometer

CCC Canadian Climatic Center

CRCP Continuously reinforced concrete pavement

DLR Dynamic load response

DSR Dynamic shear rheometer

DT Direct tension

ESAL Equivalent single-axle load

FHWA Federal Highway Administration

FIPS Federal Information Processing Standards

FWD Falling-weight deflectometer

GPS General Pavement Studies

HMA Hot-mix asphalt

HMAC Hot-mix asphalt concrete

IRI International Roughness Index

JPCC Jointed portland cement concrete

JPCP Jointed plain concrete pavement

JRCP Jointed reinforced concrete pavement

LEF Load equivalency factor

LTPP Long-Term Pavement Performance

LVDT Linear variable differential transformer

NCDC National Climatic Data Center

NCHRP National Cooperative Highway Research Program

NRC National Research Council

OWS Operating weather stations

PADIAS Pavement Distress Analysis System

PATB Permeable asphalt-treated base

PCC Portland cement concrete

PMA Plant-mixed asphalt

PVR Potential vertical rise

QC Quality control

RDBMS Relational database management system

RMSVA Root mean square vertical acceleration

SAMI Stress-absorbing membrane interlayers

SHRP Strategic Highway Research Program

SI International System of Units

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