Monitoring Survey Data Fields (Distribution)
Monitoring Survey data can be edited on either the Monitoring Survey Grid Window of the Survey Grid or the Monitoring Survey Property Sheet.
To view and edit all monitoring survey data, use the Property Sheet.
The following describes all the data which can be used to define a Monitoring Survey.
Common Data Fields Fields that are common to the majority of objects can be found in the Common Fields topic.
Monitoring Survey Data
Database Table Name: wams_mon_survey
|
Field Name |
Help Text |
Database Field |
Size |
Precision |
Default |
Error Lower Limit |
Error Upper Limit |
Warning Lower Limit |
Warning Upper Limit |
||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Survey ID |
Unique identifier for the monitoring survey. |
id |
Text |
40 |
|
0 |
|
|
|
|
|
||||||||||||||
|
Data logger ID |
Identifier for Data Logger used during the survey. |
data_logger |
Text |
40 |
|
0 |
|
|
|
|
|
||||||||||||||
|
Monitored node |
Node at which the monitoring survey was carried out. |
node_id |
Text |
40 |
|
0 |
|
|
|
|
|
||||||||||||||
|
Channel type |
Description of the parameter being monitored by Data Logger during survey:
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
channel_type |
Text |
32 |
|
0 |
|
|
|
|
|
||||||||||||||
|
Surveyor |
Name of person or contractor that carried out survey work. |
surveyor |
Text |
20 |
|
0 |
|
|
|
|
|
||||||||||||||
|
Location |
Description of the location where the monitoring survey was carried out. |
location |
Text |
100 |
|
0 |
|
|
|
|
|
||||||||||||||
|
X coord |
X coordinate of the location surveyed. Default value is X coordinate of Associated node. |
x |
Double |
|
XY |
2 |
|
|
|
|
|
||||||||||||||
|
Y coord |
Y coordinate of the location surveyed. Default value is Y coordinate of Associated node |
y |
Double |
|
XY |
2 |
|
|
|
|
|
||||||||||||||
|
SensorType |
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
sensor_type |
Text |
32 |
|
0 |
|
|
|
|
|
||||||||||||||
|
Sensor detail |
Sensor model:
|
sensor_detail |
Text |
32 |
|
0 |
|
|
|
|
|
||||||||||||||
|
Calibration factor |
Conversion factor to convert sensor output to engineering units. |
calibration_factor |
Double |
|
|
2 |
|
|
|
|
|
||||||||||||||
|
Sensor serial no |
Sensor identifier. |
sensor_serial_no |
Text |
32 |
|
0 |
|
|
|
|
|
||||||||||||||
|
Sensor reference |
Description of the reference point from which the depth of the sensor is measured.
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
sensor_reference |
Text |
32 |
|
0 |
|
|
|
|
|
||||||||||||||
|
Reference level |
Height above datum (obtained from survey data) of the sensor reference. |
reference_level |
Double |
|
Z |
2 |
|
|
|
|
|
||||||||||||||
|
Sensor depth below reference |
Depth below datum (sensor Reference level) of the Data Logger sensor. |
sensor_depth |
Double |
|
Y |
2 |
|
|
|
|
|
||||||||||||||
|
Sensor level |
Height above (ordinary) datum of Data Logger sensor. |
sensor_level |
Double |
|
Z |
2 |
|
|
|
|
|
||||||||||||||
|
Rated maximum |
Maximum value that the Sensor is designed to monitor. |
maximum |
Double |
|
|
2 |
|
|
|
|
|
||||||||||||||
|
Monitoring frequency |
Logging frequency of Data Logger for the duration of the survey. |
monitoring_frequency |
Double |
|
TS |
2 |
|
|
|
|
|
||||||||||||||
|
Start time |
Time at which Data Logger was programmed to start recording. |
start_datetime |
Date / Time |
|
|
0 |
|
|
|
|
|
||||||||||||||
|
End time |
Time at which Data Logger was programmed to stop recording. |
end_datetime |
Date / Time |
|
|
0 |
|
|
|
|
|
||||||||||||||
|
Installation reading |
Data Logger reading immediately after connection to the network. |
installation_reading |
Double |
|
|
2 |
|
|
|
|
|
||||||||||||||
|
Removal reading |
Data Logger reading immediately prior to disconnection from the network |
removal_reading |
Double |
|
|
2 |
|
|
|
|
|
||||||||||||||
|
Start offset |
Data Logger reading immediately prior to connection to the network. |
start_offset |
Double |
|
|
2 |
|
|
|
|
|
||||||||||||||
|
End offset |
Data Logger reading immediately after disconnection from the network. |
end_offset |
Double |
|
|
2 |
|
|
|
|
|
||||||||||||||
|
TVD |
Time Varying Data associated with the monitoring survey. See the TVD Editor for further information. |
|
|
|
|
|
|
|
|
||||||||||||||||
| Scheduled Task fields | See Common Data Fields - Scheduled Task fields for details of all fields in the Schedule Info, Progress Info and Resources sections of the property sheet. | ||||||||||||||||||||||||
| Attachments |
Click the See Attachments Editor and Common Data Fields for further details. |
attachments | Array | ||||||||||||||||||||||
| General properties fields | See Common Data Fields for details of field in the General properties section of the property sheet. | ||||||||||||||||||||||||
| User defined properties fields | See Common Data Fields - User Fields for details of fields in the User defined properties section of the property sheet. | ||||||||||||||||||||||||
| Time series links |
Click the |
tsdb_links |
button to display the 