Skip to main content
Solved

Conditional querry on an electric network

gennine
Contributor
Forum|alt.badge.img+4

I'm working with an electrical network with feeders and branches. I'd like to add the coordinates of the intersection points with the feeders as attributes in the branches. I managed to do this in the first segment using the Intersector and SpatialFilter transformers, but I had trouble adding them to the downstream segments.
I have a common field for each branch that can be obtained using networkTopology.
So, my question is how to create conditional queries to add the coordinate values ​​of the intersection points with the downstream branches (see attached diagram).

Thanks in advance.

 

Best answer by takashi

Hi ​@gennine ,

I think you can use NetworkTopologyCalculator to add network ID different for each connected network to the feeders (blue lines in your screenshot), and then merge the intersect coordinates to every feeder using the network ID as join key. For example, add P1 (x1, y1) to every feeder with network ID = 1, add P2 (x2, y2) to every feeder with ID = 2, etc.

View original
danilo_fme
mhab
2 people upvoted this
  • danilo_fme
    danilo_fme
  • mhab
    mhab
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

6 replies

crutledge
Influencer
Forum|alt.badge.img+33
  • crutledgeInfluencer
  • Influencer
  • May 17, 2025

Hi ​@gennine I wonder if you were to generate the start and endpoints of the lines. You can then use the end points to pass attributes. 
Problem to extract coordinate of start and end point of line | Community

Hope that helps.

At your rest service ^B
gennine
Contributor
Forum|alt.badge.img+4
  • gennineContributor
  • Author
  • Contributor
  • May 17, 2025

Thank you ​@crutledge for your quick response.
I've already extracted the start and end of each segment (vertexCreator), but I'm having trouble passing attributes while looping through downstream branches.
Could you explain this process better?

crutledge
1 person upvoted this
  • crutledge
    crutledge
crutledge
Influencer
Forum|alt.badge.img+33
  • crutledgeInfluencer
  • Influencer
  • May 17, 2025

Ah. Understood (I think 😀) So, you were successful in getting the x,y from red lines to the FIRST blue line (downstream), Next step would be to put a tester for x,y is not null for the blue lines and spatial join those (passed the tester) to the rest of the blue lines (failed the tester). So you are “walking” the attributes down the lines. repeat as necessary. Did I understand that correctly?
Hope that helps.
 

 

At your rest service ^B
gennine
Contributor
Forum|alt.badge.img+4
  • gennineContributor
  • Author
  • Contributor
  • May 17, 2025

The number of downstream branches is large and unknown in advance. Therefore, it is impossible to install multiple testers. It is therefore necessary to automate the process (see attached diagram).

How to configure this?

 

takashi
Influencer
  • takashiInfluencer
  • Best Answer
  • May 18, 2025

Hi ​@gennine ,

I think you can use NetworkTopologyCalculator to add network ID different for each connected network to the feeders (blue lines in your screenshot), and then merge the intersect coordinates to every feeder using the network ID as join key. For example, add P1 (x1, y1) to every feeder with network ID = 1, add P2 (x2, y2) to every feeder with ID = 2, etc.

crutledge
raghavendrans
2 people upvoted this
  • crutledge
    crutledge
  • raghavendrans
    raghavendrans
gennine
Contributor
Forum|alt.badge.img+4
  • gennineContributor
  • Author
  • Contributor
  • May 18, 2025

 Many thanks ​@takashi, it works perfectly and avoid looping.

Helpful Members This Week

Community Stats

31,355
Posts
118,938
Replies
38,972
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.