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 for alphanumeric value

karyal@stalbert.ca_stalbert

I am creating a map showing different ratings for a feature. When data was collected rating was as below (an example).

00 : No defects
15 : 5 Minor defects
1A : More than 10 but less than 15 Minor defect
2A : More than 10 but less than 15 major defects
1B : more than 15 but less than 20 major defects
3C More than 20 but less than 25 significant defects

A represents values from 11-15

B represents values from 16-20

C represents values from 21-25

how do I create arcade expression to reflect alphanumeric as a numeric value to indicate the conditions where 3C>2A>1B>1A>15>00

thanks in advance

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

XanderBakker

Hi karyal@stalbert.ca_stalbert ,

See below an example of an expression that will assign a numeric sequential value:

<SPAN class="comment token">// read out rating code</SPAN>
<SPAN class="keyword token">var</SPAN> rating <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Name of the field with the rating code"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// dictionary with numeric values according to 3C>2A>1B>1A>15>00</SPAN>
<SPAN class="keyword token">var</SPAN> dct2 <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">"00"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"15"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"1A"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN>
            <SPAN class="string token">"1B"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"2A"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"3C"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">5</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// check if rating is in dictionary and return the value</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="token function">HasKey</SPAN><SPAN class="punctuation token">(</SPAN>dct2<SPAN class="punctuation token">,</SPAN> rating<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">return</SPAN> dct2<SPAN class="punctuation token">[</SPAN>rating<SPAN class="punctuation token">]</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="operator token">-</SPAN><SPAN class="number token">1</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>

You can change the values (0 to 5) in the dictionary defined on lines 5 and 6 with values representing a number in the range of the rating code if that is what you prefer. Is there are specific reason why you want the values to be numeric?

karyal@stalbert.ca_stalbert

Thanks Xander

However I have more complex data for over thousands features eg:

karyal@stalbert.ca_stalbert

I want the values be numeric (or treated as number) so higher the number most defective the features are and can be visualized in the map with different color

thanks

DavidPike

The rating you gave an example of and the o_m_rating pictured don't align.

XanderBakker

Hi Khem Aryal ,

From the information you provided in the original post and screen shot you provided after this, I see two complete distinct things. Can you explain how the values ("352N", "3522", "342Z", etc) should be interpreted? I am sure something must be possible, but in order to help you further I need to understand how to interpret every possible value (and not just a subset of them).

karyal@stalbert.ca_stalbert

My apology not describing the whole scenario.

These are the pipe inspection rating

where first letter indicates severity of defects (1-5) 1 being the least severe 5 being the most severe

second letter indicates the numbers of those most severe defects where more than 10 is A, more than 15 is B and so on

Third letter indicates the second-most severe defect (1-5) and last letter indicates the numbers of those second-most severe defects as more than 10 is A and more than 15 is B and so on

this rating is auto generated in the inspection software

for example

5J3B

means the pipe has 50 (J) of 5 rated severe defects and 15(B) of 3 rated severe defects.

similarly

352N means

the pipe has 5 of 3 rated defects and 70(N) of 2 rated defects

(again each letter represents increment of 5)

I like to visualize this data as lines rated more than 3 0 0 0 (results from O&M rating) in red color and anything below 3 0 0 0 in blue color

352N>3000

351g>3000

I am not sure if this make sense.

XanderBakker

Hi karyal@stalbert.ca_stalbert ,

That is actually a simple thing to do assuming that each rating always has the same structure using 4 characters.

Please try this:

<SPAN class="comment token">// read out rating code</SPAN>
<SPAN class="keyword token">var</SPAN> rating <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Name of the field with the rating code"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// compare with "3000"</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>rating <SPAN class="operator token">>=</SPAN> <SPAN class="string token">"3000"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"Your description for red color"</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">"Your description for blue color"</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>

It compares the text in an alphabetic way (using the first character), assuming that "2Z2Z" is less than "3000".

karyal@stalbert.ca_stalbert

WOW, I was thinking it would be complex. Thank you Xander Bakker

XanderBakker

Hi Khem Aryal ,

Another way would be to use a value renderer based on the severity and frequency of the events. See some sample code below (this will use some sample rating and try to create a numeric value from it based on a weight for severity multiplied by the frequency).

