Query On the Vector Layer

Once you add a vector layer to your map project, you can perform query on the vector layer. Spectrum Spatial Analyst allows you to perform query using SQL-like expressions on a vector layer. You can use the following numeric operators in your expression.

  1. Click or touch the Add icon on the upper right corner of the map.
  2. Click or touch the Query icon to open the New Query page.
  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 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 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. Click the Add another condition button to add more conditions.