: Help

No. The public data release through Standard Data Release (SDR) is only a part of the LTPP data resources.
 
With LTPP InfoPave, users are provided meaningful and easy access to all LTPP data with the supporting technological applications and tools. Unlike the Standard Data Release, the user needs minimal previous exposure to the LTPP data to find a specific data set. Specifically, the pavement performance database included in the SDR is the same as that in InfoPave, but in InfoPave, it is meaningfully organized for the user with user friendly table and field names and the data expanded to section level to facilitate easy data access. In addition, InfoPave provides access to research documents and ancillary information management system (AIMS) data that supplement the Pavement Performance Database (PPDB) data which were never part of the standard data release (SDR) due to space constraints. 

To efficiently retrieve a large amount of data from a particular table or tables, use the SQL Export feature listed under the “Data” module. This feature also includes sample SQL codes, which you can modify for your needs. An example SQL statement for selecting all the data from MON_FRICTION table is "SELECT * FROM MON_FRICTION". Due to download size constraints, very large SQL queries such as all data from MON_HSS_PROFILE_SECTION table will not execute. Downloading from LTPP Standard Data Release is recommended to obtain extra-large data sets.

Once the data is selected and added to data bucket for download using the data selection and download feature, the ‘Data Bucket’ screen provides options such as “Submit Data for Extraction”, “Save”, “Clear”, and “Continue to Data Selection”. Selecting the “Save” option will save the data bucket for extraction later. You can access the saved data buckets (“My Data Buckets”) and downloaded data extractions (“My Data Extractions”) under "under your name". Once you download a data bucket, it will be transferred to the “My Data Extractions” section. My Data Extractions shows the status of each extraction (In Progress or Completed). The completed data extractions can be re-downloaded for up to 7 days. The time to complete the data extraction depends on the data size selected for download and the order in the queue while submitting. You will receive an email notifying the completion of data extraction.

There are two useful tools within InfoPave that can assist you to get an overview of any selected LTPP section. The first one is the “Section Summary Report” which tabulates a summary of section location, pavement structure, materials, climate, traffic, and performance data. The second is the “Section Timeline” which provides an overview of the history of each LTPP section. This timeline includes maintenance and rehabilitation treatments as well as materials testing and performance monitoring activities during the lifetime of LTPP sections. Both of these useful tools are available through the Data module.

Currently there is no file size limit for download in LTPP InfoPave.

However, the file type may change depending upon the number of records in the selected data bucket. If the number of records is less than 0.5 Million, the data can be downloaded in Excel. If the number of records goes up to 5 Million, it can be downloaded in Access. If the number of records exceeds five million, the data will only be downloaded in SQL files each having up to 10 million records.

Yes. You can access the latest LTPP Standard Data Release through the Data module. This data can be downloaded in Microsoft Access format. You can choose to download the standard data release by volume or by state.

Currently, LTPP InfoPave supports exporting five hundred thousand records in Microsoft Excel and five million records in Microsoft Access. Moreover, when exporting data which exceeds five hundred thousand records, the only download file format available is Microsoft Access format. This constraint is set to limit server resource utilization for data export as well as satisfy the limitation on the number of records supported by Microsoft Excel and Microsoft Access. With this constraint, very large SQL queries (e.g., select * from MON_HSS_PROFILE_ELEVATION_25) will not execute. We recommend downloading LTPP Standard Data Release to obtain extra-large data sets.

InfoPave provides access to the pavement performance database (PPDB), ancillary information management system (AIMS) data that supplements the PPDB data, and all the LTPP program research documents. The PPDB and AIMS data and the research documents provided through InfoPave is based on the latest Standard Data Release. All data collected under the LTPP program is available through LTPP InfoPave. For any data that you were unable to locate, please submit your request through "Customer Support".

Even if you are not familiar with LTPP tables, LTPP InfoPave has multiple features (user-friendly data structure, data prioritization, data customization) that help you to find the desired information. Data Selection and Download is the most frequently used feature within LTPP InfoPave, where data is organized for the user to easily gain familiarization with the various data elements in LTPP and access them for download.

