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!
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.
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>.
As in my example, you can also change the label for all other values without getting rid of it
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.
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
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
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
Adam, I was talking about adding a field to your table to do this to create a classification field
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!