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
T2-OL332.5027.00-1.25inop
T3-OL492.5027.00-3.735/27/5 ok
T4-OL492.5027.00-1.25inop
T5-OL592.5027.00-3.735/27/5 ok
T6-OL592.5027.00-1.25inop

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:
Submit


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