User Defined Asset Data Fields
User Defined Asset data can be edited on either the Asset Grid or the object Property Sheet.
To view and edit all user defined asset data, use the Property Sheet.
The following describes all the data which can be used to define a user defined asset.
User Defined Asset 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 asset. The identifier depends on the geometry of the asset. |
id for all asset types but points node_id for points ds_node_id and us_node_id for links |
Text |
40 |
|
0 |
|
|
|
|
|
|
X coordinate |
Applies to assets that are points. X coordinate of the asset. |
x |
Double |
|
XY |
2 |
|
|
|
|
|
|
Y coordinate |
Applies to assets that are points. Y coordinate of the asset. |
y |
Double |
|
XY |
2 |
|
|
|
|
|
|
Elevation |
Applies to assets that are points. Elevation above datum level (usually sea level) . |
elevation |
Double |
|
Z |
2 |
|
||||
|
Length |
Applies to assets that are polylines. Applies to assets that are polylines. Link length. |
length |
Double |
L |
3 |
||||||
|
Area |
Applies to assets that are polygons. Polygon area. Default value is calculated from polygon geometry. |
area |
Double |
NA |
3 |
|
|
|
|
|
|
|
Lateral pipe ID |
Applies to Distribution and Asset networks, for assets that are nodes. The ID of the pipe to which the lateral is attached. |
lat_pipe_id |
Text |
40 |
0 |
|
0 |
0 |
0 |
0 |
|
| Lateral distance from start node |
Applies to Distribution and Asset networks, for assets that are nodes. The distance along a pipe from the start node of the pipe to the location of the lateral (hydrant, fitting etc.) . |
lat_distance |
Double |
L |
2 |
0 |
0 |
0 |
0 |
||
| Lateral distance from US node |
Applies to Collection networks only, for node assets. The distance along a pipe from the start node of the pipe to the location of the lateral (hydrant, fitting etc.) . |
lat_distance |
Double |
L |
2 |
0 |
0 |
0 |
0 |
||
| Lateral US node ID |
Applies to Collection networks only, for node assets. Reference ID of upstream node of pipe to which node is laterally connected. |
lat_us_node_id |
Text |
40 |
0 |
0 |
0 |
0 |
0 |
||
| Lateral DS node ID |
Applies to Collection networks only, for node assets. Reference ID of downstream node of pipe to which node is laterally connected. |
lat_ds_node_id |
Text |
40 |
0 |
0 |
0 |
0 |
0 |
||
| Lateral link suffix |
Applies to Collection networks only, for node assets. Link suffix of pipe to which node is laterally connected. |
lat_link_suffix |
Text |
1 |
0 |
0 |
0 |
0 |
0 |
||
|
Lateral Channel ID |
Applies to Collection networks only, for node assets. ID of channel to which node is laterally connected. |
lat_channel_id |
Text |
40 | 0 | 0 | 0 | 0 | 0 | ||
|
Lateral circumferential location |
Applies to Collection networks only, for node assets. Clock reference of position of node on pipe to which node is laterally connected. |
lat_circ_location |
Integer |
0 |
0 |
0 |
0 |
0 |
|||
|
Lateral nodes |
Applies to assets that are links. Click the |
lat_nodes |
Array |
0 |
|||||||
| Attachments |
Click the See Attachments Editor and Common Data Fields for further details. |
attachments | Array | ||||||||
|
Special instructions Notes Hyperlinks Barcode Mobile identifier Unique identifier |
These fields are common to the majority of InfoAsset Manager objects. See Common Data Fields for further details. |
special_instructions notes hyperlink barcode mobile_uid uid |
Various | ||||||||
| Time series links |
Click the |
tsdb_links |
button to display the Lateral Nodes editor, used to view lateral nodes on the pipe.