topic Re: Intersect arcade expressions for calculating fields and symbology based on intersects between two layers in ArcGIS Online Questions

Intersect arcade expressions for calculating fields and symbology based on intersects between two layers

DataOfficer — Wed, 06 Jan 2021 18:43:33 GMT

Is there any way to calculate the field of an attribute table, or symbology based on an arcade expression for the intersect of two layers? A point layer and a polygon layer in this instance.

I am able to use an Intersects expression in a popup, e.g.:

// get the count for all sites in the grid var sites = FeatureSetByName($map,"Sites") var countSites = Count(Intersects(sites,$feature)) return countSites

However the expressions available to calculate an attribute table field or symbology do not accept $map during the use of the FeatureSetByName function, giving the following error:

Execution Error:Runtime Error: Identifier Not Found. $map

Are there plans for this functionality to be supported in future?

Re: Intersect arcade expressions for calculating fields and symbology based on intersects between two layers

XanderBakker — Tue, 12 Jan 2021 19:13:13 GMT

Hi @DataOfficer ,

Q: Is there any way to calculate the field of an attribute table based on an arcade expression for the intersect of two layers?

A: Yes, if the data is stored in the same datastore and you are using $datastore in the Arcade expression ($map is not supported in the Field Calculation profile)

Q: Is there any way to define the symbology based on an arcade expression for the intersect of two layers?

A: No, the symbology profile does not provide access to other features and featuresets. You can however, calculate a field based on other features and featuresets and define the symbology on that newly created field.

Re: Intersect arcade expressions for calculating fields and symbology based on intersects between two layers

DataOfficer — Wed, 13 Jan 2021 12:51:52 GMT

Hi @XanderBakker,
That's fantastic, thank you for the in-depth response. I will give it a try via the $datastore route.

Re: Intersect arcade expressions for calculating fields and symbology based on intersects between two layers

NedCake1 — Thu, 03 Feb 2022 22:03:59 GMT

Hi @XanderBakker and @DataOfficer

Thanks for the $datastore recommendation it works perfectly!

Thought I'd leave a pic and some sample code for those that follow. I know it always helps me. The sample gets intersecting zip code values from a zip code layer (polygon) and calculates a Zip Code field for a law enforcement beats layer (polygon). If there is more than one intersecting zip code it will calculate the zip codes additional values with a coma separator.