Comparison operators are available from the Operator menu. They modify a property value. Make sure that every instance of a comparison operator is preceded by a property and followed by a value. For example, if you create an expression to find every building whose street number is greater than 100 but less than 200, your expression would be:
Building_Street_Address > 100 AND Building_Street_Address < 200
In the example, the property Building_Street_Address is inserted twice. A single instance of Building_Street_Address does not work.
Numeric properties are evaluated arithmetically. Date properties are evaluated chronologically. Text properties are evaluated alphabetically. For example, Building_Area < 20000 will find buildings whose area is less than 20,000 square feet. Purchase_Date > 01/01/2001 will find buildings purchased after the beginning of 2001. Street_Address < “Mt. Whitney” will find buildings whose street address comes before Mt. Whitney alphabetically.
When you create an expression for geospatial features, you can use the following comparison operators:
Operator | Definition | Syntax |
---|---|---|
= |
Equals |
Property = Value Value = Property |
> |
Is greater than |
Property > Value Value > Property |
< |
Is less than |
Property < Value Value < Property |
< = |
Is less than or equal to |
Property <= Value Value <= Property |
> = |
Is greater than or equal to |
Property >= Value Value >= Property |
< > |
Is not equal to |
Property <> Value Value <> Property |