Select to view content in your preferred language

How to symbolize null values as Unique Value?

6117
10
04-04-2019 12:48 PM
AdamBourque
Regular Contributor

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! 

Tags (1)
0 Kudos
10 Replies
DanPatterson_Retired
MVP Emeritus

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.

Robert_LeClair
Esri Esteemed Contributor

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

DanPatterson_Retired
MVP Emeritus

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

0 Kudos
AdamBourque
Regular Contributor

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. 

0 Kudos
AdamBourque
Regular Contributor

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 

0 Kudos
DanPatterson_Retired
MVP Emeritus

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

AdamBourque
Regular Contributor

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 

0 Kudos
DanPatterson_Retired
MVP Emeritus

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

0 Kudos
AdamBourque
Regular Contributor

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! 

0 Kudos