Query Indexed Table
Overview
Once you have created an indexed data set, the Query Indexed Table tool lets you quickly count and extract records meeting your criteria. If the data set includes a spatial index, you can perform circle queries. If it also includes a polygon subsystem, both circle and polygon queries are enabled.
Queries can be based on:
Field values compared to constant values
Field values belonging to a set of constants
Spatial coordinates within a circle
Spatial coordinates within a polygon
Field values joined to an input value set
Spatial coordinates joined to an input value set
Any AND and OR combinations of the above
Queries can be arbitrarily complex; there is no limit on the number of query terms (other than system resources). You can index up to two billion records in a single data set.
Query Indexed Table tool configuration parameters
The Query Indexed Table tool has a single set of configuration parameters in addition to the standard execution options.
Parameter | Description |
|---|---|
Index directory | Directory containing index files to query. |
Query | Query string defining which records to extract. |
Get result count | If selected, instantly returns a count of records matching the query. |
Output count only | If selected, outputs a count of records matching the query. |
Configure the Query Indexed Table tool
Select the Query Indexed Table tool.
Go to the Configuration tab on the Properties pane.
Select the button and then browse to the directory containing the indexed table you want to query.
Enter your query into the Query box.
Optionally, select Get Result Count to instantly return a count of records matching your query. The count is displayed on the Query Indexed Table dialog box.
Optionally, check Output count only to output a count of records matching your query. A single number will be output. If this box is cleared, all records matching the query will be output.
If the tool is configured for dynamic key query with multiple inputs, you may optionally select the Connection Order tab andadjust the order of input connections.
Optionally, go to the Execution tab, and then set Web service options.
You can interactively count the number of records that will be returned by a query without actually running the query. Simply configure the query in the usual manner, and then select Count. The count will be displayed next to the Count button. If the number –1 appears, there is an error in the query. To view the errors, select OK to dismiss the configuration dialog, then open it again. The errors will be displayed on the Errors tab.
You must connect the output of the Query Indexed Table tool to another tool, such as a Data Viewer, before performing interactive counts.