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; } } }

Sum of features with common value in field in pop-up using Arcade?

DaneWeeks

I have several thousand points representing trees and their proximity to hundreds of utility lines. Each tree and line has its own unique ID. Is it possible to calculate the sum of trees for each line within the popup? For example, I click on a tree point near line 123, and the pop-up window would read "213 trees remain on line 123". An important distinction is that the lines themselves are not loaded into the web map, this would simply be based on the field in the tree point attribute field.

Find more posts tagged with

Accepted answers

All comments

XanderBakker

Hi Dane Weeks ,

So, from what I understand you just want to work with the layer containing the trees and each tree has a line ID too. So you click on a tree, read out the line ID and get the count of the trees with that line ID. If this is the case it would work like this:

<SPAN class="keyword token">var</SPAN> lineID <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"your line ID field name"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> sql <SPAN class="operator token">=</SPAN> <SPAN class="string token">"your line ID field name = '"</SPAN> <SPAN class="operator token">+</SPAN> lineID <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">// for a text ID field</SPAN>
<SPAN class="keyword token">var</SPAN> sql <SPAN class="operator token">=</SPAN> <SPAN class="string token">"your line ID field name = "</SPAN> <SPAN class="operator token">+</SPAN> lineID<SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">// for a numeric ID field</SPAN>
<SPAN class="keyword token">return</SPAN> <SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Filter</SPAN><SPAN class="punctuation token">(</SPAN>$layer<SPAN class="punctuation token">,</SPAN> sql<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

DaneWeeks

Hi Xander,

Thanks for the response. Unfortunately, I didn't have any luck. I received an error "feature is immutable". I realize I poorly explained my issue. I have thousands of tree points, that are associated with 100s of lines. Each tree is only associated with one line. The lines are represented spatially, they are only included in a string value in the table of the tree feature. Here is my attempt:

var line = $feature["line_id"];

var sql = ["line_id"] = '" + line + "'";

return Count(Filter($layer, sql));

XanderBakker

Hi dane.weeks ,

Question... where are you configuring this expression? In the pop-up or somewhere else?

DaneWeeks

I clicked "configure pop-up" on the feature layer in my web map. Then "add expression".

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.