CC7 North and South Database Search
Refer to the tables 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 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.
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).
The Traffic Table includes all the information gathered during trafficking about the trafficking.
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.
Tire loading applied by the modules by the NAPTV onto the test section in pounds.
Measurements made by a straightedge or Rail to Rail Profiler to determine rut and upheaval amounts in each test section.
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.
Select from one of the following links to search the CC7 database:
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.