How do I relate 300 structures to a circuit quickly?

431
1
06-14-2018 07:01 AM
ChrisCosgrove
New Contributor

I have 300 plus structures that I would like to relate to a specific transmission circuit. I know I can go through and create a relationship on a one-by-one basis but this option takes forever.

Is there a way to select all the structures on the circuit using a polygon and relating all 300 plus structures to a circuit in one fell swoop?

Tags (2)
0 Kudos
1 Reply
deleted-user-qpvAI3Fo0MKR
Occasional Contributor III

Easy solution would be to implicitly associate the structures to the line using Select by Location. Create your relationship class using your primary (LineID on the Transmission Line feature class) and foreign key (LineID on the Structures feature class), then Select by Location from Structures that are within distance X from your transmission line. Field calculate the Transmission line's primary key into the foreign key attribute of your Structures, and then you should be set.

Of course you will always run the risk of associating the line to incorrect structures and vice versa if you have coincident lines, so YMMV.