Search Database

Search CC2 Test Item Database


Query TP-OL Sensors



Sensor NameX-Loc(ft)Y-Loc(ft)Z-loc(inches)Status
T1-TP210.000.004.005/27/5 ok
T2-TP240.000.002.005/27/5 ok
T3-TP240.000.004.005/27/5 ok
T4-TP275.000.00-1.005/27/5 ok
T5-TP275.000.002.005/27/5 ok
T6-19275.000.004.005/27/5 ok
T1-OL332.5027.00-3.735/27/5 ok
T3-OL492.5027.00-3.735/27/5 ok
T5-OL592.5027.00-3.735/27/5 ok

Date (YYYY/MM) :

Run CC2 Test Items TP-OL Sensors Query

Query Traffic Data


Date (YYYY/MM/DD) :

Run CC2 Test Items Traffic Data Query


Custom SQL Query

SQL Query Dynamic Data
Enter SQL statement:

Table Map

The database is organized into 16 tables for both dynamic data and static data as shown in the figure. 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.

CC2 Test Items Database Diagram