CC1 Database Search
Refer to the table below for links to the following database searches for Construction Cycle 1:
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.
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.
The Traffic table includes all the information gathered during trafficking about the trafficking.
Contains information about the static sensors, including sensor type and location. (MUX refers to the multiplexer units, which acquire the static sensor data.)
Contains information about the dynamic sensors, including sensor type and location. (SPU refers to the 6 signal processing units, which acquire the dynamic sensor.
The Static Data table includes the static sensor data for a specific date.
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.
Contains falling-weight deflectometer (FWD) test data. FWD tests are conducted periodically on NAPTF test items to monitor changes in the pavement structural properties.
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 CC8 Phase 1 Overload Database:
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