Complete Sensor Data and Vehicle Log Files

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:

1. Track 6. Mux
2. Wander 7. Static Sensor Data
3. Gear 8. SPU
4. Test Items 9. Dynamic Sensor Data
5. Traffic Summary 10. Custom Query