About Expressions

Filter data for a data source during and after import using the conditions that you define. Combine properties in the original data store to map to properties in the model, and format entries for the Data Table with Source Filter.

Draw a geospatial area on your model to be used in an expression.

Create and work with a subset of a feature class.

Find and select only features in your model that meet a set of spatial conditions you define.

Find and select only features in your model that meet a set of property conditions you define. For example, to select all features that specify a positive elevation offset, use the expression: ELEVATION_OFFSET > 0.

Convert data values from one data type to another and then evaluate the result of the conversion. Convert numeric or text strings to a particular numeric or text format. Change the format or type of a string property. For example, if a data store keeps date values as text, you can convert these values to date strings. Then you can use Date Functions on the date strings. You can also convert a text string to a date format and add days or months to the resulting date.

Calculate a new value based on existing values. For example, calculate the area of a polygon or the length of a linear feature, round a value up or down, find the square root of a value, use trigonometric functions, or determine the remainder of a number after it is divided by another number. Find the average, mean, or median of a set of values.

View, filter or select data based on the value of one or more properties.

• A simple expression evaluates a single property. For example, to specify roads whose NAME property is “Elm,” use the expression: NAME = 'ELM St'.
• Complex expressions use multiple properties or multiple values. For example, to specify buildings with a roof height over 18 but under 32, use the expression: ROOF_HEIGHT > 18 AND ROOF_HEIGHT < 32.

All style rules apply visual styles to a feature based on an expression. For example, create a style for trees that maps the species (NAME property) to a visual tree style.

With text expressions, you can analyze and manipulate text strings. For example, use a text expression to replace one set of characters with another. Complex text expressions can also concatenate (combine) multiple properties into a single entry. For example, create an entry for theFull_Name property with the expression: "Concat (First_Name, ' ', Last_Name)".

Numeric expressions operate only on numeric values. They use math functions, with which you can analyze and manipulate numeric strings. For example, round off repair costs to the next highest dollar with the expression: Ceil (REPAIR_COST).