CC7 North and South Database Search
Refer to the tables 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. Load Type
Returns the Load Type table, which contains information about the configured wheel loads.
4. Test Item
Returns the Test Item table, which contains engineering data about the CC7 pavement test items (layer materials and thicknesses).
5. Traffic
The Traffic Table includes all the information gathered during trafficking about the trafficking.
6. Sensor
The Sensor table stores information about the sensors, including sensor type and location.
7. Static Data
Click on the Static Sensor Data link below to search static sensor data for a specific date.
8. 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 Sensor Data link below to search the database for a particular dynamic sensor.
9. Load
Tire loading applied by the modules by the NAPTV onto the test section in pounds.
10. Profile
Measurements made by a straightedge or Rail to Rail Profiler to determine rut and upheaval amounts in each test section.
11. HWD
A non-destructive testing tool used to measure material properties of pavements.
12. 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 CC7 database:
Table Map
The database is organized into 11 tables as shown in the figure below. Key fields in each table are unique identifiers and are indicated by a key symbol. Lines represent links between tables (Table Descriptions).
To view sample queries select the Sample Queries link.