Table of contentsNo headers
You can use expressions to evaluate properties. Here are some examples:
- Find all features in a feature class that have a property equal to, greater than, or less than a particular value. For example, find all buildings with a creation date value greater than January 1, 2000.
- Select all the features in a feature class with a property that matches a pattern you specify. For example, select all roads whose names begin with “Mt.”
- Create a table entry for a feature class with the value of a particular property, rounded in a particular way. For example, display building area, rounded up to the nearest whole number.
You can enter property names directly into an expression, or you can select them from the list.
If you enter a property name that is not in the list, the operation may issue a warning. However, if that property exists in your data store, the expression may still be valid when it is run.
You can also view and insert the valid values for any listed property.
The syntax for an expression that evaluates a property is slightly different, depending on whether you use an operator, a function, or an option. For an operator, the basic syntax is PROPERTY Operator Value. For functions and options, the basic syntax is Function (PROPERTY).
To evaluate properties in an expression using an operator
- Select the command for which you want to create an expression.
- In the expression area, do one of the following:
- Enter a property name manually.
- Click . In the list, select a property.
- Enter an operator using one of these methods:
- Enter an operator manually.
- Click an operator button.
Use the Operator buttons.
- Select an operator from a menu.
You can use the following types of operators:
- Math Operators
For example, this expression could be used to determine the total amount spent on parts and labor for a pipe repair project:
PIPE_PARTS_COST + PIPE_LABOR_COST
- Comparison Operators
For example, to find buildings whose assessed value is $100,000 or more, use this expression:
VALUE >= 100000
- Logical Operators
For example, to find only buildings that have a value for the TERMINATION_DATE property, use this expression:
NOT TERMINATION_DATE NULL
- Select or type the value to evaluate.
- To create a complex property evaluation, insert an AND or OR operator, and then insert another property, operator, and value combination.
Precede every operator with a property. For example, to find buildings whose creation date is after 1990 and before 2005, the expression must look like this one:
CREATION_DATE > 1990 AND CREATION_DATE < 2005
- Click to apply the expression.
To evaluate properties in an expression using a function or option