SHP Query Builder Dialog Box

Use this dialog box to build a query.

Select All

Specifies that all data will be imported.

Set Operator

Specifies the set operator for an expression. Activate the cell and select AND or OR.

(

Specifies how many parentheses should be used. Activate the cell and click on the number of desired parentheses. Left and right parentheses should be the same number in order for the query to be analyzed.

Property

Specifies the property for the expression. Available properties are based on the SHP File attributes. The property may be typed in or selected from a list. The list is populated from the selected SHP file in the previous dialog box.

Operator

Defines the relationship between Property and Value. The operators displayed in the list depend on the property you specified for the expression. Valid values include:

• = (equal)
• ! = (not equal)
• > (greater than)
• < (less than)
• >= (greater than or equal)
• <= (less than or equal)
• LIKE
• IN
• NOT IN
• IS NULL
• IS NOT NULL

Value

Specifies the value for the property. Activate the cell and enter the value. Valid values depend on the property. Text values must be enclosed in single quotes. Possible values are populated from the selected SHP file in the previous dialog box.

)

Specifies how many parentheses should be used. Activate the cell and click on the number of desired parentheses. Left and right parentheses should be the same number in order for the query to be analyzed.

Query String

Displays the entered query string. The query string may also be typed in.