nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I sum an attribute within an Arcade featureset created through intersects?

Anonymous User

I'm trying to build on the example given in "Working with data inside feature sets" found here and am having trouble finding a way to sum the DBH_TRUNK values for the tree points that intersect the neighborhoods. I thought I could use

var trees = FeatureSetByName($map,"Urban Forestry")

var countTrees = Count(Intersects(trees,$feature))

for (var t in countTrees){
return sum(countTrees,t.DBH_TRUNK)
}

but this doesn't work and neither do a few other methods I've tried. How do I access the feature set and field to do this? Thanks.

Find more posts tagged with

Accepted answers

XanderBakker

Hi Gregory Bacon ,

I guess you can do something like this:

<SPAN class="keyword token">var</SPAN> intersecting_trees <SPAN class="operator token">=</SPAN> <SPAN class="token function">Intersects</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">FeatureSetByName</SPAN><SPAN class="punctuation token">(</SPAN>$map<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Urban Forestry"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> $feature<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="comment token">// var count_trees = Count(intersecting_trees);</SPAN>
<SPAN class="keyword token">return</SPAN> <SPAN class="token function">Sum</SPAN><SPAN class="punctuation token">(</SPAN>intersecting_trees<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DBH_TRUNK"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

In your code you were trying to loop through a count. I you want to use a loop and not the Sum function, you could do something like this:

<SPAN class="keyword token">var</SPAN> intersecting_trees <SPAN class="operator token">=</SPAN> <SPAN class="token function">Intersects</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">FeatureSetByName</SPAN><SPAN class="punctuation token">(</SPAN>$map<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Urban Forestry"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> $feature<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> sum_dbh <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> tree <SPAN class="keyword token">in</SPAN> intersecting_trees<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    sum_dbh <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> tree<SPAN class="punctuation token">.</SPAN>DBH_TRUNK<SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="keyword token">return</SPAN> sum_dbh<SPAN class="punctuation token">;</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

XanderBakker

Hi Gregory Bacon ,

I guess you can do something like this:

<SPAN class="keyword token">var</SPAN> intersecting_trees <SPAN class="operator token">=</SPAN> <SPAN class="token function">Intersects</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">FeatureSetByName</SPAN><SPAN class="punctuation token">(</SPAN>$map<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Urban Forestry"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> $feature<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="comment token">// var count_trees = Count(intersecting_trees);</SPAN>
<SPAN class="keyword token">return</SPAN> <SPAN class="token function">Sum</SPAN><SPAN class="punctuation token">(</SPAN>intersecting_trees<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DBH_TRUNK"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

In your code you were trying to loop through a count. I you want to use a loop and not the Sum function, you could do something like this:

<SPAN class="keyword token">var</SPAN> intersecting_trees <SPAN class="operator token">=</SPAN> <SPAN class="token function">Intersects</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">FeatureSetByName</SPAN><SPAN class="punctuation token">(</SPAN>$map<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Urban Forestry"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> $feature<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> sum_dbh <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> tree <SPAN class="keyword token">in</SPAN> intersecting_trees<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    sum_dbh <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> tree<SPAN class="punctuation token">.</SPAN>DBH_TRUNK<SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="keyword token">return</SPAN> sum_dbh<SPAN class="punctuation token">;</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Anonymous User

Thank you. Both of these work for me. I think I was very close to success using your first method in one of my early attempts but I deleted $feature by mistake in Line 1 somehow. With respect to the for loop in method 2, you're assigning a starting value, zero, for the sum_dbh variable and the Add Assign += operator accesses the intersected features and performs 0 + DBH_TRUNK1 + DBH_TRUNK2+...etc, correct? Is either method more efficient than the other? They seem to take the same amount of time to populate the pop-up (3-4 seconds).

XanderBakker

Hi Gregory Bacon ,

You were close indeed. Only of the problems was looping through a count when that should have been a featureset. You are right about the logic. We start off with a variable sum_dbh which is set to 0 before looping through the features. For each feature the dbh_trunk is added to the running total stored in sum_dbh and that value is returned at the end of the loop.

Regarding performance, both the sum and manually looping through the features could cost the same time as you are experiencing. In theory, it should be less time when less requests are made to the server. This could be done by using a single line:

<SPAN class="keyword token">return</SPAN> <SPAN class="token function">Sum</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Intersects</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">FeatureSetByName</SPAN><SPAN class="punctuation token">(</SPAN>$map<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Urban Forestry"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> $feature<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DBH_TRUNK"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Not sure though if you will notice any difference. Another aspect could be to limit the number of fields returned by the FeatureSetByName:

<SPAN class="keyword token">return</SPAN> <SPAN class="token function">Sum</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Intersects</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">FeatureSetByName</SPAN><SPAN class="punctuation token">(</SPAN>$map<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Urban Forestry"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"DBH_TRUNK"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> False<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> $feature<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DBH_TRUNK"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

(note entirely sure if I use the correct field list)

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.