topic Re: Arcade Calculation Rule Increment Attribute Value in ArcGIS Utility Network Questions

Arcade Calculation Rule Increment Attribute Value

Luca_Schikowski — Tue, 16 Aug 2022 10:27:01 GMT

Hey guys,

I am working on an attribute rule for the devices in my utility network.

I have 2 different assetgroups: Adresses and distribution boxes. One distribution box is able to supply 96 units. So whenever a new adress is added, the user has to fill an attribute "Number" which contains the amount of units at this adress. This works fine so far.

The Distribution Box also has an Attribute called "Number_Apartments" which surprisingly contains the amount of units at this box. Here is where the fun begins. When an adress with for example 5 units is added (Attribute "Number" is 5), I want to increment the "Number_Apartments"-value automatically by 5. Sadly i can't get this done.

Do you have any idea how to solve this?

Thanks in advance!

Luca

Re: Arcade Calculation Rule Increment Attribute Value

JohannesLindner — Tue, 16 Aug 2022 12:48:07 GMT

That is absolutely possible. Question: How do you get the distribution box that belongs to an address? Do you have a foreign key field? Have you built a relationship class? Do you use spatial relationship?

Re: Arcade Calculation Rule Increment Attribute Value

JohannesLindner — Wed, 17 Aug 2022 11:29:06 GMT

// Calculation Attribute Rule on Addresses // field: empty // triggers: Insert, Update, Delete // Exclude from application Evaluation // if we're updating the address, but not changing the Number field, abort if($editcontext.editType == "UPDATE" && $feature.Number == $originalfeature.Number) { return } // get the related distribution box var box_name = $feature.box var box_featuredataset = FeatureSetByName(...) var box = First(Filter(box_featuredataset, "name = @box_name")) if(box == null) { return } // no related box found, abort // get the current Apartment count and calculate the new one, according to our edit mode: // Insert: add // Delete: subtract // Update: subtract old, add new var apartments = box.Number_Apartments var change = When( $editcontext.editType == "INSERT", $feature.Number, $editcontext.editType == "DELETE", -$feature.Number, $editcontext.editType == "UPDATE", -$originalfeature.Number + $feature.Number, 0 // default value ) // instead of returning a value, we return a dictionary that follows certain rules, see // https://pro.arcgis.com/en/pro-app/2.9/help/data/geodatabases/overview/attribute-rule-dictionary-keywords.htm return { "edit": [{ "className": "Addresses", "updates": [{ "globalID": box.GlobalID,//or "objectID": box.OBJECTID "attributes": {"Number_Apartments": apartments + change} }] }] }

Re: Arcade Calculation Rule Increment Attribute Value

Luca_Schikowski — Tue, 16 Aug 2022 14:44:42 GMT

Hi, my Adresses got an attribute called "box" which contains the name of the distribution box. My boxes got an attribute "name" which contains the exact same values as "box". I am using a Filter which returns all boxes with the adresses box-name:

var box_filtered = Filter(box_featuredataset, "name = @box")

Actually i never heard of Relationship Classes before. I will take a look at it. Your code is understandable and seems to do excactly what I want. I just need some time to get into relationships and will reply here if I have any more questions.

Thank you very much for your quick reply!
Have a nice day
Luca

Re: Arcade Calculation Rule Increment Attribute Value

jclarke — Tue, 16 Aug 2022 15:55:36 GMT

Hi Luca - it might be worth including a small diagram of how your addresses connect up to your distribution boxes. E.g. if they have junction-junction association then you may be able to use the Arcade functions specific to Utility Network like FeatureSetByAssociation

Re: Arcade Calculation Rule Increment Attribute Value

Luca_Schikowski — Wed, 17 Aug 2022 10:40:57 GMT

So i tried using a relationship class but it failed with error code 160263:

https://pro.arcgis.com/en/pro-app/2.9/tool-reference/tool-errors-and-warnings/160001-170000/tool-errors-and-warnings-160251-160275-160263.htm

I understand the usage of relationship classes but it seems that its not the way how I can solve this.

Re: Arcade Calculation Rule Increment Attribute Value

JohannesLindner — Wed, 17 Aug 2022 11:30:36 GMT

Hmm... That seems like a very rare error. Either you used some wrong inputs or there's something funky with your data.

This is not the place to get into this, though. If you want to create relationship classes (they can be useful but are rarely (never?) really neccessary), I suggest asking for help in the Data Management - Esri Community

You can also just use the filter you already have in place, I updated the code in my other anser.