CC6 Database Search
Refer to the table below for links to the following database searches:
1.Track
Test items are trafficked using a defined wander pattern, with the carriage located at discrete lateral positions, or tracks . The Track table lists 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.
2.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.
3. Gear
Returns the Gear table, which contains information about the configured wheel loads.
4. Test Items
Returns the the TestItem table, which contains engineering data about the CC6 pavement test items (layer materials and thicknesses)
5. Traffic
Click on the Traffic link below to search traffic data for a specific date.
6. MUX (Multiplexer)
The MUX table stores information about the static sensors, including sensor type and location. (MUX refers to the multiplexer units, which acquire the static sensor data.)
7. Static Sensor Data
Static sensors collect temperature, moisture, and other environmental data data on an hourly basis. Click on the Static Sensor Data link below to search static sensor data for a specific date.
8. SPU (Signal Processing Units)
The SPU table stores information about the dynamic sensors, including sensor type and location.
9. Dynamic Sensor 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 Sensor Data link below to search the database for a particular dynamic sensor.
10. Custom Query
Advanced users may query the NAPTF database by Structured Query Language (SQL). Note that data are read-only. Only “select” queries will be recognized by the database. Refer to the table map when formulating queries. Additional details about the fields in each database table may be found by clicking on the appropriate link below.
Database Queries
Select from one of the following links to search the CC6 database: