Classifying numeric data that includes a "No Data" code:
If your data layer's legitimate values range from (for example) 0
to 100, but you have a set of "no data" records coded (for
example) -99, ArcMap will report the minimum data value as -99,
and will include those -99s in any calculations of means,
quantiles, etc. If you need to know what the true min/max/mean
values are, or you want to set symbol classes based on true
quantiles or some other statistical method, you must tell ArcMap
that a particular set of values in your data layer should be
excluded from the symbol classification:
- Under the "Symbology" tab in the layer properties, choose
- Click the "Exclusion..." button.
- Under the "Query" tab, find the field you are using for your
map and double-click it to add it to the "SELECT FROM" box.
- Click the "=" sign to add it to the "SELECT FROM" box.
- Now type
-99 after the equals sign in the
"SELECT FROM" box. Your expression should look something like:
Now click on the "Legend" tab.
Check the checkbox that says "Show symbol for excluded data"
Click on the colored box after the "Symbol" text to set how
you want your "no data" areas to display.
Type "No Data" (or similar) in the "Label" box.
Click OK to close out the "Exclusion" window.
Click OK again to close out the "Classification" window.
Click one last OK to close out the "Symbology" window. You
must close out all of these windows for the "no data"
exclusion to get absorbed into ArcMap's engines.
Now re-open the layer's symbology window ("Properties" ->
"Symbology" tab). Go back into the "Classify" window and note
the new (correct) range of values that excludes your "no data"
value. Also note the new "No Data" class in your layer's legend.
Symbolize your data as usual.
"cntrywch.POPDENS00" = -99
More info :
Classifying numerical fields for graduated symbology
back to ESM 263 home