Export Associations (Utility Network Tools)

Summary

Exports associations from a utility network to a comma-separated-values file (.csv). This tool can be used in conjunction with the Import Associations tool.

Learn more about how to export associations

Usage

When working with an enterprise geodatabase, the Input Utility Network parameter value must be from a database connection established as the database utility network owner.
The information in the .csv file is stored in the following format: ASSOCIATIONTYPE, FROMFEATURECLASS, FROMASSETGROUP, FROMASSETTYPE, FROMGLOBALID, FROMTERMINAL, TOFEATURECLASS, TOASSETGROUP, TOASSETTYPE, TOGLOBALID, TOTERMINAL, ISCONTENTVISIBLE, PERCENTALONG.

Label	Explanation	Data type
Input Utility Network	The utility network containing the associations to export.	Utility Network; Utility Network Layer
Association Type	Specifies the type of association to export. All—All association types in the utility network will be exported to a `.csv` file. Junction-junction connectivity—Connectivity associations allowing two junction subtypes to connect via a connectivity association (features are offset geometrically) will be exported to a `.csv` file. Containment—The containment association type will be exported to a `.csv` file. Attachment—The structural attachment association type will be exported to a `.csv` file. Junction-edge connectivity (from side of edge)—The junction-edge (from side of edge) connectivity association type will be exported to a `.csv` file. Junction-edge connectivity (midspan)—The junction-edge (midspan) connectivity association type will be exported to a `.csv` file. Junction-edge connectivity (to side of edge)—The junction-edge (to side of edge) connectivity association type will be exported to a `.csv` file.	String
Output File	The name and location of the `.csv` file that will be generated.	File

arcpy.un.ExportAssociations(in_utility_network, association_type, out_csv_file)

Name	Explanation	Data type
in_utility_network	The utility network containing the associations to export.	Utility Network; Utility Network Layer
association_type	Specifies the type of association to export. `ALL`—All association types in the utility network will be exported to a `.csv` file. `JUNCTION_JUNCTION_CONNECTIVITY`—Connectivity associations allowing two junction subtypes to connect via a connectivity association (features are offset geometrically) will be exported to a `.csv` file. `CONTAINMENT`—The containment association type will be exported to a `.csv` file. `STRUCTURAL_ATTACHMENT`—The structural attachment association type will be exported to a `.csv` file. `JUNCTION_EDGE_FROM_CONNECTIVITY`—The junction-edge (from side of edge) connectivity association type will be exported to a `.csv` file. `JUNCTION_EDGE_MIDSPAN_CONNECTIVITY`—The junction-edge (midspan) connectivity association type will be exported to a `.csv` file. `JUNCTION_EDGE_TO_CONNECTIVITY`—The junction-edge (to side of edge) connectivity association type will be exported to a `.csv` file.	String
out_csv_file	The name and location of the `.csv` file that will be generated.	File

Code sample

ExportAssociations example 1 (Python window)

This sample script exports all associations for a utility network called GridNetwork.

import arcpy
arcpy.un.ExportAssociations("GridNetwork", "ALL",
                            r"C:\Temp\AllAssociations.csv")

ExportAssociations example 2 (Python window)

This sample script exports junction-junction connectivity associations for a utility network called GridNetwork.

import arcpy
arcpy.un.ExportAssociations("GridNetwork", "JUNCTION_JUNCTION_CONNECTIVITY",
                            r"C:\Temp\JJAssociations.csv")

ExportAssociations example 3 (Python window)

This sample script exports containment associations for a utility network called GridNetwork.

import arcpy
arcpy.un.ExportAssociations("GridNetwork", "CONTAINMENT",
                            r"C:\Temp\ContainmentAssociations.csv")

ExportAssociations example 4 (Python window)

This sample script exports structural attachment associations for a utility network called GridNetwork.

import arcpy
arcpy.un.ExportAssociations("GridNetwork", "STRUCTURAL_ATTACHMENT",
                            r"C:\Temp\StructureAssociations.csv")

Environments

This tool does not use any geoprocessing environments.

Licensing information