Connection Node Data Fields
Connection Node data can be edited on either the Connection Node Grid Window of the Asset Grid or the Connection Node Property Sheet.
To view and edit all connection node data, use the Property Sheet.
The following describes all the data which can be used to define a Connection Node.
Common Data Fields Fields that are common to the majority of objects can be found in the Common Fields topic.
Connection Node Data
Database Table Name: cams_connection_node
|
Field Name |
Help Text |
Database Field |
Size |
Precision |
Default |
Error Lower Limit |
Error Upper Limit |
Warning Lower Limit |
Warning Upper Limit |
||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
ID |
A unique name for the asset. Upper and lower case letters are treated as being the same. The ID is the primary key in the database for all objects. This means that the ID field must be unique for all objects of the same object type. |
node_id |
Text |
40 |
|
0 |
|
|
|
|
|
||||||||
|
Ground level |
Height above datum of ground surface. |
ground_level |
Double |
|
Z |
3 |
|
|
|
-99.99 |
999.99 |
||||||||
|
X coordinate |
X coordinate of the object. |
x |
Double |
|
XY |
2 |
|
|
|
|
|
||||||||
|
Y coordinate |
Y coordinate of the object. |
y |
Double |
|
XY |
2 |
|
|
|
|
|
||||||||
| Survey date | Date of the most recent condition survey of the asset. | survey_date | Date / Time | 0 | |||||||||||||||
| Overall condition | A measure of the condition of the surveyed asset. | condition_grade | Long Integer | 0 | 0 | 5 | |||||||||||||
| Operational status |
Current operational status:
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
status | Text | 20 | 0 | ||||||||||||||
|
Lateral US node ID |
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 |
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 |
Link suffix of pipe to which node is laterally connected. |
lat_link_suffix |
Text |
1 |
|
0 |
|
0 |
0 |
0 |
0 |
||||||||
| Lateral channel ID | ID of channel to which node is laterally connected. | lat_channel_id | Text | 40 | 0 | 0 | 0 | 0 | 0 | ||||||||||
|
Lateral distance from US node |
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 circumferential location |
Clock reference of position of node on pipe to which node is laterally connected. |
lat_circ_location |
Integer |
|
|
0 |
|
0 |
0 |
0 |
0 |
||||||||
| Name groups | Click the  button to display the Name Groups Editor, used to view and edit the Asset Name Groups to which the object belongs. |
||||||||||||||||||
| Attachments |
Click the See Attachments Editor and Common Data Fields for further details. |
attachments | Array | ||||||||||||||||
| General properties data fields | See Common Data Fields for details of field in the General properties section of the property sheet. | ||||||||||||||||||
| User defined properties data fields | See Common Data Fields - User Fields for details of fields in the User defined properties section of the property sheet. | ||||||||||||||||||
| Time series links |
Click the |
tsdb_links |
