Finding and Filtering Data in the Data Table
Concept Procedure Quick Reference

To find a subset of data in the Data Table

  1. In Display Manager, select the feature layer to search.

    For information about creating a new feature layer, see Bringing in GIS Features.

  2. Click .
  3. In the Data Table, change the data source in the Data list if necessary.
  4. For Filter By, select the column to search, for example, City or Owner Name.
  5. The label changes to show your column selection.
  6. In the Filter By box, enter the value to look for.

    For example, to find all parcels in the city of Bonn, enter BONN. The string you enter must exactly match the data in the column to be included in the results.

  7. To zoom to the features in your map, click Auto-Zoom.
  8. Click Apply Filter.
  9. The features or records that match your criteria are displayed in the Data Table.
  10. Select a row in the Data Table to see that feature highlighted in your map. If Auto-Zoom is on, you will zoom to the selected features.

To clear the filter and display all records

  1. In the Data Table, click Clear Filter , or create a different filter.

To search to select data

  1. Select the layer in Display Manager that contains the feature class data you want to view.
  2. Click on the toolstrip to open the Data Table window.
  3. Click Search To Select on the lower bar of the Data Table.
  4. Create an expression for your search. You can create the following types of expressions:
    • Property Evaluation expressions compare the value of a property to a value you specify. For example, you can find parcels with an area greater than a value you specify, or streets with a particular number of lanes.
    • Location Conditions find data based on its location in the map. For example, you can draw a circle to find all parcels within that circle.

    You can save your expression for reuse.

  5. To create a complex property evaluation, insert an AND or OR operator, and then insert another property, operator, and value combination.

    Every operator must be preceded by a property. For example, to find parcels whose last purchase date is after 1990 and before 2005, the expression must look like this:

    Purchase_Date > 1990 AND Purchase_Date < 2005

  6. Validate your expression.
  7. To reuse your expression in the future, from the Options list in the Search To Select dialog box, select Save Expression.
  8. When the expression is complete and valid, click OK.

    When AutoCAD Map 3D has completed the search, it highlights both the selected rows in the Data Table and the associated features on your map.