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: