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.
If you would like to post a comment, please login.
SQL statements don't seem to be a method in determining the symbology in a features properties (unless I'm missing something?)