topic Attribute Rule to update M:N relationship table using intersect in Attribute Rules Questions

Attribute Rule to update M:N relationship table using intersect

BillMoody — Wed, 23 Aug 2023 19:01:34 GMT

I'm wondering if it would be possible to update a M:N relationship table between a point layer and a polygon layer based on an intersect.

Example: I draw a polygon on a map that represents an area that needs to have tree trimming work. The polygon covers all of the trees (points) that need to be trimmed.

Upon polygon creation I would like the rule to grab the GlobalID all of the intersecting trees and push them to the relationship table and also grab the GlobalID of the polygon and match that in the corresponding rows of the those tree IDs.

The reason for this is to make it possible to utilize the many to many relationship within an application like Field Maps, which I don't think can be done out of the box.

Thanks for any suggestions!

Re: Attribute Rule to update M:N relationship table using intersect

HusseinNasser2 — Wed, 23 Aug 2023 21:26:40 GMT

Yes it is possible by returning an edit dictionary against the attributed relationshipclass table, here is a sample filegdb .

(view in My Videos)

script

Re: Attribute Rule to update M:N relationship table using intersect

BillMoody — Thu, 24 Aug 2023 12:55:20 GMT

@HusseinNasser2 you have quickly become my new hero over the last few days. This works flawlessly!

Quick question: I am not a coder by any means but I understand the majority of the above. I am not grasping what "var c" is doing nor the purpose of the array "[c++]". Could you clarify that variable's purpose as well as what the "++" does to modify it? Just so I have a better understanding in the future.

Much appreciated!

Re: Attribute Rule to update M:N relationship table using intersect

HusseinNasser2 — Thu, 24 Aug 2023 16:15:35 GMT

certainly!

c is a variable, and when we say c++ this translate to add 1 to the value of c

this whole thing is for us to start building a payload

so essentially each tree gets its own payload

tree 0 -> payload 0

tree 1-> payload 1

etc...

and so on..

Re: Attribute Rule to update M:N relationship table using intersect

BillMoody — Thu, 24 Aug 2023 16:32:45 GMT

Genius! Thank you again for your assistance as well as your tutorials on YouTube. All of this has been extremely helpful