Create a Query

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

Note: When making queries in Spectrum Spatial Analyst there is a HTTP POST limit of 2 MB (2097152 Bytes). If a query is referencing a very complicated annotation geometry, typically over 50,000 points, it can exceed the limit in which case the query will fail with error.

To create a query, follow the steps given below:

  1. Click or touch the Add icon on the upper right corner of the map to open the Add panel.
  2. Click or touch the Create Query icon to a build query.
  3. In the From drop-down list, select the name of the map layer you wish to search.
  4. 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.
  5. 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 multi-select 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 is created from Project Home.
    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.
  6. Select the color from Color picker to show query in that color on the map. You can also change color later from Map Legend panel. For more information, refer to Styling Query.
  7. Enter a name in the Name of the Query Layer text box if you want to change the default name.
  8. Click or touch Create button to see query results on the map. When you zoom out on the map a message Layer not visible at this zoom level may appear. This is because the zoom constraint settings was applied on the original layer on which query has been created.
    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 panel.

    Note: 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.
    Note: There is a HTTP POST limit of 2 Mb (2097152 Bytes) applied on a query. If a query is referencing a very complicated annotation geometry, typically over 50,000 points, it can exceed the limit in which case the query will fail with error.
  9. Save the map project. For example, click the Overflow icon next to the Map Layers and click Save project. When you save the project, the map project is saved alongwith any zoom constraint settings applied on the original layer.
    Note: If you do not save the changes in your Map Project, the changes will be lost on reloading the project or refreshing the browser.