Select to view content in your preferred language

How to symbolize null values as Unique Value?

6338
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

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 

0 Kudos