GPS Survey Data Fields (Collection)

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

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

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

Common Data Fields

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

GPS Survey Data

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

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 ID

An optional reference - usually the asset database name for this network object (if applicable).

asset_id

Text

40

 

0

 

 

 

 

 

Asset type

Database Value

Description

M

Manhole

J

Junction (Saddle)

L

Lamphole

H

Hatchbox

R

Rodding Eye

F

Outfall

V

Storm Overflow

P

Pumping Station

S

Soakaway

D

Dual Function

W

Treatment Works

G

Ghost (Bend)

Z

Ghost (Rising Main)

C

Cascade

Y

Gulley

E

Ejector

O

Oil Interceptor

I

Inlet

B

Hydrobrake

T

Vent Column

U

Unspecified

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

asset_type

Text

20

 

0

 

 

 

 

 

Location

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

location

Text

100

 

0

 

 

 

 

 

Weather

Description of weather conditions at time of survey.

weather

Text

20

 

0

 

 

 

 

 

Surveyor

Name of person or contractor that carried out the survey.

surveyor

Text

20

 

0

 

 

 

 

 

X coord

X coordinate of the object.

x

Double

 

XY

2

 

 

 

 

 

Y coord

Y coordinate of the object.

y

Double

 

XY

2

 

 

 

 

 

Elevation

Elevation above datum level (usually sea level).

elevation

Double

 

Z

2

 

 

 

 

 

Used in network

Check box indicating whether the survey has been used to update the network.

used_in_network

Boolean

 

 

0

 

 

 

 

 

Survey date

Date that survey was carried out.

survey_date

Date / Time

 

 

0

 

 

 

 

 

Start time

Date / Time at which survey started.

start_datetime

Date / Time

 

 

0

 

 

 

 

 

End time

Date / Time at which survey finished.

end_datetime

Date / Time

 

 

0

 

 

 

 

 

Receiver model

Receiver manufacturer's model number.

receiver_model

Text

20

 

0

 

 

 

 

 

Receiver serial number

Receiver serial number.

receiver_serial_no

Text

20

 

0

 

 

 

 

 

Data logger type

Details of type of logger used to record survey data.

data_logger_type

Text

20

 

0

 

 

 

 

 

Power supply

Power supply details.

power_supply

Text

20

 

0

 

 

 

 

 

Antenna model

Antenna manufacturer's model number.

antenna_model

Text

20

 

0

 

 

 

 

 

Antenna serial no

Antenna serial number.

antenna_serial_no

Text

20

 

0

 

 

 

 

 

Antenna mounting

Antenna mounting details.

antenna_mounting

Text

20

 

0

 

 

 

 

 

Antenna cable length

Length of antenna cable.

antenna_cable_length

Text

20

 

0

 

 

 

 

 

Antenna height

Height of antenna.

antenna_height

Text

20

 

0

 

 

 

 

 

Station name

Name of GPS network station used for survey.

station_name

Text

20

 

0

 

 

 

 

 

Station no

Identifier of GPS network station / antenna site used for survey.

station_no

Text

20

 

0

 

 

 

 

 

Accessibility

Description of accessibility to surveyed site.

accessibility

Text

20

 

0

 

 

 

 

 

GPS accuracy

Degree of accuracy of GPS survey:

Database Value

Description

N Nearest meter
M Sub-meter
L Survey Level

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

gps_accuracy Text 50   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.                    

Survey Grid

Updating the Network from GPS Survey Data

Network Data Fields

Common Data Fields