Pump Station Survey Data Fields (Collection)

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

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.

Text

Pump station ID

ID of pump station at which survey was carried out.

pump_station_id

Text

Survey date

Date/time at which survey was carried out.

survey_date

Date / Time

Location

Description of location at which survey was carried out.

location

Text

100

X coordinate

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

Double

Y coordinate

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

Double

Catchment

Catchment which associated pump station serves.

catchment

Text

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

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

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

Overflow location

Description of location of overflow.

overflow_location

Text

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

Screen bar spacing

Distance between screen bars.

screen_bar_spacing

Double

CAMS_PS

Screen condition

Description of screen condition.

screen_condition

Long Integer

Screen manufacturer

Name of screen manufacturer.

screen_manufacturer

Text

Screen model

Model number of screen.

screen_model

Text

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

Test volume

Volume of water pumped during survey.

test_volume

Double

Drop tests

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