Ask A Cartographer

Symbolizing on Conditional Statements

March 30 2010 | 1 comment
Categories: Map Data, Symbology

Is there a way to symbolize data based on conditional statements without creating an additional field? We have a layer of land management zones which contains fields for documenting the the minimum and maximum desired burn intervals for prescribed burning as well as the date the last burned. We'd like to be able to symbolize the zones as being "OVER", "UNDER", or "WITHIN" their desired burn interval. For the time being we've simply added an additional "STATUS" field but I wondered whether their was a way to symbolize on a conditional if, then-type statement so that overtime, the symbols would update on the fly without having to be recalculate a "STATUS" field.

Mapping Center Answer:

You can use a subquery within a SQL statement. A subquery is a query nested within another query. It can be used to apply predicate or aggregate functions or to compare data with values stored in another table. To learn more, check out the SQL reference for query expressions used in ArcGIS in the online help.

Conditional Symbology posted by Roy Hewitt on Mar 30 2012 8:21AM
I understand nested queries, but how are they applied to a single field to achieve conditional symbology??

SQL statements don't seem to be a method in determining the symbology in a features properties (unless I'm missing something?)

If you would like to post a comment, please login.

Contact Us | Legal | Privacy |