I have a layer, with two columns called NAME and TYPE. A polygon in the layer has only one NAME, but can contain multiple TYPE of vegetation. I want to select different Types of vegetation, where the name is the same.


enter image description here

I want to select all the polygons that contain Evergreen AND Dipterocarp.

From the pic the polygon named Doi chiang dao should be selected.

I have tried using the "Select Layer by Attribute" in ArcMap, but I cannot figure out how to create an SQL statement that can do the above-mentioned operation.

1 Answer 1


I'm sure there is a shorter method, but here is what I would do:
1. "Select by Attributes" to select TYPE = Evergreen OR TYPE = Dipterocarp.
2. Open up attribute table to the newly selected features and right click NAME and summarize over the name. This will create a new table for you that count up how many times NAME occurs in your selection.
Each column with NAME_cnt = 2 will be polygons with both Evergreen and Dipterocarp as TYPES.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.