Monitoring Survey Data Fields (Collection)

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

Show Columns

Database Names

Size, Type and Units

Defaults and Error Limits

Field Name

Help Text

Database Field

Data Type

Size

Units

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

 

 

 

 

 

Channel type

Description of the parameter being monitored by Data Logger during survey.

Database Value

Description

FLOW

Flow

PRESS

Pressure

CONC

Concentration

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 at which monitoring survey was carried out.

location

Text

100

 

0

 

 

 

 

 

X coord

X coordinate of location surveyed. Default value is X coordinate of Associated node.

x

Double

 

XY

2

 

 

 

 

 

Y coord

Y coordinate of location surveyed. Default value is Y coordinate of Associated node.

y

Double

 

XY

2

 

 

 

 

 

Monitored node

Node at which the monitoring survey was carried out.

node_id

Text

40

 

0

 

 

 

 

 

US node ID

Upstream node of the pipe at which the monitoring survey was carried out.

us_node_id

Text

40

 

0

 

 

 

 

 

DS node ID

Downstream node of pipe at which monitoring survey was carried out.

ds_node_id

Text

40

 

0

 

 

 

 

 

Link suffix

Link suffix of pipe at which the monitoring survey was carried out.

link_suffix

Text

1

 

0

 

 

 

 

 
PLR / asset ID Pipe reference code. plr Text 40   0          

SensorType

Database Value

Description

TRANS

Transducer

PULSE

Pulse Unit

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:

Database Value

Description

PU100

PU100

PU10

PU10

BPG20

BPG20

PG100

PG100

PSM

PSM

MSM

MSM

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

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:

Database Value

Description

C

Cover Level

F

PST Floor

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 duration of 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 button to display the Attachments Editor, used to attach and manage photos, sketches and other files associated with the network object.

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 button to display the Time Series Data Source Grid, which is used to specify or update the time series data streams that are linked to this monitoring survey.

 tsdb_links                  

Creating a Monitoring Survey

Survey Grid

Network Data Fields

Common Data Fields