Search CC5 Database

Search the CC5 Database

 

Refer to the menu box below for links to the following database searches:

 

Track

Test items are trafficked using a defined wander pattern, with the carriage located at discrete lateral positions, or tracks. The Track table supplies the exact value of the carriage position relative to the center line for each track number. Refer to the diagram under 'Wander Pattern' to better visualize the track locations.

Wander

The Wander table lists the loading sequence making up a complete wander pattern. Each wander sequence number is associated with a track position from the Track table.

FWD

The FWD table stores information about  flexible pavement section, loads and reading for specific locations. A falling weight deflectometer (FWD) is a testing device used used to estimate pavement structural capacity.

Gear

Returns the Gear table, which contains information about the configured wheel loads.

Test Item

Returns the the TestItem table, which contains engineering data about the CC5 pavement test items (layer materials and thicknesses)

Traffic

Click on the Traffic link below to search traffic data for a specific date

Profile

Measurements made by a straightedge or Rail to Rail Profiler to determine rut and upheaval amounts in each test section.

SPU (Signal Processing Units)

The SPU table stores information about the dynamic sensors, including sensor type and location

Static Data

Static sensors collect temperature and moisture data on an hourly basis. Click on the Static Data link below to search static sensor data for a specific date. 

Dynamic Data

Dynamic sensors are triggered by movements of the load vehicle. Therefore, dynamic sensor responses are collected only on days when the load vehicle is in operation. Dynamic sensor records are available for most passes of the load vehicle on the test items. However some gaps in the data are known to exist. Click on the Dynamic Data link below to search the data for a particular dynamic sensor.

Traffic Test Item

The purpose of the table of TrafficTestItem is to set up a relationship for Traffic table and TestItem table. Because each traffic pass is not just for one test item. We cannot set up a direct link between Traffic table and TestItem table.

Custom Query

Advanced users can query the NAPTF database using Structured Query Language (SQL). Note that data are read-only. Only “select” queries will be recognized by the database. Refer to the table map and definitions when formulating queries. 

 



Database Queries

This construction cycle has the following database query pages:

1. Track 7. Profile
2. Wander 8. SPU
3. FWD 9. Static Data
4. Gear 10. Dynamic Data
5. Test Item 11. Traffic Test Item
6. Traffic 12. Custom Query