GPS Survey Data Fields (Distribution)
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: wams_gps_survey
|
Field Name |
Help Text |
Database Field |
Size |
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 |
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. |
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 |
Double |
|
L |
0 |
|
|
|
|
|
||||||||||||||||||||
|
Antenna height |
Height of antenna. |
antenna_height |
Double |
|
Y |
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 |
30 |
|
0 |
|
|
|
|
|
||||||||||||||||||||
| GPS accuracy |
Degree of accuracy of GPS survey:
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
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 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. |
button to display the 