Creating Spatial Feature Classes Based on Proximity, Overlay, and Attributes - Introducing Geographic Information Systems with ArcGIS - page 424

FIGURE 7-16 Query builder
Put it into the Trivial_Feature_Classes folder. The feature class to be produced will contain the
polygons with the attribute value TOP plus those with the attribute value LEFT.
18. Press the SQL button to develop the SQL Expression in a Query Builder window. Build the
Query:
[LOCATION] = 'LEFT' OR [PLACEMENT] = 'TOP'
Once the expression is built (see Figure 7-16), Verify it and press OK to return to the Select window, where
your expression will be in place. Press OK. When the computation stops the new feature class will appear
in the T/C.
19. Verify that the feature class
ALL_TOP_POLYS_plus_ALL_LEFT_POLYS
is added to the map. Make the layer color light blue. Turn off any other layers on the map. Verify
that those polygons that were LEFT and those polygons that were TOP are both represented. In
the Layer Properties window of
ALL_TOP_POLYS_plus_ALL_LEFT_POLYS,
check the box to label features and make the Label Field LOCATION. Click Apply, then OK.
Observe. Change the Label Field to PLACEMENT. Observe. Turn off
ALL_TOP_POLYS_plus_ALL_LEFT_POLYS.
Recognize that you have created a new feature class by selecting polygons from the Union of
two other feature classes.