After narrowing down (filtering) your search of LTPP sections using “Find Sections”, you can select your desired tables listed under structure, climate, traffic, and performance classes with further applicable sub classes. If you check the option “Show Advanced Data Classification”, additional classes (of lower or lesser priority) will also be displayed. Each sub class might be a single table or group of tables that together contain the information you need. If you hover over each table title, you will see a description of that table. In addition, in accordance with the filters applied to “Find Sections,” it displays the count of sections for which the table has data. While selecting the data, displaying the count of sections allows the user to know if the data is available for all selected sections. With “Show Advanced Data Classification” selected, you can see the list of the fields within each table and customize it to select only those in which you are interested. The downloaded file will include your data individually by each selected tables (Table Names), a separate list of the tables with their descriptions (Table Reference), a table listing all the included fields and their descriptions (Field Reference), and a table listing all other used codes and their descriptions (Codes Reference).

The frequency of data update will be in accordance with the LTPP data release policy. LTPP InfoPave will be updated for each public data release, which is currently being done annually.

A .bak file is an export from a MS SQL database. To read the file install a free version of MS SQL Server (Developer or Express).

Open the installed database. If the database was opened MS SQL Server Management Studio after connecting to the instance there should be an entry Databases.  If the downloaded LTPP database was not listed as one of the databases under that entry after expansion, it hasn’t been restored yet.

• To restore the database export (*.bak), right click on Databases.
• Select Restore Database.
• Select Device as Source.
• Browse for backup up media type File and add the .bak file location where the LTPP data file was unzipped.
• Click Ok and Ok again.

That should bring the database up in SQL Server. Once it is up, the tables (in Tables) will all have the schema prefix dbo (database owner) and have names like MON_HSS_% for profilometer data. Other LTPP reference tables will be included (Codes, Section_Coordinates, Data Dictionary (LTPPDD)).

The LTPP program has different levels of data quality (from A through E, where level E data is the highest quality that has passed all the checks). LTPP InfoPave provides access to the same database the LTPP program releases through its Standard Data Release (SDR) which includes data at various levels (A through E). The level of data quality is indicated by the field “Record Status”. The graphics and information displayed on the screens are based on this data.

The data files, images, and videos that are part of the LTPP data collection that supplement the Pavement Performance Data Base (PPDB) are called Ancillary Information Management System (AIMS) data. This data is now available for view and download through LTPP InfoPave. The distress images and roadway videos are provided under Visualization. The distress images are also available in ‘Section Timeline’ under Visualization. The data files (such as M&R, FWD and Profile files) are available for download using Ancillary Data Selection and Download under Data.

Once the sections are selected with ‘Find Sections’ in the ‘Data Selection and Download’ feature, under ‘Structure,’ the tables under the ‘Material’ group will have all the available material information regarding the selected sections. In order to make sure you are looking at the complete list of material tables, check the ‘Show Advanced Data Classification’ option.

The layer structure information in the Section Summary Report represents the latest existing pavement layers, and this information is displayed using the maximum Construction Number (CN) corresponding to each pavement section.

The "Traffic" class of the "Data Selection and Download" feature lists all the traffic tables that have traffic information. In order to make sure you are looking at the complete list of traffic tables, check the "Show Advanced Data Classification" option. You may also choose to narrow down your sections using "Find Sections" before selecting the data to get your desired data set.

The Section Summary Reports feature under Data is the best way to review performance data of an LTPP section. Under the "Graphs" tab of this summary report, you will see graphs of the major pavement performance information as a function of time. If you are interested in downloading the numerical data, you can use the “Go To” feature to go to the "Data Selection and Download" feature under Data and select the respective tables under "Performance." In order to make sure you are looking at the complete list of performance tables, check the "Show Advanced Data Classification" option.

Once the sections are selected with “Find Sections”, open “Performance” and expand the JPCP tables under the Pavement Distress class to see the manual distress and faulting tables. To see other tables, click on "Show Advanced Data Classification.

Use the “Data Selection and Download” feature and expand the “Performance” class. The Backcalculation and Deflection class has the Deflection Data tables.

LTPP only collects pavement surface temperatures during FWD testing. For 24/7/365 pavement temperatures, investigate state agency roadway weather information sites.