The Associations table stores information about all associations in a utility network. It is a system-maintained table that is hidden by default. Each row represents an association and information about the features or objects that participate in the association. Information in this table is updated when the topology is enabled or validated and when changes are made to an association using the Modify Associations pane or through ArcGIS REST API.
The Associations table stores information about the following:
- The associations in a utility network
- The features or objects that participate in an association
- Whether an association has been modified or is in error
- Editor tracking details for association records
The Associations table contains the following attributes:
Field name | Field alias | Description |
---|---|---|
OBJECTID | Object ID | The object ID for the record in the table. |
FROMNETWORKSOURCEID | From network source ID | The unique identifier for the From network source in the utility network. |
FROMGLOBALID | From global ID | The global ID of the From feature or object in the association. |
FROMTERMINALID | From terminal ID | The terminal ID of the From feature or object in the association (if applicable). |
TONETWORKSOURCEID | To network source ID | The unique identifier for the To network source in the utility network. |
TOGLOBALID | To global ID | The global ID of the To feature or object in the association. |
TOTERMINALID | To terminal ID | The terminal ID of the To feature or object in the association (if applicable). |
ASSOCIATIONTYPE | Association type | The association type. Values are the following:
|
ISCONTENTVISIBLE | Is content visible | A Boolean flag indicating whether the content is visible. This is only applicable to containment associations. |
PERCENTALONG | Percentage along | The percent along value for junction-edge midspan connectivity associations between a junction object and an edge object. |
STATUS | Status | The status value is used to communicate whether the association or its participating features or objects have been modified. |
ERRORCODE | Error code | Errors on the association are displayed using a bit encoded value that can represent one or more errors. An association with an error code of 0 indicates a record with no errors. |
ERRORMESSAGE | Error message | Additional contextual information associated with the error. |
CREATIONDATE | Creation date | The date the association was created. |
CREATOR | Creator | The user who created the association. |
LASTUPDATE | Last update | The last time the row in the table was updated. |
UPDATEDBY | Updated by | The last user to update a row in the table. |
GLOBALID | Global ID | The global ID of the row in the table. |
Access the Associations table
The Associations table is a system-maintained table that is hidden by default. You can use the From Path option on the Add Data drop-down menu to add the Associations table to a map. This can be used to provide context and support conflict management when conflicts are detected on an association record. To add the table, provide the service URL path appended with the layer ID for the Associations table (500001) as shown in the following example: https://myserver.domain.com/server/rest/services/<service name>/FeatureServer/500001.
The table is added to the map in the Contents pane under Standalone tables.
Interpret status values
The Status attribute field value indicates whether modifications have been made to an association or the features and objects that participate in the association. The values displayed in the attribute field represent decimal values that correspond with a bit encoded value. The following table outlines the status bit values and how these are presented in the Status field:
Status bit | Status field value | Description |
---|---|---|
N/A | 0 | The association is not dirty or deleted. |
0 | 1 | The association is deleted. |
1 | 2 | The feature or object on the From side of the association is deleted. |
2 | 4 | The feature or object on the To side of the association is deleted. |
3 | 8 | The association is dirty. |
4 | 16 | The object on the From side of the association is dirty. |
5 | 32 | The object on the To side of the association is dirty. |
For example, a status bit of 4 would be represented in the Status field as 16 (2^4 = 16) and indicate that the object on the From side of the association has been modified and is dirty. An association record that has not been modified or deleted does not have a bit value set and is represented with a Status attribute value of 0. These values are summated when multiple modifications are made to an association record. For example, a Status attribute of 49 indicates that the From and To object in the association is dirty and that the association itself has been deleted: (2^4 + 2^5 + 2^0) = 49.