topic Re: How to generate 'largest overlap' from polygon-in-polygon query in Attribute Rules Questions

How to generate 'largest overlap' from polygon-in-polygon query

SFM_TravisBott — Thu, 27 Apr 2023 19:57:31 GMT

Hoping the community here can lend a hand.

The goal: create a calculation attribute rule for a polygon feature class that extracts a value from the feature with which it has the largest overlap in another dataset. If a user creates a polygon I want the value of an underlying polygon to be used for an attribute in the edited datasets. However I want to have error controls in case the user creates a polygon that overlaps two of the underlying polygons. I want to extract the attribute from the polygon with which it has the largest overlap.

Current code:

var fsJurisdiction = FeatureSetByName($datastore, "jurisdictions", ["Jurisdiction"]) var fsJurisdictionIntersect = Intersects(fsJurisdiction, $feature) var jurisdiction = First(fsJurisdictionIntersect) if (jurisdiction == null) return {"errorMessage": "Not in a jurisdiction"} return jurisdiction.Jurisdiction

Re: How to generate 'largest overlap' from polygon-in-polygon query

JohannesLindner — Fri, 28 Apr 2023 05:53:54 GMT

var fsJurisdiction = FeatureSetByName($datastore, "jurisdictions", ["Jurisdiction"]) var fsJurisdictionIntersect = Intersects(fsJurisdiction, $feature) var intersected_jurisdictions = [] for(var j in fsJurisdictionIntersect) { var jurisdiction = { Jurisdiction: j.Jurisdiction, Overlap: Area(Intersection(j, $feature)) } Push(intersected_jurisdictions, jurisdiction) } function sort_by_overlap(j1, j2) { return j1.Overlap < j2.Overlap } var jurisdiction = First(Sort(intersected_jurisdictions, sort_by_overlap)) if (jurisdiction == null) return {"errorMessage": "Not in a jurisdiction"} return jurisdiction.Jurisdiction

Re: How to generate 'largest overlap' from polygon-in-polygon query

SFM_TravisBott — Fri, 28 Apr 2023 21:18:25 GMT

Well that worked perfectly. Gold star for @JohannesLindner . Thank you!

Re: How to generate 'largest overlap' from polygon-in-polygon query

SFM_TravisBott — Mon, 01 May 2023 17:15:54 GMT

@JohannesLindner I actually wanted to follow up here in case you have additional knowledge - the syntax you gave me works flawlessly in 3.x. However I opened the gdb in 2.9 and it reverts to the same behavior when using First....it stops using largest overlap as you've described.

Is this a known limitation?

Re: How to generate 'largest overlap' from polygon-in-polygon query

JohannesLindner — Mon, 01 May 2023 20:08:38 GMT

Do you actually use this expression in 2.9?

The expression should work for ArcGIS Pro 2.7+

Re: How to generate 'largest overlap' from polygon-in-polygon query

SFM_TravisBott — Mon, 01 May 2023 22:06:18 GMT

I did test it in 2.9

I opened the database I created in 3.1, where the rules executed successfully, in 2.9. The overlap rule no longer works and it takes the first jurisdiction only.

Re: How to generate 'largest overlap' from polygon-in-polygon query

JohannesLindner — Tue, 02 May 2023 07:38:02 GMT

Sorry to say that I have no clue.

Try deleting the rule and creating it in 2.9.