Function <SPAN class="token function">Score</SPAN><SPAN class="punctuation token">(</SPAN>val<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    val <SPAN class="operator token">=</SPAN> <SPAN class="token function">Upper</SPAN><SPAN class="punctuation token">(</SPAN>val<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">var</SPAN> dct <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">"0"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"1"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"2"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"3"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"4"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"5"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN>
               <SPAN class="string token">"6"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"7"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"8"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"9"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">9</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"A"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">10</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"B"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">15</SPAN><SPAN class="punctuation token">,</SPAN>
               <SPAN class="string token">"C"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">20</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"D"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">25</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"E"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">30</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"F"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">35</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"G"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">40</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"H"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">45</SPAN><SPAN class="punctuation token">,</SPAN>
               <SPAN class="string token">"I"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">50</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"J"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">55</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"K"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">60</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"L"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">65</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"M"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">70</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"N"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">75</SPAN><SPAN class="punctuation token">,</SPAN>
               <SPAN class="string token">"O"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">80</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"P"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">85</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Q"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">90</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"R"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">95</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"S"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">100</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"T"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">105</SPAN><SPAN class="punctuation token">,</SPAN>
               <SPAN class="string token">"U"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">110</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"V"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">115</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"W"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">120</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"X"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">125</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Y"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">130</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Z"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">135</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="token function">HasKey</SPAN><SPAN class="punctuation token">(</SPAN>dct<SPAN class="punctuation token">,</SPAN> val<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
        <SPAN class="keyword token">return</SPAN> dct<SPAN class="punctuation token">[</SPAN>val<SPAN class="punctuation token">]</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="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>

Function <SPAN class="token function">Severity</SPAN><SPAN class="punctuation token">(</SPAN>val<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="comment token">// should probably use different weights for severity 1 to 5</SPAN>
    <SPAN class="comment token">// var dct = {"0": 0, "1": 1, "2": 2, "3": 3, "4": 4, "5": 5};</SPAN>
    <SPAN class="keyword token">var</SPAN> dct <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">"0"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"1"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"2"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">10</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"3"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">15</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"4"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">20</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"5"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">25</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="token function">HasKey</SPAN><SPAN class="punctuation token">(</SPAN>dct<SPAN class="punctuation token">,</SPAN> val<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
        <SPAN class="keyword token">return</SPAN> dct<SPAN class="punctuation token">[</SPAN>val<SPAN class="punctuation token">]</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="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>

Function <SPAN class="token function">CalculateScore</SPAN><SPAN class="punctuation token">(</SPAN>val<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>val<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="number token">4</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
        <SPAN class="keyword token">var</SPAN> sev1 <SPAN class="operator token">=</SPAN> <SPAN class="token function">Severity</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Left</SPAN><SPAN class="punctuation token">(</SPAN>val<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"sev1: "</SPAN> <SPAN class="operator token">+</SPAN> sev1<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="keyword token">var</SPAN> sco1 <SPAN class="operator token">=</SPAN> <SPAN class="token function">Score</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Mid</SPAN><SPAN class="punctuation token">(</SPAN>val<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"sco1: "</SPAN> <SPAN class="operator token">+</SPAN> sco1<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="keyword token">var</SPAN> sev2 <SPAN class="operator token">=</SPAN> <SPAN class="token function">Severity</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Mid</SPAN><SPAN class="punctuation token">(</SPAN>val<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"sev2: "</SPAN> <SPAN class="operator token">+</SPAN> sev2<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="keyword token">var</SPAN> sco2 <SPAN class="operator token">=</SPAN> <SPAN class="token function">Score</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Mid</SPAN><SPAN class="punctuation token">(</SPAN>val<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"sco2: "</SPAN> <SPAN class="operator token">+</SPAN> sco2<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="keyword token">return</SPAN> sev1 <SPAN class="operator token">*</SPAN> sco1 <SPAN class="operator token">+</SPAN> sev2 <SPAN class="operator token">*</SPAN> sco2<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="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>

<SPAN class="keyword token">var</SPAN> rating <SPAN class="operator token">=</SPAN> <SPAN class="string token">"5J3B"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"5J3B: "</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="token function">CalculateScore</SPAN><SPAN class="punctuation token">(</SPAN>rating<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> TextFormatting<SPAN class="punctuation token">.</SPAN>NewLine<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">//  320 = 5 * 55 + 3 * 15</SPAN>
<SPAN class="keyword token">var</SPAN> rating <SPAN class="operator token">=</SPAN> <SPAN class="string token">"3Z2Z"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"3Z2Z: "</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="token function">CalculateScore</SPAN><SPAN class="punctuation token">(</SPAN>rating<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> TextFormatting<SPAN class="punctuation token">.</SPAN>NewLine<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">//  675 = 3 * 135 + 2 * 135</SPAN>
<SPAN class="keyword token">var</SPAN> rating <SPAN class="operator token">=</SPAN> <SPAN class="string token">"5P4Z"</SPAN><SPAN class="punctuation token">;</SPAN> 
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"5P4Z: "</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="token function">CalculateScore</SPAN><SPAN class="punctuation token">(</SPAN>rating<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> TextFormatting<SPAN class="punctuation token">.</SPAN>NewLine<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">//  965 = 5 * 85 + 4 * 135</SPAN>
<SPAN class="comment token">//return CalculateScore(rating);</SPAN>

<SPAN class="keyword token">return</SPAN> <SPAN class="string token">"OK"</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>‍</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>

This will write to the console:

sev1: 25
sco1: 55
sev2: 15
sco2: 15
5J3B: 1600

sev1: 15
sco1: 135
sev2: 10
sco2: 135
3Z2Z: 3375

sev1: 25
sco1: 85
sev2: 20
sco2: 135
5P4Z: 4825
<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>

It all depends a lot on how you compare a severity 1 to 2 to 3 to 4 to 5... Also, in my example J is translated to 55, but maybe the coding does not include the character "I"?

Having access to this type of data with the number of incidents per pipe, it would be nice to do some predictive analysis and include material, diameter, pressure, and other additional data.

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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