Pump Station Survey Data Fields (Distribution)

Pump Station Survey data can be edited on either the Pump Station Survey Grid Window of the Survey Grid or the Pump Station Survey Property Sheet.

To view and edit all pump station survey data, use the Property Sheet.

The following describes all the data which can be used to define a pump station survey.

Common Data Fields

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

Pump Station Survey Data

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

 

 

 

 

Pump station ID ID of pump station at which survey was carried out. pump_station_id Text 40   0  

 

 

 

 

Survey date Date/time at which survey was carried out. survey_date Date / Time     0  

 

 

 

 

Location

Description of location at which survey was carried out.

location Text 100   0  

 

 

 

 

X coordinate

X coordinate of location surveyed. Default value is X coordinate of associated pump station.

x Double   XY 2  

 

 

 

 

Y coordinate Y coordinate of location surveyed. Default value is Y coordinate of associated pump station. y Double   XY 2  

 

 

 

 

Catchment Catchment which associated pump station serves. catchment Text 20   0  

 

 

 

 

Weather

Weather conditions at time of survey:

Database Value

Description

Dry Dry
Showers Showers
Rain Rain
Heavy rain Heavy rain
Snow Snow

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

weather Text 12   0  

 

 

 

 

Overflow provided

Database Value

Description

Yes Yes
No No
N/A N/A

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

overflow_provided Text 12   0  

 

 

 

 

Overflow 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.

overflow_type Text 12   0  

 

 

 

 

Overflow location

Description of location of overflow.

overflow_location Text 20   0  

 

 

 

 

Screen 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.

screen_type Text 12   0          
Screen bar spacing Distance between screen bars. screen_bar_spacing Double   CAMS_PS 0  

 

 

 

 

Screen condition Description of screen condition. screen_condition Long Integer     0  

 

 

 

 

Screen manufacturer Name of screen manufacturer. screen_manufacturer Text 20   0  

 

 

 

 

Screen model Model number of screen. screen_model Text 20   0  

 

 

 

 

Evidence of overflow

Database Value

Description

Yes Yes
No No
N/A N/A

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

evidence_of_overflow Text 12   0  

 

 

 

 

Test volume Volume of water pumped during survey. test_volume Double     0          
Drop tests

Database Table Name: wams_pump_station_drop_tests

Show Columns

Database Names

Size, Type and Units

Defaults and Error Limits

Position in Data Structure

Field Name

Help Text

Database Field

Data Type

Size

Units

Default

Error Lower Limit

Error Upper Limit

Warning Lower Limit

Warning Upper Limit

1 Pump 1 Identifier for pump 1 pump1 Text 40          

 

2 Pump 2 Identifier for pump 2 pump2 Text 40          

 

3 Pump 3 Identifier for pump 3 pump3 Text 40          

 

4 Pump 4 Identifier for pump 4 pump4 Text 40          

 

5 Start level Well level at the start of the test. start_level Double   Z        

 

6 Stop level Well level at which pump is stopped. stop_level Double   Z        

 

7 Draw time Time taken to reach Stop level from Start Level. draw_time Double   TS        

 

8 Draw rate Pump out rate. draw_rate Double   Q        

 

9 Fill time Time taken to reach Start level from Stop level. fill_time Double   TS        

 

10 Fill rate Inflow rate. fill_rate Double   Q        

 

11 Net output Draw rate - Fill rate. net_output Double   Q        

 

12 Test volume Volume of water pumped during test. test_volume Double   VO        

 

drop_tests Array        

 

 

 

 

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.            

 

 

 

 

Pump Station Surveys

Survey Grid

Network Data Fields

Common Data Fields