topic Re: automatically modify Association Containment in ArcGIS Utility Network Questions

automatically modify Association Containment

abderhman97 — Mon, 18 Nov 2024 08:56:25 GMT

I'm working with a large electric utility network data set I'm aiming to create an attribute rule or Python script that will automatically update the containment relationship between features in my utility network. Specifically, I want to ensure that each 'ElectricDevice' and 'ElectricLine' feature is correctly associated with its containing 'StructureBoundary' feature based on their spatial relationship

Re: automatically modify Association Containment

RobertKrisher — Mon, 18 Nov 2024 16:45:06 GMT

You should be able to find an example you can adapt in the attribute rule github repo: arcade-expressions/attribute-rules/attribute_rule_calculation at master · Esri/arcade-expressions · GitHub. Something like the "Contain feature in a container within a search distance" would be a good place to start.

Re: automatically modify Association Containment

JohnGoat — Fri, 22 Nov 2024 07:00:26 GMT

Hello @RobertKrisher
I can automatically establish containment relationships with arcade codes. However, I have a large amount of data (2 million features). I trigger the arcade codes during data append. This process takes approximately 72 hours, I want to do this from the Oracle database, is this possible?

Re: automatically modify Association Containment

RobertKrisher — Fri, 22 Nov 2024 13:55:51 GMT

If you're trying to create many associations at the same time you should either handle this during migration by populating the C_Associations table using a relationship or using the Create Association Records tool to establish associations based on spatial proximity. If you are beyond the asset package, you can write a Python script to generate a CSV file you can import using the Import Associations tool.

Arcade was designed to work with small collections of features at a time, it does not effectively scale to thousands of features at a time.