topic Extract attributes from related features in Data Management Questions

Extract attributes from related features

TimMarquardt1 — Fri, 03 Jun 2016 22:24:36 GMT

Geo-Friends:

Is there a way to extract attributes from features that are related to other features?

My Example: I want to select a set of utility poles and a few attributes from a related streetlight feature class. The streetlights are related via a 1:M relationship class. I would like to append the selected poles to another feature class and also a few attributes from the related streetlight features (Light_type, Wattage, etc).

Can this be done? I thought of a join, but when I try this, the defined relationship class for Pole_Streetlight is not in the dropdown for "Join data based on a pre-defined relationship class" why is this?? Any help is appreciated.

Thanks!!

Re: Extract attributes from related features

DanPatterson_Retired — Fri, 03 Jun 2016 22:31:55 GMT

Tim, have you gone through the help file topics? Accessing related records—Help | ArcGIS for Desktop

Add Join—Help | ArcGIS for Desktop or looked at relationship classes instead

Re: Extract attributes from related features

WesMiller — Sun, 05 Jun 2016 22:02:44 GMT

Is the data stored in an enterprise geodatabase? Make Query Layer—Help | ArcGIS for Desktop

Re: Extract attributes from related features

TimMarquardt1 — Mon, 06 Jun 2016 15:52:26 GMT

I don't understand why you can't join to another feature class that is related via a relationship class? The relationship class is there. I can select a feature and use the Related Tables button from the attribute table and it selects the related feature. So why is the related feature class not presented as a choice when you use the Join command and pick "Join data based on a pre-defined relationship class"? what am I missing?

Re: Extract attributes from related features

WesMiller — Mon, 06 Jun 2016 16:31:17 GMT

You would not be able to do a straight join because you have a 1-M relationship it would only get a single record. If you are in an enterprise geodatabase you could use the tool i mentioned earlier.

Re: Extract attributes from related features

TimMarquardt1 — Tue, 07 Jun 2016 18:56:17 GMT

Hi Wes. Thank you for the reply.

I looked at the tool help for make query layer. I don't see how the use of the tool accomplishes a join of 2 feature classes via a relationship class.

Re: Extract attributes from related features

TimMarquardt1 — Tue, 07 Jun 2016 20:50:19 GMT

I found the problem. I am dealing with attributed relationship classes (not standard 1:M) which creates the RID field and relationship class table. Thanks for the help