Selecting records in a table by attributes

There are various ways to select features in ArcMap. One way is to select features through an attribute table. From a table, you can interactively select records by pointing at them, or you can select those records that meet some criteria; for example, find all cities with a population greater than one million.

To select records using an attribute query, follow these steps:

Steps:
  1. Click Table Options Table Options in the table you want to query and click Select By Attributes Select By Attributes.
  2. Click the Method arrow and click the selection procedure you want to use.
  3. Double-click the field from which you want to select.
  4. Click the logical operator you want to use.
  5. Click the Get Unique Values button, then scroll to and double-click the value you want from the Unique Values list.

    Optionally, you can type a value directly into the text box.

  6. Click Verify to verify your selection.
  7. Click Apply to update the selection.
  8. Click Close.
TipTip:
You can use a SQL WHERE clause on the Select By Attributes dialog box.
TipTip:
Use Apply if you intend to run more than one query or if you want to check your results before closing the Select By Attributes dialog box.
TipTip:
You can save and reload selection expressions using the Save and Load buttons at the bottom of the Select By Attributes dialog box. This lets you quickly re-create a selected set of records by loading a saved expression.
TipTip:
Click Help on the Select By Attributes dialog box to learn about building a query.

Related Topics

3/18/2014