Custom SQL Query

Advanced users can query the CC6 database using Structured Query Language (SQL). Only read-only (Select) queries are allowed. In formulating SQL queries, refer to the Table Map and Table Details.

SQL Query



* Queries are permitted for viewing only.  *

SQL Query Dynamic Data
Enter SQL statement:

Table Map

The database is organized into 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.



Table Descriptions

  • Dynamic_data - Contains dynamic sensor responses, including peak values and full dynamic records.
  • Gear - Contains information about the configured loads, including number of tires per carriage, applied tire loads (nominal), and tire spacing (dual and tandem)
  • 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 data.)
  • Static_data - Contains static sensor responses, including hourly temperature and moisture readings.
  • Test Items - Returns the TestItem table, which contains engineering data about the CC6 pavement test items (layer materials and thicknesses)
  • Track - Identifies the north and south carriage positions corresponding to the 9 wander tracks.
  • Traffic - Contains information about the vehicle passes, including start and end times for each load event, gear configuration, applied loads (actual), and wander position.
  • Wander - Lists the track numbers and carriage positions corresponding to each sequence number in the wander pattern.
Module is not configured. Please create a new reportset or import an existing one from the repository.