Arcade: Create Filter On Buffer & Intersect of Feature

ArmstKP

I have a bench layer for example.  Two of the fields are {Park_Name} and {condition_score}

I am trying to write an expression that shows me the average bench score in the park, where I clicked on that bench.

I at least have this built so far:

var benchBuff = Buffer($feature, 3000, 'foot')

var benchWithin = Intersects(benchBuff, $layer)

return Round(Average(benchWithin, "condition_score"), 1)

 

I am just not sure how or where to include the {Park_Name} filter and/or sql variable in the expression?

 

jcarlson

You just need the output limited to benches in the same park? You can filter the layer earlier in the expression by attribute, and then use those filtered features in your Intersects function

var park_benches = Filter($layer, `Park_Name = '${$feature['Park_Name']}'`)

var benchBuff = Buffer($feature, 3000, 'foot')

var benchWithin = Intersects(benchBuff, park_benches)

return Round(Average(benchWithin, "condition_score"), 1)