Create a Query

The Create Query option allows tabular queries on the attribute data from any of the currently displayed layers.

To create a query, follow the steps given below:

  1. Open the Spectrum Spatial Analyst application.
  2. Click or Touch the right side menu to open the Legend panel.
  3. Click or Touch the Create icon to open the menu options.
  4. Click or Touch the Create Query icon to a build query.
  5. In the Query In drop-down list, select the geographic area to be queried. You can choose to see entire map region data or data within the visible map region or choose one of the annotations you have drawn to search for data that is inside or touches it.
    Note: You can select multiple options for query.
  6. In the From drop-down list, select the name of the map layer you wish to search.
  7. In the Filter drop-down list, select one of the following:
    • No Filter- No criteria is selected.
    • Custom Filter- Displays Filter Criteria dialog box and allows you to customize your search. Once selected, the Filter Criteria section is displayed.
      Table 1. Custom Filter Criteria Options
      Options Description
      Column Select the column that is to be queried.
      Operator Select the search operator from the drop-down list. It provides following search operators.
      = This function only retrieves records that exactly match the text or value entered in the criteria text box.
      <> This function looks for all values that are different from the value entered in the criteria text box.
      < This function looks for all values lower than the value entered in the criteria text box.
      > This function look for all values higher than the value entered in the criteria text box.
      >= This function looks for all values higher than or at the same level as the value entered in the criteria text box.
      <= This function looks for all values lower than or at the same level as the value entered in the criteria text box.
      Like It looks for records in the chosen field that contain the criteria entered in any way.
      Value Enter the value to be matched with operator.
      Note: If there are less than 50 records associated with selected column then criteria is shown as drop down list with multiselect option and if records are more than 50 then criteria is shown as text box.
      Add more conditions Click or Tap to add more search criteria. You can add up to 5 search criteria.

      Note: Click or Tap on the icon to remove the search criteria.
    • Others- The query filter created from Admin Console.
    Note: Some layers will have a list of criteria you can choose. If criteria exist you will be presented with additional text boxes or pick lists to further refine the results you return.
  8. Click or Touch the Create button on the top to create the query.
    The Name of the Query Layer text box appears.
  9. Enter a name in the Name of the Query Layer text box.
  10. Click or Touch Apply to see query results on the map. You may tap or click anywhere on the query results on the map to see callout information. For more information, refer to Map Information Callout.
    The Query results are listed on the left hand side. For more information, refer to Query Results View.

    The query result name is also listed on the Map Legend.