AccuGlobe Desktop 2007 Digital Data Technologies, Inc.

Searching By Attributes

AccuGlobe supports selection of features dependent on attribute criteria. Creating, adding and removing from a selection is covered in this section.

Steps To Select Features By Attributes

  1. Click on the layer in the legend associated with the features to be selected.
  2. Click the Select By Attributes button Select by attributes button on the SelectionTools toolbar. Alternatively, press F10.
  3. The Select By Attributes dialog will be displayed.
OR
  1. Right click over the layer in the legend associated with the features to be selected.
  2. Click on Select By Attributes.
OR
  1. Right-click over the layer in the legend associated with the features to be selected.
  2. Click on Open Attribute Table.
  3. Click on Tools.
  4. Click on Selection
  5. Click on Select By Attributes.


Type Of Selection

AccuGlobe permits several actions when selecting by attributes. These are listed below:

Using Filters

One or more filters are required to produce a selection. Each filter will act on a single attribute field in the layers data. For example, we may want to select all the "MAIN ST" records in a road centerline file. To do this you would create a filter that would search the field that contains the street name for the value "MAIN ST".

Steps For Adding A Filter

  1. Click on the Add button Filter Add button
  2. The New Filter dialog will display.
  3. Select the field the filter will be applied to. See the Fields section below for more details.
  4. Optionally, to see all the possible values for the choosen field, click the View checkbox.
  5. Select the logical operator. This indicates how this filter will interact with other filters. See the Logical Operators section below for more details.
  6. Select the predicate. This indicates the relationship between the field and value that will be used to determine the selection. See the Predicate section below for more details.
  7. Optionally check the Not checkbox. This will invert the predicate. For example, if the predicate is set to equals (=), checking the not will make it 'not equal', or (!=).
  8. Type in the criteria. See the Criteria section below for more details.
  9. Click the Add button to add the filter.
  10. Optionally add more filters.


Fields

AccuGlobe lists all available fields that can be used for the selection purposes. Select the field that the search is to be compared against.

Logical Operators

Logical operators define the relationship between filters. For example, if we had two filters, with the first being STREETNAME = "MAIN ST" and the second being STREETNAME = "HIGH ST" and a logical operator of Or on the second filter (the logical operator of the first filter is ignored), the query would select all records where the STREETNAME field was either "MAIN ST" or "HIGH ST". In this example, if the logical operator was changed to And, no features would be selected as it is impossible for the same field to be both "MAIN ST" and "HIGH ST" for a given record. The following logical operators are available in AccuGlobe.

Predicates

The following predicate operators are available in AccuGlobe:

Criteria

This is the discrete value that the field will be compared against. For value ranges please use multiple filters to create the desired effect.

Please note that it is possible to define a data field as a criteria.

Filters

AccuGlobe lists all the current filters to be used for the selection set. It is possible to add new, edit existing and remove unneeded filters using the corresponding buttons.

Steps For Executing The Query

Once all of the filters have been defined the query needs to be executed.
  1. Click on the Execute button.
  2. After the selection query completes, a label in the bottom left corner of the dialog will indicate how many features matched the selection filters.
  3. Optionally zoom to the selected features by clicking the Zoom To Selected button.
  4. Optionally save the filters for later use by clicking the Save button. This is useful when you use a complex query over and over again. Saved filters can be loaded by clicking the Load button.
A screenshot of the select by attributes dialog is shown below:

Select by attributes dialog