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:

 

1. Track 

7. Static Data

2. Wander

8. Dynamic Data 

3. Load Type

9. Load

4. Test Item

10. Profile 

5. Traffic

11. HWD 

6. Sensor

12. Custom Query


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.

CC7 Sensor Response

View NAPTF Sensor Data: LSG-1

Select Sensor and Pass Number
Please note that the pass numbers indicated below are the number of cumulative applications of load to a particular test section. Pass numbers may differ from test section to test section depending on how trafficking progressed.

Select test section: and desired sensor:
Enter desired pass number
(Select Test Section to See Available Range)
: