Exports connectivity, containment, and structural attachment associations from a utility network into a comma separated values (.csv) file.
All types of associations can be exported including junction-junction connectivity, structural attachment, and containment.
The information in the .csv file is stored in the following format: ASSOCIATIONTYPE, FROMFEATURECLASS, FROMASSETGROUP, FROMASSETTYPE, FROMGLOBALID, FROMTERMINAL, TOFEATURECLASS, TOASSETGROUP, TOASSETTYPE, TOGLOBALID, TOTERMINAL, ISCONTENTVISIBLE.
Column Description Example
The type of association.
JUNCTION_JUNCTION_CONNECTIVITY, CONTAINMENT, STRUCTURAL_ATTACHMENT
The feature class participating in the association.
ElectricDistributionDevice, ElectricDistributionAssembly, StructureDevice
The asset group of the feature.
Transformer, Fuse, Elbow
The asset type of the feature.
Streetlight, Attachment, Single-phase padmounted
The global ID of the feature.
The terminal participating in the association. This is only applicable to junction-junction associations.
Single Terminal, Load, Source
A Boolean flag indicating whether the content is visible. This is only applicable to structural attachment and containment associations.
Associations of the specified type must be present in order to export them.
This tool can be used in conjunction with the Import Associations tool.
The connected ArcGIS Enterprise portal account must be the portal utility network owner.
The input utility network must be from a database connection established as the database utility network owner.
ExportAssociations(in_utility_network, association_type, out_csv_file)
The utility network containing the associations to export.
|Utility Network; Utility Network Layer|
The type of association to export.
The name and location of the .csv file that will be generated.
This sample script exports all associations for a utility network called GridNetwork.
import arcpy arcpy.ExportUtilityNetworkAssociations_un("GridNetwork", "ALL", r"C:\Temp\AllAssociations.csv")
This sample script exports junction-junction connectivity associations for a utility network called GridNetwork.
import arcpy arcpy.ExportUtilityNetworkAssociations_un("GridNetwork", "JUNCTION_JUNCTION_CONNECTIVITY", r"C:\Temp\JJAssociations.csv")
This sample script exports containment associations for a utility network called GridNetwork.
import arcpy arcpy.ExportUtilityNetworkAssociations_un("GridNetwork", "CONTAINMENT", r"C:\Temp\ContainmentAssociations.csv")
This sample script exports structural attachment associations for a utility network called GridNetwork.
import arcpy arcpy.ExportUtilityNetworkAssociations_un("GridNetwork", "STRUCTURAL_ATTACHMENT", r"C:\Temp\StructureAssociations.csv")
- Basic: No
- Standard: Yes
- Advanced: Yes