Hi All,
This question stems from my previous question. I am choosing to ask another question as not to clutter that.
I have a network of Customer Points (CPs) and Transformers (TXs) connected via secondary electrical cables (both underground and overhead). I would like to find which CP is connected to which TX. Multiple CP's can be connected to a TX. I would like to export a table like the following:
CP TX
1 1
2 1
3 1
4 2
4 2
My Approach: Thanks to @david_r
1) Topology Builder Transformer used to determine topological relationships within the line network (secondary underground cable and secondary overhead conductor)
2) Network Topology Calculator to find connecting lines and add Network_ID to line
3) Aggregate lines grouped by Network_ID
4) Using SpatialFilter, find TX’s and CP’s that intersect with the same network and transfer TX id to CP as an attribute to generate csv (Using Feature Merger)
Works great for isolated networks (Secondary Underground networks) shown in the image
Problem: When the network of underground and overhead cables is input to topology builder, it is broken down based on any intersection. There are segments that require the intersection between underground and overhead cables to connect CPs to TXs. The image below (2) shows two network clusters both services by different transformers. If only the overhead or underground cables were input, some CP’s would lose connectivity to their upstream TX. So, the previous method works for these ones as well and it is important to input both types of cable lines together.
But for network segments that criss-cross but are not part of each other… that’s where the problem starts. Shown in the image below (3):
Here, the red lines correspond to a network segment of underground cables that connect 7 CP’s to 1 TX. The black lines correspond to a segment of overhead cables connecting 8 CP’s to another TX. TopologyBuilder is breaking every bit of line that intersects and when Aggregate is used, it aggregates this whole thing as one network segment.
MY QUESTION: Is there ANY WAY to separate underground lines that only cross overhead lines but does not snap on? How would I go about changing the workflow to include that exception? Any ideas would be greatly appreciated. Thanks so much!
The Workbench is attached