Skip to main content
Skip table of contents

Query Indexed Table

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:

Index directory

Directory containing index files to 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

  1. Select the Query Indexed Table tool, and then go to the Configuration tab on the Properties pane.

  2. Select the  button  and then browse to the directory containing the indexed table you want to query.

  3. Enter your query into the Query box.

  4. 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.

  5. 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.

  6. 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.

  7. 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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.