[GIS] Querying Data with a 1-Many Relationship Class

arcgis-10.0queryrelationship-classselect-by-attribute

I have created a relationship class similar to the one I posted about in this question.

Essentially, there is a point feature class representing a location of vegetation clearing with attributes about the point (size of clearance, property ID, etc). There is also a table with information about different vegetation species that were cleared at that point and attributes about the vegetation (how much of each species was cleared, count of species, etc). The two are linked together with a 1-Many relationship class based on a unique ID which I created.

I can successfully click on a point and see the information about the point as well as all the species that were cleared at that point using the information tool.

However, I would like to query the points based on attributes in the plant species table. For example, "select all points which contain a particular species". But, the Select By Attributes tool doesn't let me see fields in the table. Just the fields in the point feature class.

How can I do this? Is this a limitation of relationship classes? Do I need to query the data some other way?

Thanks for any help.

Best Answer

This works for a "relate" (definded in an MXD). I'm not sure if it works for a "relationship class". Please try.

If you work with a relate you make a selection in table A and transfer this selection to tabe B (this works in both directions of a relate):

  1. Make a selection in the "vegetation table".
  2. Open the attribute table of "vegetation table"
  3. Click the Related Tables button
  4. In the "point table" you see now all points selected which contain a particular species
Related Question