Wavetronix Command Collector (CMD-DCx) - User Guide - Manual (Page 63)

62 CHAPTER 5 • SENSOR CONFIGURATION PAGE
Data Query Tab
The Data Query tab allows you to query data directly from the database with a variety of
options (see Figure 5.12). Data retrieved from a data query can be presented in graph or
table form, or as an XML or text file that can be saved for future reference. Collector data
queries also allow you to request data from specific lanes.
Figure 5.12 – Data Query Tab
Setting up a Data Query
Follow the steps below to set up a data query:
1 Select start and end times for the data query using the Start/End Time and Start/End
Date controls. The Start/End Time and Date controls allow you to choose any hour
between midnight and 11 p.m. and any date in the future or past.
Note
The real scope for data query start and end dates is somewhat limited because Collec-
tor does not store data indefinitely. Sensor interval data is only stored for one week
and aggregated data is stored for either 90 days, 1 year or 5 years depending on the
edition and configuration of your system.
2 Choose a Group By option. By Lane will output the lane data directly out of the da-
tabase; selecting By Sensor or By Approach will aggregate the lane data together into
sensor or approach bins, add all volumes together and take the average speed, occu-
pancy and class across all lanes in the group.
3 Choose an interval. Selecting Sensor Interval will query the data out of the database in
its natural interval. Alternately, you can request data aggregated together in 5-, 15- or
60-minute intervals.
Collector also supports custom aggregation intervals. To use a custom interval, select
the Custom radio button and enter an interval into the Custom field. For best results,
choose a custom interval that is an even multiple of either the sensor interval or the