Building a Query

This chapter provides help to create a query in Spectrum Spatial Analyst application.

The query builder allows you to search for information on individual map layers shown on the map. Results are displayed as an interactive table. Tapping a result on the table will zoom to and highlight that feature on the map. You can search and display all of the data for a layer, constrain your search to within the current map view, or search for information which is inside the shapes that you draw on the map as annotations. For some layers the Spectrum Spatial Analyst Administrators will have set up additional criteria that you can choose to further filter the results you get (for example, to return results within a date range or results which meet some other value).

A query can be set up to perform a more detailed search on a map.

Adding Predefined filter criteria

You can create a View table with parameters from Spatial Manager and associate it to a map layer from the Project Settings dialog. When you create a query, the associated view table with be listed under the Filter drop-down list against the corresponding layer.

The parametrized view table will be listed under Search, if Quick search is enabled in the corresponding functionality profile.

View table with parameters

If IN operator is used in MISQL while creating Parametrized view table in Spatial Manager then the criteria is displayed in drop-down list as picklist. For all other parametrized view a text box is displayed as User input in Spectrum Spatial Analyst.
Note: For getting picklist options parameter name has to match the column name.