topic Re: Symbolizing Unique values with wildcards in ArcGIS Pro Questions

Symbolizing Unique values with wildcards

BrianBulla — Mon, 27 Mar 2023 18:47:42 GMT

So I need to symbolize based on two attributes: the INSP_STATUS and the Subtype. If there is no INSP_STATUS (ie. = null), than each subtype will have a different symbol.

But....if there is an INSP_STATUS (ie. a few different options), than regardless of the Subtype, they can all be the same symbol. This is what I have so far....a symbol for each subtype:

When I try to add a custom value with some conditional statement for the "YES" INSP_STATUS to cover all of the sybytpes, I just get an error:

Does anyone know how to accomplish this?? Or do I just need to make a symbol for every possible combination of INSP_STATUS and Subtype??

Re: Symbolizing Unique values with wildcards

SLouq — Mon, 27 Mar 2023 19:04:47 GMT

Can you change your primary symbology to Manual Breaks and categorize the symbology that way? Just click the more option and select show values out of range for the null option

Re: Symbolizing Unique values with wildcards

BrianBulla — Mon, 27 Mar 2023 19:08:21 GMT

Manual Breaks?? I'm not sure what you are talking about. I'm using Unique Values with two attributes....Subtype Code and INSP_STATUS. I'm not symbolizing numerical data.

Re: Symbolizing Unique values with wildcards

SLouq — Mon, 27 Mar 2023 19:21:37 GMT

Maybe you can't use Manual Breaks then. Try different Primary symbology and see if you can accomplish your goal that way.

Re: Symbolizing Unique values with wildcards

DanielMiranda2 — Mon, 27 Mar 2023 19:33:46 GMT

Could you use the "show all other values" option?

Since you already specify symbols for all subtypes when there is not an insp_status, and want everything else to be the same symbol, then that should be "all other values" if I understand correctly.

Re: Symbolizing Unique values with wildcards

BrianBulla — Mon, 27 Mar 2023 19:53:49 GMT

All other values would work if I only had one type of INSP_STATUS, but I have 4 different values that INSP_STATUS could possible be.

So 5 types of subtypes and 4 types of INSP_STATUS. That's a total of 20 different combinations of symbols if I did it all manually, but there has got to be a better way of doing this.

Re: Symbolizing Unique values with wildcards

SLouq — Mon, 27 Mar 2023 20:09:57 GMT

try creating a style for your attributes, then base your symbology off that style

Re: Symbolizing Unique values with wildcards

LindaWilliams1 — Mon, 27 Mar 2023 22:23:30 GMT

Use Unique Values, set Field 1 as INSP_STATUS, and then create an expression to concatenate INSP_STATUS and Subtype. That will give you symbols for all possible combinations. For the combinations that have an INSP_STATUS, select them in the symbols list then right click any one of them and select Group values.

Re: Symbolizing Unique values with wildcards

JohannesLindner — Tue, 28 Mar 2023 09:51:17 GMT

You can use an Arcade expression as unique value field (click the expression button on the right of the field). Something like this should do what you want:

Re: Symbolizing Unique values with wildcards

BrianBulla — Tue, 28 Mar 2023 12:46:46 GMT

Thanks Johannes. Arcade to the rescue again! I will check this out and see if I can get it to work.

Re: Symbolizing Unique values with wildcards

BrianBulla — Tue, 28 Mar 2023 13:17:58 GMT

Here is the final product. It's working nicely!

// for features without INSP_STATUS, return the subtype if(IsEmpty($feature.INSP_STATUS)) { var subtypes = ["MaintenanceHole", "InspectionMH", "BackFlow", "DiversionMH", "FlapGateMH"] var i = $feature.SubtypeCD - 1 return subtypes[i] } // for features with INSP_STATUS = YES if ($feature.INSP_STATUS == "YES") { return "YES" }; // for features with INSP_STATUS = WR LOW if ($feature.INSP_STATUS == "LOW") { return "LOW" }; // for features with INSP_STATUS = WR HIGH if ($feature.INSP_STATUS == "HIGH") { return "HIGH" }; // for features with INSP_STATUS = CR if ($feature.INSP_STATUS == "CR") { return "CR" };

Re: Symbolizing Unique values with wildcards

BrianBulla — Tue, 28 Mar 2023 17:28:26 GMT

Hi @JohannesLindner . Sorry to bug you yet again, but after setting up this Arcade powered symbology and publishing this feature class as a hosted feature layer in our Enterprise ArcGIS Online account, a lot of the symbols are not actually showing. The ones with an INSP_STATUS do show up, but the ones with no INSP_STATUS are just not visible. They are there, as evidenced by the labelling, but you just can't see them.

Does ArcGIS Online/Portal not support Arcade expressions?? Even using the web layer directly in ArcGIS Pro, I see the same results.

Re: Symbolizing Unique values with wildcards

SLouq — Tue, 28 Mar 2023 17:53:17 GMT

Click Edit Layer Style and their should be a botton to toggle on off for Show features out of range or no values. Set it to on.

You may have to experiment with different styles before you see that option

Re: Symbolizing Unique values with wildcards

BrianBulla — Tue, 28 Mar 2023 17:57:30 GMT

That doesn't seem to be an option for me. Maybe because I'm using an Arcade expression for the symbology? And the features are there. You can see the labelling. They just aren't being symbolized.

Re: Symbolizing Unique values with wildcards

SLouq — Tue, 28 Mar 2023 18:06:10 GMT

The one I did I used the Counts and Amounts (color) style but I had created a style in ArcGIS Pro and then uploaded it to ArcGIS Online. Took a little experimenting and a few curse words but I figured it out.

Re: Symbolizing Unique values with wildcards

JohannesLindner — Tue, 28 Mar 2023 18:34:38 GMT

Hmmm... No idea why the symbology wouldn't translate to AGOL correctly. Try to change it in the MapViewer (just copy your expression) that worked for me.

Re: Symbolizing Unique values with wildcards

BrianBulla — Thu, 30 Mar 2023 17:49:17 GMT

Hi @JohannesLindner . So I think I see why my symbology in AGOL isn't working, but I can't really explain why. So, it looks like when I share my data as a weblayer out of ArcGIS Pro, the INSP_STATUS field on the data is getting upated. I do have Attribute Rules on the related table that has the inspections information. Do you think for some reason that is getting triggered when I share the data? Otherwise, I don't understand how that INSP_STATUS field is getting populated.

In my Attribute Rule, I have it set to update the INSP_STATUS in the parent records field whenever a new inspection record is created/updated. For some reason, I am seeing all records in the published hosted feature layer with that attribute populated.

Here is ArcGIS Pro:

And then the same feature in AGOL:

Re: Symbolizing Unique values with wildcards

BrianBulla — Thu, 30 Mar 2023 19:42:09 GMT

Ha ha!! Ok @JohannesLindner I finally got it working. Apparantly when you set a DEFAULT value on a field when you share that to AGOL, it automatically populates all the <Null> values with that default value....at least that seems to be what is happening....so NOT the Attribute rules.

Anyways, all is good now and the Arcade symbology is working ok.

Re: Symbolizing Unique values with wildcards

JohannesLindner — Thu, 30 Mar 2023 20:04:33 GMT

Apparantly when you set a DEFAULT value on a field when you share that to AGOL, it automatically populates all the <Null> values with that default value

Huh, good to know.

Glad you got it working, please mark the correct answer so this question is shown as solved.