Skip to main content

Import Associations (Utility Network Tools)

Summary

Imports associations from a comma-separated values file (.csv) into an existing utility network. This tool can be used in conjunction with the Export Associations tool.

Learn more about how to import associations

Usage

  • Associations must be in a single .csv file.

  • Features listed in the .csv file must exist in the utility network.

  • Features listed in the .csv file must have supporting rules.

  • 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.

    When the Input Utility Network parameter references a utility network that contains a telecom domain network, the .csv file requires four additional columns: FROMFIRSTUNIT, FROMLASTUNIT, TOFIRSTUNIT, and TOLASTUNIT. When a telecom domain network is present, these header fields are required even if the target domain network is a traditional domain network. To learn more, review the Associations table help topic.

    .csv columns

    Column

    Description

    Example

    ASSOCIATIONTYPE

    The type of association.

    • Junction Junction Connectivity

    • Junction Edge From Connectivity

    • Junction Edge Midspan Connectivity

    • Junction Edge To Connectivity

    • Containment

    • Structural Attachment

    Containment

    FROMFEATURECLASS / TOFEATURECLASS

    The feature class or object participating in the association.

    ElectricDistributionDevice, ElectricDistributionAssembly, StructureJunction

    FROMASSETGROUP / TOASSETGROUP

    The asset group of the feature.

    Transformer, Fuse, Elbow

    FROMASSETTYPE / TOASSETTYPE

    The asset type of the feature.

    Streetlight, Attachment, Single-phase padmounted

    FROMGLOBALID / TOGLOBALID

    The global ID of the feature.

    {16558C73-013C-4169-A095-7E9DCD57EB57}

    FROMTERMINAL / TOTERMINAL

    The terminal participating in the association. This is only applicable to junction-junction connectivity associations.

    Single Terminal, Load, Source

    ISCONTENTVISIBLE

    A Boolean flag indicating whether the content is visible. This is only applicable to containment associations.

    False, True

    PERCENTALONG

    The percent along value for junction-edge midspan connectivity associations between a junction object and an edge object.

    0.75

    FROMFIRSTUNIT / TOFIRSTUNIT

    The first unit ID of the FROM or TO side grouping. This is only required when the Input Utility Network parameter references a utility network that contains a telecom domain network.

    1

    FROMLASTUNIT / TOLASTUNIT

    The last unit ID of the FROM or TO side grouping. This is used along with the From and To first unit attributes to determine the size of the contiguous group that is connected on the FROM or TO side. This is only required when the Input Utility Network parameter references a utility network that contains a telecom domain network.

    12

Parameters

Label Explanation Data type

Input Utility Network

The utility network to which the associations will be imported.

Utility Network; Utility Network Layer

Association Type

Specifies the type of association that will be imported.

  • All—All association types will be imported.

  • Junction-junction connectivity—The junction-junction connectivity association type will be imported.

  • Containment—The containment association type will be imported.

  • Attachment—The structural attachment association type will be imported.

  • Junction-edge connectivity (from side of edge)—The junction-edge connectivity (from side of edge) association type will be imported.

  • Junction-edge connectivity (midspan)—The junction-edge connectivity (midspan) association type will be imported.

  • Junction-edge connectivity (to side of edge)—The junction-edge connectivity (to side of edge) association type will be imported.

String

Input File

The .csv file from which the associations will be imported.

File

Derived output

Label Explanation Data type

Updated Utility Network

The updated utility network.

Utility Network

Environments

Current Workspace

Licensing information

  • Basic: No
  • Standard: Yes
  • Advanced: Yes