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

Arcade expression "if UPI exist"

Nicole_Ueberschär

I have a parcel layer and a point layer with surveys coming from Survey123. I would like to do the symbology of the parcel layer based on the surveys that have been filled. Both layers have the attribute UPI in common. So mainly the arcade expression should check if the UPI exists in the survey layer and if yes then return "yes". In Python I would use something like "if UPI exist in survey then update field survey_done for the row of that UPI parcel layer with yes".

Then I could use the expression result to color my parcels accordingly.

How can I do this in Arcade? (If possible)

Thanks in advance!

Finde mehr Beiträge mit dem Tag

Accepted answers

Nicole_Ueberschär

I found a solution that is in Beta 😉

I can create the survey as polygon feature class and hand over the parcel as geoshape, and then overlay the parcels with the survey results in the map. Tataa!

Now hoping to have this capability released soon...

All comments

Nicole_Ueberschär

I found a solution that is in Beta 😉

I can create the survey as polygon feature class and hand over the parcel as geoshape, and then overlay the parcels with the survey results in the map. Tataa!

Now hoping to have this capability released soon...

Nicole_Ueberschär

What a pity. Unfortunately the Survey layer is dynamic so we would have to calculate it again every time a survey was submitted... Not very userfriendly 😞

Any other idea how my parcel could reflect that the survey for this parcel was done? Both layers are quite dynamic...

XanderBakker

In the symbology profile you cannot make use of the FeatureSetBy* functions. This is due to performance reasons. You can however create a new field and use the Arcade expression in a field calculation. Note that this is not something you should do when the data is dynamic, since new and updated features will not reflect the changes.

Nicole_Ueberschär

Thanks a lot Xander! Great approach. I don't seem to be able to use that new expression field for the symbology, is that correct?

When I look in the table the field does not show yes or no but only "show" as a link. Is there a way I can "force" the value to be populated?

XanderBakker

To do this you would have to create a sql query anmd filter the data and count the result. It will look something like this:

<SPAN class="comment token">// read the UPI of the current polygon feature</SPAN>
<SPAN class="keyword token">var</SPAN> upi <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">.</SPAN>UPI<SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// create the SQL (use correct field name)</SPAN>
<SPAN class="keyword token">var</SPAN> sql <SPAN class="operator token">=</SPAN> <SPAN class="string token">"UPI = '"</SPAN> <SPAN class="operator token">+</SPAN> upi <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// access the survey data</SPAN>
<SPAN class="keyword token">var</SPAN> surveys <SPAN class="operator token">=</SPAN> <SPAN class="token function">FeatureSetByName</SPAN><SPAN class="punctuation token">(</SPAN>$map<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Exact name of survey layer in map"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// query the surveys on UPI</SPAN>
<SPAN class="keyword token">var</SPAN> surveys_in_parcel <SPAN class="operator token">=</SPAN> <SPAN class="token function">Filter</SPAN><SPAN class="punctuation token">(</SPAN>surveys<SPAN class="punctuation token">,</SPAN> sql<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// count the result</SPAN>
<SPAN class="keyword token">var</SPAN> cnt <SPAN class="operator token">=</SPAN> <SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>surveys_in_parcel<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// return the result</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>cnt <SPAN class="operator token">></SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"Yes"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"No"</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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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