topic Re: Conditional Symbology based on Script in ArcGIS Online Questions

Conditional Symbology based on Arcade Script?

JoseLGonzalez — Wed, 26 Feb 2025 16:59:55 GMT

I'm trying to set up conditional symbology by turning the contents of the highlighted row, under the column “ALL_UNITS” into an array. So the array should contain the elements: E29, E64, E82, E244, and E286. Once the array is established, the script should check the column RedUnits for matches. Therefore, the points for STANUM 29 should have the “White Yellow” symbology.

var st1102 = IIf($feature["STANUM"] == 1102, $feature["ALL_UNITS"], null);

var st1102array = Split(st1102, ",");

if (Includes(st1102array, $feature.RedUnits))

return "White Yellow";

else if ($feature.RedUnits == null && $feature.GreenUnits == null && $feature.BlueUnits != null)

return "Brown";

else if ($feature.RedUnits == null && $feature.GreenUnits != null)

return "Grey";

else if ($feature.RedUnits != null)

return "White";

else

return "Black";

Re: Conditional Symbology based on Script

KenBuja — Fri, 21 Feb 2025 21:36:46 GMT

One thing I see is that st1102array is ["E29"," E64"," E82"," E244"," E286"]. Note that there is a space before all of text elements except the first. This means that if RedUnits was "E64", it would return "White" instead of "White Yellow". You should use ", " instead of "," for the separator in the Split function.

The other thing I see is if there are two items in RedUnits (STATNUM 33), it would return "White". You can split RedUnits into an array to check if any of them match.

This should work properly

var st1102 = IIf($feature["STANUM"] == 1102, $feature["ALL_UNITS"], null); var st1102array = Split(st1102, ", "); var RedUnitsArray = Split($feature.RedUnits, ", "); for (var i in RedUnitsArray) { if (Includes(st1102array, RedUnitsArray[i])) return "White Yellow"; } if ( $feature.RedUnits == null && $feature.GreenUnits == null && $feature.BlueUnits != null ) return "Brown"; else if ($feature.RedUnits == null && $feature.GreenUnits != null) return "Grey"; else if ($feature.RedUnits != null) return "White"; else return "Black";

Re: Conditional Symbology based on Script

JoseLGonzalez — Fri, 21 Feb 2025 22:06:53 GMT

Thanks so much for the reply @KenBuja.

Your script yielded an interesting result, the only points that got the White Yellow symbology are three test points I created with null values in the RedUnits column.

Re: Conditional Symbology based on Script

KenBuja — Fri, 21 Feb 2025 22:33:01 GMT

I was testing with dummy data and didn't include the IIf statement, which threw things off. Here's the testing code with an update in line 13 in this code (line 6 of the previous code)

var STANUM = 1102; var ALL_UNITS = "E29, E64, E82, E244, E286" var st1102 = IIf(STANUM == 1102, ALL_UNITS, null); var RedUnits //= "E29" var GreenUnits //= "Q30" var BlueUnits //= "S32" var st1102array = Split(st1102, ", "); var RedUnitsArray = Split(RedUnits, ", "); console(st1102array, RedUnitsArray) for (var i in RedUnitsArray) { if (!IsEmpty(st1102) && Includes(st1102array, RedUnitsArray[i])) return "White Yellow"; } if ( RedUnits == null && GreenUnits == null && BlueUnits != null ) return "Brown"; else if (RedUnits == null && GreenUnits != null) return "Grey"; else if (RedUnits != null) return "White"; else return "Black";

This allowed me to test different scenarios, like changing STATNUM and the units to verify that each of the returns work.

Re: Conditional Symbology based on Script

JoseLGonzalez — Mon, 24 Feb 2025 19:20:23 GMT

Thanks for continuing to work on this, @KenBuja.

Unfortunately, the updated script gave only black points.

Re: Conditional Symbology based on Script

KenBuja — Mon, 24 Feb 2025 19:38:57 GMT

Unfortunately, without access to your data, there's not much more I can do. I made sure each of the possible combinations of variables in my test code would give the expected response. For example, changing this line

var GreenUnits = "Q30"

returns "Grey"

Re: Conditional Symbology based on Script

JoseLGonzalez — Tue, 25 Feb 2025 18:09:41 GMT

Copy that. I appreciate your efforts, Ken! 🙏