Search the CC5 Database
Refer to the menu box below for links to the following database searches:
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.
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.
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.
Returns the Gear table, which contains information about the configured wheel loads.
Returns the the TestItem table, which contains engineering data about the CC5 pavement test items (layer materials and thicknesses)
Click on the Traffic link below to search traffic data for a specific date
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 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 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.
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.
This construction cycle has the following database query pages: