CC1 Database Search

 
Refer to the table below for links to the following database searches for Construction Cycle 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” 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.

Traffic

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

MUX

Contains information about the static sensors, including sensor type and location. (MUX refers to the multiplexer units, which acquire the static sensor data.)

SPUs

Contains information about the dynamic sensors, including sensor type and location. (SPU refers to the 6 signal processing units, which acquire the dynamic sensor.

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.

FWD

Contains falling-weight deflectometer (FWD) test data. FWD tests are conducted periodically on NAPTF test items to monitor changes in the pavement structural properties.

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 1 Overload Database:

Table Map

The database is organized into 13 tables as shown in the table map below.  Key fields in each table are indicated by a key symbol.  Lines represent links between tables.  In order to more clearly show the relationships between the tables, not all fields have been shown in this map. For a complete listing of the fields in each table, including SQL Server data types, see Table Details.

Return to Construction Cycle 1 Overview