User Defined Survey Data Fields
User Defined Survey data can be edited on either the Survey Grid or the object Property Sheet.
To view and edit all user defined survey data, use the Property Sheet.
The following describes all the data which can be used to define a user defined survey.
User Defined Survey Data
Database Table Name for user-defined fields: networktype__objectname where:
- networktype is the type of network and can take the following values:
- ams - Asset network
- cams - Collection network
- wams - Distribution network
- "__" - double underscore
- objectname - name of the asset as entered in the Database Name field of the User Defined Objects Dialog.
User defined objects are configured in the User Defined Object Grid. Please refer to the User Defined Object Grid topic for further details.
User defined objects may be assigned:
- built-in fields. This is carried out behind the scenes by InfoAsset Manager at object creation or editing time. These default fields are related to the object type and geometry. Built-in fields are listed in the table below.
- user defined fields. These user defined fields are specified by the user (this may be permissioned). See User Defined Field Grid for more information.
|
Field Name |
Help Text |
Database Field |
Size |
Precision |
Default |
Error Lower Limit |
Error Upper Limit |
Warning Lower Limit |
Warning Upper Limit |
||
|---|---|---|---|---|---|---|---|---|---|---|---|
|
ID |
Unique identifier for the survey. The identifier depends on the geometry of the survey. |
id for all survey types but points node_id for points ds_node_id and us_node_id for links |
Text |
40 |
|
0 |
|
|
|
|
|
|
Asset type |
Type of asset associated with the survey. (To associate the survey with a Collection Network pipe, use the US node ID, DS node ID and Link suffix fields.) |
asset_type |
Text |
100 |
|
|
|
|
|
|
|
|
Asset ID |
Asset ID of associated asset. (To associate the survey with a Collection Network pipe, use the US node ID, DS node ID and Link suffix fields.) |
asset_id |
Text |
40 |
|
|
|
|
|
|
|
| US node ID |
Applies to Collection Networks. Upstream node ID of surveyed pipe. (Used when survey is associated with a pipe.) |
us_node_id | Text | 40 | 0 | ||||||
| DS node ID |
Applies to Collection Networks. Downstream node ID of surveyed pipe. (Used when survey is associated with a pipe.) |
ds_node_id | Text | 40 | 0 | ||||||
| Link suffix |
Applies to Collection Networks. Link suffix of surveyed pipe. (Used when survey is associated with a pipe.) |
link_suffix | Text | 1 | 0 | ||||||
|
X coordinate |
Applies to surveys that are points. X coordinate of the survey. |
x |
Double |
|
XY |
2 |
|
|
|
|
|
|
Y coordinate |
Applies to surveys that are points. Y coordinate of the survey. |
y |
Double |
|
XY |
2 |
|
|
|
|
|
|
Elevation |
Applies to surveys that are points. Elevation above datum level (usually sea level) . |
elevation |
Double |
|
Z |
2 |
|
||||
|
Length |
Applies to surveys that are polylines. Applies to surveys that are polylines. Link length |
length |
Double |
L |
3 |
||||||
|
Area |
Applies to surveys that are polygons. Polygon area. Default value is calculated from polygon geometry. |
area |
Double |
NA |
3 |
|
|
|
|
|
|
|
Location |
Address or description of site at which asset is located. |
location |
Text |
100 |
|
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 | ||||||||
|
Notes Special instructions Hyperlinks Barcode Mobile identifier Unique identifier |
These fields are common to the majority of InfoAsset Manager objects. See Common Data Fields for further details. |
notes special_instructions hyperlink barcode mobile_uid uid |
Various |
button to display the 