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

A simple arcade question

CandiceBardsley1

Hi - I am new to arcade so need to ask a very simple question...

Is there an 'and' function?

I want to show a warning symbol if a threshold (1951) is met. Each of the objects in the feature class has a different threshold hence I want to isolate each object, then set a value for it.

I've tried the expression below but 'and' mustn't be an option.

If ($feature.OBJECTID=9) and ($feature["PI_Value"] >1951)
{return "warning"} else {return "ok"}

Any help would be greatly appreciated...

Find more posts tagged with

Accepted answers

XanderBakker

Depending on the number of features and different thresholds you have you could have a dictionary that stores the thresholds per ObjectID and you check the PI value against that threshold:

<SPAN class="keyword token">var</SPAN> thresholds <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">"9"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">1951</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"10"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">1749</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"11"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">2103</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">var</SPAN> oid <SPAN class="operator token">=</SPAN> <SPAN class="token function">Text</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">.</SPAN>OBJECTID<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> pi_value <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"PI_Value"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>pi_value <SPAN class="operator token">></SPAN> thresholds<SPAN class="punctuation token">[</SPAN>oid<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"warning"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"ok"</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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

However, it is better to have a threshold stored at feature level (in a field) and compare against it:

<SPAN class="keyword token">var</SPAN> threshold <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Threshold"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> pi_value <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"PI_Value"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>pi_value <SPAN class="operator token">></SPAN> threshold<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"warning"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"ok"</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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Concerning the error you obtained, you need to use the double equal to compare value (single equal sign is an assignment):

If <SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">.</SPAN>OBJECTID<SPAN class="operator token">==</SPAN><SPAN class="number token">9</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">&&</SPAN> <SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"PI_Value"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">></SPAN><SPAN class="number token">1951</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"warning"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"ok"</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>‍</SPAN></SPAN>

All comments

jamosheim25

Is this what you are looking for?

CandiceBardsley1

Hi John

I’ve tried this:

If ($feature.OBJECTID=9) && ($feature["PI_Value"] >1951)

{return "warning"} else {return "ok"}

But get a parse error: unexpected token &&

So I must still be doing something wrong.

jamosheim25

Hi Candice, I'm not a wiz but maybe this might do it ("if" expression does not appear to have the right syntax)

John

XanderBakker

Depending on the number of features and different thresholds you have you could have a dictionary that stores the thresholds per ObjectID and you check the PI value against that threshold:

<SPAN class="keyword token">var</SPAN> thresholds <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">"9"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">1951</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"10"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">1749</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"11"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">2103</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">var</SPAN> oid <SPAN class="operator token">=</SPAN> <SPAN class="token function">Text</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">.</SPAN>OBJECTID<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> pi_value <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"PI_Value"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>pi_value <SPAN class="operator token">></SPAN> thresholds<SPAN class="punctuation token">[</SPAN>oid<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"warning"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"ok"</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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

However, it is better to have a threshold stored at feature level (in a field) and compare against it:

<SPAN class="keyword token">var</SPAN> threshold <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Threshold"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> pi_value <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"PI_Value"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>pi_value <SPAN class="operator token">></SPAN> threshold<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"warning"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"ok"</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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Concerning the error you obtained, you need to use the double equal to compare value (single equal sign is an assignment):

If <SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">.</SPAN>OBJECTID<SPAN class="operator token">==</SPAN><SPAN class="number token">9</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">&&</SPAN> <SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"PI_Value"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">></SPAN><SPAN class="number token">1951</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"warning"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"ok"</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>‍</SPAN></SPAN>

CandiceBardsley1

Thanks Xander, the double == solved my problem. Regarding the second option of having the threshold stored at feature level, I didn't do this because in the case of this feature class, some of the thresholds are actually when the pi_value is lower than the threshold number, so your script wouldn't work in this instance.

Your first option of using a dictionary has taken what I originally asked for to the next level and is perfect for what I am after. For some reason though when I enter the script like you've written it I get Execution Error:Field not Found...

Is there something missing or do I need to have a threshold entered for every object ID for this to work?

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.