Leak Detection Survey Data Fields

Leak Detection Survey data can be edited on either the Leak Detection Grid Window of the Survey Grid or the Leak DetectionProperty Sheet.

To view and edit all leak detection data, use the Property Sheet.

The following describes all the data which can be used to define a leak detection survey.

Common Data Fields

Fields that are common to the majority of objects can be found in the Common Fields topic.

Leak Detection Data

Database Table Name: wams_leak_detection

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

ID

The name of the object.

The ID is the primary key in the database for the network object. This means that the ID field of each object must be unique for all objects of the same object type.

id

Text

40

 

0

 

 

 

 

 

Node ID

Node at which leak detection survey was carried out.

node_id

Text

40

 

0

 

 

 

 

 
Pipe ID Pipe at which leak detection survey was carried out. pipe_id Text 40   0          
Leak distance Distance along pipe to leak location (if leak detected). leak_distance Double   L 2          

X coordinate

X coordinate of the object.

The coordinates of the Leak Detection Survey may be defaulted, in which case, the order of precedence of calculating coordinates is as follows:

  • default coordinates from node, pipe and leak distance
  • default coordinates to node coordinates
  • default the coordinates to the centre of the pipe
  • default to null

x

Double

 

XY

2

 

 

 

 

 

Y coordinate

Y coordinate of the object.

The coordinates of the Leak Detection Survey may be defaulted, in which case, the order of precedence of calculating coordinates is as follows:

  • default coordinates from node, pipe and leak distance
  • default coordinates to node coordinates
  • default the coordinates to the centre of the pipe
  • default to null

y

Double

 

XY

2

 

 

 

 

 
Leak detection type

Database Value

Description
Type 1 Type 1
Type 2 Type 2

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

 leak_detection_type Text 40   0          

Location

Address or description of site at which associated asset is located.

location

Text

100

 

0

 

 

 

 

 
Leak detected Check this field to indicate that a leak was detected during the survey. leak_detected Boolean     0          
Leak severity

Database Value

Description
Low Low
Medium Medium
High High

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

 leak_severity Text 40   0          
Date loggers installed Date-time at which logger was installed. date_loggers_installed Date / Time     0          
Date loggers removed Date-time at which logger was removed. date_loggers_removed Date / Time     0          
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.                    

Creating a Meter Test

Survey Grid

Network Data Fields

Common Data Fields