Live data fields
Live data fields are displayed on the Live Data Point view.
Live data points coming from telemetry feeds reside in their original database and are accessed / loaded when required by InfoWorks WS Pro.
Live data points coming from flat files are not stored in the database. They remain in their original files for two reasons:
-
possible large size of data files
-
to avoid data duplication as this data may well be used in the organisation for other purposes
This data is displayed on theLive Data Point property sheet - Live Data Point page.
Fields in the database
The database fields describe where the live data file is and what should be in it.
Database Table Name: wn_live_data_point
|
Field name |
Help text |
Flag |
Grid |
Prop pg |
Size |
Precision |
Database field |
Default |
Error lower limit |
Error upper limit |
Warning lower limit |
Warning upper limit |
||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Live Data Point ID |
Name of the Live Data Point (name of the file / feed). |
YES |
YES |
1 |
100 |
0 |
|
live_data_point_id |
Text |
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
|
Data Source |
Source of the data (file format for files, or LDF for live data feeds). One of:
|
NO |
YES |
1 |
10 |
0 |
|
data_source |
Text |
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
|
Source File |
The name of the file containing the Live Data. The Source File field can contain an absolute or relative path to the file.
Note: This field is empty for linked live data feeds. |
NO |
YES |
1 |
|
0 |
|
source_file |
Memo |
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
|
Telemetry Point |
Location / description of monitored site (for live data point) or name of the feed as specified in the Feed Name field of the Live Data Feed View (for live data feed). |
NO |
YES |
1 |
100 |
0 |
|
telemetry_point |
Text |
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
|
Effective Channel Type |
Dropdown list of types of live data that may be derived from the live data file values. The live data will be treated as the type selected in this field for graphing and calculation purposes. For live data feeds, the Effective Channel Type is inferred from the External Units field of the Live Data Feed View. If the external units are not set to a flow, pressure, or concentration unit, the channel type will be set to NUMBER. Unit conversion is applied using the units set on the Live Data Feed View. |
NO |
YES |
1 |
20 |
0 |
|
channel_type |
Text |
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
|
Area |
For information |
YES |
YES |
1 |
30 |
0 |
|
area |
Text |
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
|
Sensor Level |
The level above datum of the sensor. Used for calculating absolute pressure (head). |
NO |
YES |
1 |
|
2 |
Z |
sensor_level |
|
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
|
Pressure Factor |
A multiplication factor for adjusting all pressure data in the file. Applies only to live data points coming from files Tip: Factor and offset of live data points relating to feeds are specified in the Offset and Factor fields of the Live Data Feed View. |
NO |
YES |
1 |
|
2 |
|
pressure_factor |
|
1.0 |
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
|
Pressure Offset |
An offset value to be added to all pressure data in the file. Applies only to live data points coming from files Tip: Factor and offset of live data points relating to feeds are specified in the Offset and Factor fields of the Live Data Feed View. |
NO |
YES |
1 |
|
2 |
|
pressure_offset |
|
0.0 |
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
|
Flow Factor |
A multiplication factor for adjusting all flow data in the file. Applies only to live data points coming from files Tip: Factor and offset of live data points relating to feeds are specified in the Offset and Factor fields of the Live Data Feed View. |
YES |
YES |
1 |
|
2 |
|
flow_factor |
|
1.0 |
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
|
Flow Offset |
An offset value to be added to all flow data in the file. Applies only to live data points coming from files Tip: Factor and offset of live data points relating to feeds are specified in the Offset and Factor fields of the Live Data Feed View. |
NO |
YES |
1 |
|
2 |
|
flow_offset |
|
0.0 |
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
|
Concentration Factor |
A multiplication factor for adjusting all concentration data in the file. Applies only to live data points coming from files Tip: Factor and offset of live data points relating to feeds are specified in the Offset and Factor fields of the Live Data Feed View. |
NO |
YES |
1 |
|
2 |
|
concentration_factor |
|
1.0 |
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
|
Concentration Offset |
An offset value to be added to all concentration data in the file. Applies only to live data points coming from files Tip: Factor and offset of live data points relating to feeds are specified in the Offset and Factor fields of the Live Data Feed View. |
NO |
YES |
1 |
|
2 |
|
concentration_offset |
|
0.0 |
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
|
Time Offset |
An offset value to be added to all the times in the file |
NO |
YES |
1 |
|
0 |
|
time_offset |
Double |
0.0 |
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
|
Original Channel Type |
The type of data in the live data file. Channel type is read from the header of the live data file and can be:
|
NO |
YES |
1 |
20 |
|
|
original_channel_type |
Text |
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
|
Depth Volume |
Enabled when Original Channel Type is PRESSURE or PC_VOLUME. Depth/Volume curve to be used when deriving flow from reservoir depth or percentage full (by volume) data. (If a network is open, a reservoir in the network can be selected from the Copy from Reservoir: dropdown list. The depth/volume curve of the selected reservoir will be copied into the grid.) Database Table Name: wn_reservoir_depth_volume
|
NO |
YES |
2 |
|
|
|
depth_volume |
Array |
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
|
Pump Flow Rate |
Enabled when Original Channel Type is PUMP. Flow rate to be used when deriving flow from pump runtime data. |
NO |
YES |
2 |
|
2 |
WN_Q |
pump_flow_rate |
|
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
|
100% Full Depth |
Used when deriving pressure from percentage full data. The depth (from reservoir bottom level) at which the reservoir is 100% full. If the top depth is not specified, the last value in the Depth/Volume table will be assumed. If a reservoir Depth/Volume curve is copied from the network, the 100% full depth will automatically be set to the last Depth value in the curve. |
NO |
YES |
2 |
|
2 |
Y |
top_depth |
Double |
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
|
0% Full Depth |
Used when deriving pressure from percentage full data. The depth at which the reservoir is considered to be empty. If a 0% full depth is not specified, a value of 0.0 will be assumed. |
NO |
YES |
2 |
|
2 |
Y |
minimum_depth |
Double |
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
|
Notes |
You can keep freeform notes about any object in your network. The notes field can be up to 64,000 characters in size, or about 10 pages of printed text. |
NO |
YES |
4 |
|
0 |
|
notes |
Memo |
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
|
Referenced |
Unused field |
NO |
YES |
NO |
|
0 |
|
referenced |
Boolean |
|
|
|
|
|
Fields from the live data file
The logged data is still stored in the live data file. The fields in the grid are always read-only.
Database Table Name: wn_live_data_point_info
|
Field name |
Help text |
Flag |
Grid |
Property page |
Size |
Precision |
Required |
Database field |
Default |
Error lower limit |
Error upper limit |
Warning lower limit |
Warning upper limit |
||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Status |
Read only field displaying the status of the file data. |
YES |
YES |
3 |
10 |
0 |
NO |
|
status |
Text |
|
|
|
|
|
|
Start Date and Time |
Start of the data in the file |
NO |
YES |
3 |
|
0 |
NO |
|
start_date_time |
|
|
|
|
|
|
|
Finish Date and Time |
End of the data in the file |
NO |
YES |
3 |
|
0 |
NO |
|
finish_date_time |
|
|
|
|
|
|
|
Logging Interval |
Time interval between data points Applies only to live data points coming from files |
NO |
YES |
3 |
|
2 |
NO |
|
logging_interval |
Double |
|
|
|
|
|
|
Number Of Readings |
Number of data points Applies only to live data points coming from files |
NO |
YES |
3 |
|
0 |
NO |
|
number_of_readings |
|
|
|
|
|
|
|
Flow Data Present |
Flag to say if the file contains Flow Data |
NO |
YES |
3 |
|
0 |
NO |
|
flow_data |
Boolean |
|
|
|
|
|
|
Flow Units |
Units used for flow data in the file |
NO |
YES |
3 |
30 |
0 |
NO |
|
flow_units |
Text |
|
|
|
|
|
|
Pressure Data Present |
Flag to say if the file contains Pressure Data |
NO |
YES |
3 |
|
0 |
NO |
|
pressure_data |
Boolean |
|
|
|
|
|
|
Pressure Units |
Units used for pressure data in the file |
NO |
YES |
3 |
30 |
0 |
NO |
|
pressure_units |
Text |
|
|
|
|
|
|
Node |
Stored in some file types. For information only Applies only to live data points coming from files |
NO |
YES |
3 |
80 |
0 |
NO |
|
node |
Text |
|
|
|
|
|
|
Pipe Diameter |
Stored in some file types. For information only Applies only to live data points coming from files |
NO |
YES |
3 |
|
2 |
NO |
|
pipe_diameter |
|
|
|
|
|
|
|
Site |
Stored in some file types. For information only Applies only to live data points coming from files |
NO |
YES |
3 |
80 |
0 |
NO |
|
site |
Text |
|
|
|
|
|
|
Zone |
Stored in some file types. For information only Applies only to live data points coming from files |
NO |
YES |
3 |
80 |
0 |
NO |
|
zone |
Text |
|
|
|
|
|
|
Version |
Stored in some file types. For information only Applies only to live data points coming from files |
NO |
YES |
3 |
80 |
0 |
NO |
|
version |
Text |
|
|
|
|
|
