topic Re: Help writing Arcade to get distinct values from intersection in Field Maps in ArcGIS Online Questions

Help writing Arcade to get distinct values from intersection in Field Maps

LindsayRaabe_FPCWA — Thu, 02 May 2024 05:32:10 GMT

I'm anticipating a problem I'm going to need to solve next week and don't believe my knowledge is up to it. Sooooo, I'm hoping the brains trust can help me out!

I will have 2 polygon layers in Field Maps. One contains features (plantation areas) and another will have a new feature added to it which intersects with multiple plantation areas. What I want to achieve is an arcade script that runs an intersect between the 2 layers (which I know how to do) but then takes the planting year of all the intersect plantation areas (e.g. 1992, 1992, 1992, 1995, 1996, 1996, ...) and return a concatenated string of the Distinct values (e.g. 1992, 1995, 1996, ...). This string will then get passed to Survey123 to auto populate a field in the survey.

Is this possible?

Re: Help writing Arcade to get distinct values from intersection in Field Maps

JohnEvans6 — Tue, 07 May 2024 17:03:06 GMT

Should be able to. I'm not super familiar with field maps. If I've got a good read on what you're asking for I think it looks something like

var poly1 = FeatureSetByName($map, "Plantation Areas") var intersects = Intersects(Geometry($feature), poly1) var distinct_planting = [] var display_output = "" for(var f in intersects) { Push(distinct_planting, f['plantation_year_field']) } distinct_planting = Distinct(distinct_planting) for (var pyear in distinct_planting) { display_output = display_output + distinct_planting[pyear] + ' ' } display_output = Trim(display_output) return { type : 'text', text : display_output }

Re: Help writing Arcade to get distinct values from intersection in Field Maps

LindsayRaabe_FPCWA — Wed, 08 May 2024 00:34:00 GMT

Awesome starting point. Changed my layer and field names and tested it out with the below results.

Just need to work on it a bit to filter out the "0" values (where no Year value exists) and sort from oldest to most recent (as well as the formatting to just return a value instead of the table and "text" values).

Re: Help writing Arcade to get distinct values from intersection in Field Maps

LindsayRaabe_FPCWA — Wed, 08 May 2024 01:00:42 GMT

Modified to sort values (Line 10), exclude 0 values (Line 7) and return just the output value (Line 18).

var poly1 = FeatureSetByName($map, "FPC Plantations") var intersects = Intersects(Geometry($feature), poly1) var distinct_planting = [] var display_output = "" for(var f in intersects) { iif(f['EstabYear']==0,"",Push(distinct_planting, f['EstabYear'])) } distinct_planting = Distinct(Sort(distinct_planting)) for (var pyear in distinct_planting) { display_output = display_output + distinct_planting[pyear] + ' ' } display_output = Trim(display_output) return(display_output)

And further modified to separate with commas and spaces ', ' (Line 13) plus removing the last comma and space (Line 16) which negates the need for the Trim function which only removed the original trailing space.

var poly1 = FeatureSetByName($map, "FPC Plantations") var intersects = Intersects(Geometry($feature), poly1) var distinct_planting = [] var display_output = "" for(var f in intersects) { iif(f['EstabYear']==0,"",Push(distinct_planting, f['EstabYear'])) } distinct_planting = Distinct(Sort(distinct_planting)) for (var pyear in distinct_planting) { display_output = display_output + distinct_planting[pyear] + ', ' } return(Left(display_output, Count(display_output)-2))