topic Re: Arcade - Intersecting Polygons - return multiple answers if multiple. in ArcGIS Online Questions

Arcade - Intersecting Polygons - return multiple answers if multiple.

TrishaSchlake — Thu, 12 Dec 2019 18:47:15 GMT

I have a parcel feature layer and a soils feature layer in my webmap. I'm trying to apply the arcade to my parcels layer so that when a parcel is clicked it will give me the corresponding soils to that parcel. The issue is that there could be more than one soil per parcel. The expression I currently have applied to my parcel feature class is this:

var intersectLayer = Intersects(FeatureSetByName($map,"STATSGO2Soils"), $feature)
for(var f in intersectLayer){
return f.muname
}

But it will only return one of my soils into the parcel and will not bring in multiple soils names. Is there a way to do what I'm hoping to do?

Re: Arcade - Intersecting Polygons - return multiple answers if multiple.

KenBuja — Sun, 12 Dec 2021 03:01:07 GMT

Try this instead.

var intersectLayer = Intersects(FeatureSetByName($map,"STATSGO2Soils"), $feature)
var results = "";
for(var f in intersectLayer){
  if (results == "") {
    results = f.muname;
  } else {
    results += ", " + f.muname;
  }
}
return results;‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

This would be another way

var intersectLayer = Intersects(FeatureSetByName($map,"STATSGO2Soils"), $feature)
var results = [];
for(var f in intersectLayer){
  results[Count(results)] = f.muname;
}
return Concatenate(results, ", ");‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Arcade - Intersecting Polygons - return multiple answers if multiple.

TrishaSchlake — Thu, 12 Dec 2019 19:32:15 GMT

Thank you Ken! That is exactly what I needed. I appreciate the quick help!

Re: Arcade - Intersecting Polygons - return multiple answers if multiple.

KenBuja — Thu, 12 Dec 2019 19:36:09 GMT

Glad to help (and check out the alternate code).

Please don't forget to mark the question as answered.

Re: Arcade - Intersecting Polygons - return multiple answers if multiple.

Amarz — Wed, 12 Jun 2024 15:24:11 GMT

@KenBuja

This is a very helpful code, but I am wondering is there a way to add a -1ft buffer or something? I am getting all polygons that share a border with the parcel but are not necessarily in the parcel.

Also would it be possible to add an OrderBy ASC to the script?

Re: Arcade - Intersecting Polygons - return multiple answers if multiple.

KenBuja — Wed, 12 Jun 2024 15:47:27 GMT

You can use additional chaining to add those extra functions to get the intersect layer

var intersectLayer = OrderBy( Intersects( Buffer( FeatureSetByName( $map, "STATSGO2Soils" ), -1, 'feet' ), $feature ), 'Muname DESC' );

Re: Arcade - Intersecting Polygons - return multiple answers if multiple.

Amarz — Wed, 12 Jun 2024 21:56:42 GMT

Thanks for coming back to this Ken!

Re: Arcade - Intersecting Polygons - return multiple answers if multiple.

Amarz — Wed, 24 Jul 2024 16:48:12 GMT

Hey Ken, sorry to come back, I am attempting to utilize this section in the above script using my own values but am getting the following error:

Invalid Expression. Error on line 19. Identifier expected.

var intersectLayer = OrderBy( Intersects( Buffer( FeatureSetByName( $map, "STATSGO2Soils" ), -1, 'feet' ), $feature ), 'Muname DESC' ); var results = []; for(var f in intersectLayer){ results[Count(results)] = f.muname; } return Concatenate(results, ", ");‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Any advice?

Re: Arcade - Intersecting Polygons - return multiple answers if multiple.

KenBuja — Wed, 24 Jul 2024 20:38:17 GMT

My apologies...I had the syntax incorrect. Give this a try (using your own layer and field names)

var intersectLayer = OrderBy( Intersects( FeatureSetByName($map, "other layer"), Buffer($feature, -1, "feet") ), "sortField DESC" ); var results = []; for (var f in intersectLayer) { results[Count(results)] = f["displayField"]; } var output = Concatenate(results, ", ");

Re: Arcade - Intersecting Polygons - return multiple answers if multiple.

Amarz — Thu, 25 Jul 2024 16:34:54 GMT

Any idea what is causing the following error? I ran the Check Geometry on both layers participating in this intersect with 0 errors.

ERROR 002717: Invalid Arcade expression, Arcade error: Invalid search geometry, Script line: 9 Failed to execute (CalculateField).

Re: Arcade - Intersecting Polygons - return multiple answers if multiple.

KenBuja — Thu, 25 Jul 2024 16:45:04 GMT

Could you post your code to see what's on line 9? I'm wondering if there's a null geometry in your data. I tested this on the USA States and USA Major Cities dataset from the Living Atlas and didn't get any errors.

Re: Arcade - Intersecting Polygons - return multiple answers if multiple.

Amarz — Thu, 25 Jul 2024 23:19:02 GMT

Deleting previous chat cause it wasn't relevant.

@KenBuja Thank you for all your help! I figured it out. The layer I was using had the ever dreaded Slivers in it that were less than 1ft causing the geometry error.

The code it working as expected when I reduced the negative buffer.

Thank you so much!