topic Re: How to symbolize null values as Unique Value? in ArcGIS Pro Questions

How to symbolize null values as Unique Value?

AdamBourque — Thu, 04 Apr 2019 19:48:11 GMT

I am trying to get all of my points with "Null" values in my "Address" field to appear a different color than the points that already have assigned addresses.

Right now I just selected all the null points and used the "Layer from Selection" then changed the color, but I want all the points to be on the same layer.

The only way I know how is if I used a graduated color symbology instead of unique values and set all the points with an address as 1, and without an address as 0 (which I don't even know would work or not).

Is there an easy way to categorize null values to illustrate a different color?

(USING ARCPRO)

Thanks!

Re: How to symbolize null values as Unique Value?

DanPatterson_Retired — Thu, 04 Apr 2019 21:00:39 GMT

an example. I kept <null> to show that they were all in the same class, the "all other values" category... I just edited that label to delete all text, but the color still remains.

Re: How to symbolize null values as Unique Value?

Robert_LeClair — Thu, 04 Apr 2019 21:45:43 GMT

I'm using AGP 2.3.2 and the feature class I'm symbolizing has "Test" and <NULL> values for attributes. I set my Primary Symbology as Unique Values, identified the field attribute for Field 1 and AGP created 3 symbols - one for <NULL>, one for Test and one for <all other values>. I can remove <all other values> by clicking the More dropdown on the Symbology Pane and uncheck <show all other values>.

Re: How to symbolize null values as Unique Value?

DanPatterson_Retired — Thu, 04 Apr 2019 22:25:14 GMT

As in my example, you can also change the label for all other values without getting rid of it

Re: How to symbolize null values as Unique Value?

AdamBourque — Fri, 05 Apr 2019 14:08:33 GMT

This is how I was approaching it, but the problem is for unique values I have a bunch of different values. I want all points to be the same color except the null.

Re: How to symbolize null values as Unique Value?

AdamBourque — Fri, 05 Apr 2019 15:40:37 GMT

What would be the easiest way to make another field with 0's for all the Null values and 1's for all the other addresses? I'm thinking I will just do graduated colors symbology instead

Re: How to symbolize null values as Unique Value?

DanPatterson_Retired — Fri, 05 Apr 2019 17:55:30 GMT

for the address field, simply do a query for <null> or not <null>. Then do a field calculator '!YourAddressField! being equal to 0 or 1 depending on what you queried on. When that is done, switch the selection, and repeat the calculation using using the opposite number

Re: How to symbolize null values as Unique Value?

AdamBourque — Fri, 05 Apr 2019 18:55:20 GMT

That sounds like a plan, I'm sorry I am new to GIS, could you tell my what that query would look like? Also how is the workflow accomplished?

As in do I go under symbology then hit expression builder?

Would the query be SELECT * FROM [CustomerMeter] WHERE [Address] IS NULL

Re: How to symbolize null values as Unique Value?

DanPatterson_Retired — Fri, 05 Apr 2019 20:58:19 GMT

Adam, I was talking about adding a field to your table to do this to create a classification field

Re: How to symbolize null values as Unique Value?

AdamBourque — Mon, 08 Apr 2019 12:10:39 GMT

Oh okay that's what I planned on doing! Thank you Dan. Last question, is there an easy way to add 0's and 1's to the field quickly for over 400 points within ArcGIS Pro? Otherwise, would I export the table into excel add them and then reimport it (just wanna make sure the spatial context/longtitude &latitude) are saved).

Thanks!

Re: How to symbolize null values as Unique Value?

DanPatterson_Retired — Mon, 08 Apr 2019 13:55:53 GMT

Select by Attribute... query the field for Null. Right-click on the new field name that you added, launch Calculate field and type in 0 for the value,

Back to the table and hit the switch selection button, back to the field calculator and now type in 1. Field calculations work only on the selected records