Goal: Create a feature set from an intersection of another layer then filter based on a field value. From there I need to define a numeric score value from a string, and finally return the average of the numeric score from the feature set .
The issue I'm having is getting just the feature set to calculate the average for.
<SPAN class="comment token">//Finds the Neighborhood Polygon that intersects with Selected Parcel</SPAN>
<SPAN class="keyword token">var</SPAN> intersectArea <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">"Neighborhoods"</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">//Defines the field to match and set the filter with </SPAN>
<SPAN class="keyword token">var</SPAN> nbhd <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">.</SPAN>NBHD<SPAN class="punctuation token">;</SPAN>
<SPAN class="comment token">//Filters all parcels with the same NBHD as the selected feature</SPAN>
<SPAN class="keyword token">var</SPAN> filterresult <SPAN class="operator token">=</SPAN> <SPAN class="token function">Filter</SPAN><SPAN class="punctuation token">(</SPAN>$layer<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'NBHD = @nbhd'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="comment token">//This returns the feature set I would like to assign a variable to and calculate an average from</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>
CDU is the field I would like to add a numeric score to average:
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>CDU<SPAN class="operator token">==</SPAN><SPAN class="string token">"FAIR"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
<SPAN class="keyword token">var</SPAN> cduVal <SPAN class="operator token">=</SPAN> <SPAN class="number token">1.25</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN>
<SPAN class="punctuation token">(</SPAN>CDU<SPAN class="operator token">==</SPAN><SPAN class="string token">"AVERAGE"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
<SPAN class="keyword token">var</SPAN> cduVal <SPAN class="operator token">=</SPAN> <SPAN class="number token">1.5</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN>
<SPAN class="punctuation token">(</SPAN>CDU<SPAN class="operator token">==</SPAN><SPAN class="string token">"EXCELLENT"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
<SPAN class="keyword token">var</SPAN> cduVal <SPAN class="operator token">=</SPAN> <SPAN class="number token">2.5</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN>
<SPAN class="punctuation token">(</SPAN>CDU<SPAN class="operator token">==</SPAN><SPAN class="string token">"EXTREMELY POOR"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
<SPAN class="keyword token">var</SPAN> cduVal <SPAN class="operator token">=</SPAN> <SPAN class="number token">0.0</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN>
<SPAN class="punctuation token">(</SPAN>CDU<SPAN class="operator token">==</SPAN><SPAN class="string token">"GOOD"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
<SPAN class="keyword token">var</SPAN> cduVal <SPAN class="operator token">=</SPAN> <SPAN class="number token">2</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN>
<SPAN class="punctuation token">(</SPAN>CDU<SPAN class="operator token">==</SPAN><SPAN class="string token">"POOR"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
<SPAN class="keyword token">var</SPAN> cduVal <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN>
<SPAN class="punctuation token">(</SPAN>CDU<SPAN class="operator token">==</SPAN><SPAN class="string token">"UNSOUND"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
<SPAN class="keyword token">var</SPAN> cduVal <SPAN class="operator token">=</SPAN> <SPAN class="number token">0.25</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN>
<SPAN class="punctuation token">(</SPAN>CDU<SPAN class="operator token">==</SPAN><SPAN class="string token">"VERY GOOD"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
<SPAN class="keyword token">var</SPAN> cduVal <SPAN class="operator token">=</SPAN> <SPAN class="number token">1.5</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN>
<SPAN class="punctuation token">(</SPAN>CDU<SPAN class="operator token">==</SPAN><SPAN class="string token">"VERY POOR"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
<SPAN class="keyword token">var</SPAN> cduVal <SPAN class="operator token">=</SPAN> <SPAN class="number token">0.75</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="keyword token">var</SPAN> cduVal <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">}</SPAN>
<SPAN class="keyword token">return</SPAN> <SPAN class="token function">Average</SPAN><SPAN class="punctuation token">(</SPAN>cduVal<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></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN></SPAN>If that makes any sense...
Any help would be appreciated.
