topic Re: Arcade expression for alphanumeric value in ArcGIS Online Questions

Arcade expression for alphanumeric value

KhemAryal — Mon, 09 Nov 2020 17:09:06 GMT

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

Re: Arcade expression for alphanumeric value

XanderBakker — Sat, 11 Dec 2021 14:16:15 GMT

Hi karyal@stalbert.ca_stalbert ,

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

// read out rating code
var rating = $feature["Name of the field with the rating code"];

// dictionary with numeric values according to 3C>2A>1B>1A>15>00
var dct2 = {"00": 0, "15": 1, "1A": 2,
            "1B": 3, "2A": 4, "3C": 5};

// check if rating is in dictionary and return the value
if (HasKey(dct2, rating)) {
    return dct2[rating];
} else {
    return -1;
}
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

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?

Re: Arcade expression for alphanumeric value

KhemAryal — Mon, 09 Nov 2020 19:48:42 GMT

Thanks Xander

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

Re: Arcade expression for alphanumeric value

KhemAryal — Mon, 09 Nov 2020 19:51:37 GMT

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

Re: Arcade expression for alphanumeric value

DavidPike — Mon, 09 Nov 2020 20:16:03 GMT

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

Re: Arcade expression for alphanumeric value

XanderBakker — Mon, 09 Nov 2020 20:21:08 GMT

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).

Re: Arcade expression for alphanumeric value

KhemAryal — Mon, 09 Nov 2020 20:43:42 GMT

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.

Re: Arcade expression for alphanumeric value

KhemAryal — Mon, 09 Nov 2020 20:47:16 GMT

and i have more than 1000 features with o&M ratings from 0000 to 5P4Z

Re: Arcade expression for alphanumeric value

XanderBakker — Sat, 11 Dec 2021 14:16:18 GMT

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:

// read out rating code
var rating = $feature["Name of the field with the rating code"];

// compare with "3000"
if (rating >= "3000") {
    return "Your description for red color";
} else {
    return "Your description for blue color"
}
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

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

Re: Arcade expression for alphanumeric value

KhemAryal — Mon, 09 Nov 2020 21:30:00 GMT

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

Re: Arcade expression for alphanumeric value

XanderBakker — Sat, 11 Dec 2021 14:16:21 GMT

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

Function Severity(val) {
    // should probably use different weights for severity 1 to 5
    // var dct = {"0": 0, "1": 1, "2": 2, "3": 3, "4": 4, "5": 5};
    var dct = {"0": 0, "1": 5, "2": 10, "3": 15, "4": 20, "5": 25};
    if (HasKey(dct, val)) {
        return dct[val];
    } else {
        return -1;
    }
}

Function CalculateScore(val) {
    if (Count(val) == 4) {
        var sev1 = Severity(Left(val, 1));
        Console("sev1: " + sev1);
        var sco1 = Score(Mid(val, 1, 1));
        Console("sco1: " + sco1);
        var sev2 = Severity(Mid(val, 2, 1));
        Console("sev2: " + sev2);
        var sco2 = Score(Mid(val, 3, 1));
        Console("sco2: " + sco2);
        return sev1 * sco1 + sev2 * sco2;
    } else {
        return -1;
    }
}

var rating = "5J3B";
Console("5J3B: " + CalculateScore(rating) + TextFormatting.NewLine); //  320 = 5 * 55 + 3 * 15
var rating = "3Z2Z";
Console("3Z2Z: " + CalculateScore(rating) + TextFormatting.NewLine); //  675 = 3 * 135 + 2 * 135
var rating = "5P4Z"; 
Console("5P4Z: " + CalculateScore(rating) + TextFormatting.NewLine); //  965 = 5 * 85 + 4 * 135
//return CalculateScore(rating);

return "OK";‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

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
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

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.