Phase 2

CC8 Phase 2 Overlay Database Search

 

Refer to the table below for links to the following database searches for the CC8 Phase 2 Overlay Test:

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” to better visualize the track locations.

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.

Gear

The Gear table includes gear type and location during traffic testing.

Test Item

The Test Item table includes engineering data about the CC8 Phase 2 Overlay pavement test items (layer materials and thicknesses).

Traffic

The Traffic table includes all the information gathered during trafficking about the trafficking.

Sensor

The Sensor table includes information about the sensors, including sensor type and location.

Static Data

The Static Data table includes the static sensor data for a specific date.

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.

HWD

The HWD table includes the HWD deflection data collected throughout the course of trafficking.

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 CC8 Phase 2 Overlay Database:

Track

Static Data

Wander

Dynamic Data

Gear

HWD

Test Item

Custom-Query

Traffic

 

Sensor

 

 

Table Map

The database is organized into 8 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. To view sample queries select the Sample Queries link.

 

 

Return to Construction Cycle 8 Overview