Water Quality Survey Data Fields (Collection)

Water Quality Survey data can be edited on either the Water Quality Survey Grid Window of the Survey Grid or the Water Quality Survey Property Sheet.

To view and edit all Water Quality survey data, use the Property Sheet.

The following describes all the data which can be used to define a water quality survey.

Common Data Fields

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

Water Quality Survey Data

Database Table Name: cams_water_quality_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

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

 

 

 

 

 

Asset type

Type of asset associated with the survey:

Database Value

Description
cams_ancillary User ancillary
cams_channel Channel
cams_connection_node Connection node
cams_connection_pipe Connection pipe
cams_data_logger Data logger
cams_defence_area Defence Area
cams_defence_structure Defence Structure
cams_flume Flume
cams_general_asset General asset
cams_generator Generator
cams_manhole Node
cams_orifice Orifice
cams_outlet Outlet
cams_property Property
cams_pump Pump
cams_pump_station Pump station
cams_screen Screen
cams_siphon Siphon
cams_sluice Sluice
cams_storage Storage area
cams_valve Valve
cams_vortex Vortex
cams_weir Weir
cams_wtw Treatment works
cams_zone Zone

The dropdown list will also contain every user defined asset that has been specified for the network.

asset_type

Text

100

 

0

 

 

 

 

 

Asset ID

Asset ID of associated asset.

asset_id

Text

40

 

0

 

 

 

 

 

Survey date

Date that survey was carried out.

survey_date

Date / Time

 

 

0

 

 

 

 

 
Survey type

Reason for carrying out the survey:

Database Value

Description
Scheduled Scheduled
Ad hoc Ad hoc
Customer complaint Customer complaint

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

 survey_type Text 40   0          

Location

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

location

Text

100

 

0

 

 

 

 

 
Source Point at which sample was taken. source Text 40   0          
Sample reference Water quality sample identifier. sample_reference Text 40   0          

X coordinate

X coordinate of the object.

x

Double

 

XY

2

 

 

 

 

 

Y coordinate

Y coordinate of the object.

y

Double

 

XY

2

 

 

 

 

 
Comments Field for additional comments. comments Text 255   0          
Temperature Temperature of water at time of sampling. temperature Double   CF 0          
pH pH of water at time of sampling. ph Double     2          
Appearance

Appearance of water at time of sampling:

Database Value

Description
Appearance 1 Appearance 1
Appearance 2 Appearance 2

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

 appearance Text 40   0          
Odour

Water odour at time of sampling:

Database Value

Description
None None
Chlorine Chlorine
Other Other

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

 odor Text 40   0          
Colour description

Colour of water at time of sampling:

Database Value

Description
Clear Clear
Pale Pale
Yellow Yellow
Brown Brown

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

 colour_description Text 40   0          
Colour Measurement of colour. colour Double   COLOUR 2          
Turbidity Measurement of turbidity. turbidity Double   TURBIDITY 2          
Recommended action

Recommended action:

Database Value

Description
None None
Flushing Flushing
Dosing Dosing

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

 recommended_action Text 40   0          
Hydrogen sulphide Concentration of Hydrogen Sulphide. hydrogen_sulphide Double   IN_C 2          
Biological oxygen demand Concentration of BOD. biological_oxygen_demand Double   IN_C 2          
Chemical oxygen demand Concentration of COD. chemical_oxygen_demand Double   IN_C 2          
Dissolved oxygen Concentration of dissolved oxygen. dissolved_oxygen Double   IN_C 2          
Total kjeldahl nitrogen Concentration of Total Kjeldahl Nitrogen. total_kjeldhal_nitrogen Double   IN_C 2          
Ammoniacal nitrogen Concentration of NH4. ammoniacal nitrogen Double   IN_C 2          
Salinity Concentration of salts. salinity Double   IN_C 2          
Nitrate Concentration of nitrate. nitrate Double   IN_C 2          
Nitrite Concentration of nitrite. nitrite Double   IN_C 2          
Sulphides Concentration of sulphides. sulphides Double   IN_C 2          
Suspended solids Concentration of suspended solids. suspended_solids Double   IN_C 2          
Algae Concentration of algae. algae Double   IN_C 2          
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 water quality survey.

 tsdb_links                  

Survey Grid

Network Data Fields

Common Data Fields