topic Re: When to create associations? in ArcGIS Utility Network Questions

When to create associations?

mshanaghan — Wed, 15 May 2024 16:07:46 GMT

At what point in a utility network implementation do you create associations between features, eg. make a substation a container which contains transformers, switches, and regulators?

I am currently mapping fields using a data loading workspace. As I understand it, my next step will be to load data into the asset package using the "Load data using workspace" tool. Then I will apply the asset package to a geodatabase using the "asset package to geodatabase" tool.

Should associations be set up before I run the "asset package to geodatabase" tool?

Re: When to create associations?

JohnAlsup — Wed, 15 May 2024 16:16:17 GMT

Depending on the size of the database, it would probably be best to create the associations in the asset package. There is a tool in the solutions toolbox Utility Network Package tools that will automatically create the assocations based on the rules. The tool is in the Data toolset and Create Utility Network Associations.

Re: When to create associations?

mshanaghan — Wed, 15 May 2024 16:50:11 GMT

Are adjusting the attribute rules the only way to define containment associations?

Re: When to create associations?

JohnAlsup — Wed, 15 May 2024 17:14:18 GMT

Not attribute rules, you use UN Topology rules to define what can be associated with what. An attribute rule, which I did not mention, could be used to populate the association.

Re: When to create associations?

RobertKrisher — Wed, 15 May 2024 18:11:02 GMT

Performance

From a performance standpoint, putting the associations in the asset package is the fastest way to load the associations for features contained in the asset package.

You can always bulk load them later using the import associations tools, but if you do this after your data has been versioned it will be slower.

Creating Associations

You can create associations inside the asset package (based on spatial proximity) using the Create Association Records tool found in the UN Package Tools toolbox. You can also create your own tools or processes to load the C_Associations table in the asset package if you want.

You can also create your own CSV file you can bulk load/import associations using the products Import Associations tool.

You can create associations for newly created features by either using editing templates that contain associations (typically preset templates).

You can also dynamically generate associations when features are created/updated/deleted using attribute rules.

Re: When to create associations?

mshanaghan — Thu, 16 May 2024 12:16:54 GMT

So I can't create associations in the asset package using the Modify Associations pane because that pane will only be available after I apply the asset package to geodatabase?

I am mainly just trying to create containment associations.

Re: When to create associations?

JohnAlsup — Thu, 16 May 2024 12:30:19 GMT

The Modify Associations tool will not be available when working with an asset package. I would recommend using the Create Utility Network Associations and then manually review it in the Asset Package to remove any non-containment associations created. Then Run Apply Asset Package

Re: When to create associations?

mshanaghan — Mon, 20 May 2024 12:50:02 GMT

Thank you. Where would I review the associations that were created after running the "Create Utility Network Associations" tool on the asset package?

Re: When to create associations?

JohnAlsup — Mon, 20 May 2024 12:57:49 GMT

The associations created by this tool are simply added to the c_associations table in the asset package. You can look at this table before running the tool and get the largest objectid, then after running the tool, any objectid's larger than this value are new.

Re: When to create associations?

RobertKrisher — Mon, 20 May 2024 12:57:52 GMT

The C_Associations table.

Re: When to create associations?

mshanaghan — Mon, 20 May 2024 14:47:07 GMT

Is the D_Rules table meant to be edited? Should I delete rules form this table that I do not want to apply to my utility network?

Re: When to create associations?

JohnAlsup — Mon, 20 May 2024 14:49:49 GMT

If you want to remove rules, I would the Export and Import Matrix tool in the Utility Network Data Management toolbox. it would be easier to edit the spreadsheet used by these tools.

Re: When to create associations?

JohnAlsup — Mon, 20 May 2024 15:24:37 GMT

Here is a link that might help with the matrix usage.

Re: When to create associations?

mshanaghan — Mon, 20 May 2024 15:49:44 GMT

Oh cool. So I can play around with enabling and disabling rules in my asset package by editing the Rule Matrix workbook and then importing the matrix into the asset package.

At the bottom of this page, it says that if I remove a rule form the rules matrix, I still have to delete that rule from the asset package before I import the matrix. Why is this?

If I add a rule using the matrix (change cell value to 1), will I have to do anything to the asset package to enable that rule?

Re: When to create associations?

JohnAlsup — Mon, 20 May 2024 16:06:54 GMT

That statement only applies for using the matrix tool with a utility network, not an asset package.

Re: When to create associations?

mshanaghan — Mon, 20 May 2024 16:34:27 GMT

Okay thank you. Using "Import Matrix" on my asset package will take the place of "Create Utility Network Associations", correct?

Re: When to create associations?

JohnAlsup — Mon, 20 May 2024 16:46:23 GMT

No. The creating the rules and creating the associations are two different things.

Rules are what can be associated with what and how it is associated. Associations are what is associated with what.