nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to symbolize null values as Unique Value?

AdamBourque

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!

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

DanPatterson_Retired

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

AdamBourque

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

DanPatterson_Retired

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

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

AdamBourque

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.

DanPatterson_Retired

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

Robert LeClair

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

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.

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.