Skip to main content
Solved

Build network graph from table with node's coordinates and start node/end node

A

Hello everybody,

I was wondering if FME can build a network starting from an xls file containing nodeID with its coordinates (x and y) in one sheet, and arcID with its start and end nodeIDs. Wich transformer should I use? (tried with topology builder but seems I'm missing something)

This is part of the node sheet:

2020-08-27 121702

 

and this is part of the link sheet:2020-08-27 122015

The final aim is to write an .shp file with the nodes and one with the links, and .dxf file with the entire network, but so far I managed to process the nodes only.

Any advice?

Best answer by bwn

Quickest workflow likely looks like this.

 

Note: VERY important to set the Attribute and Geometry Handling overrides on the two FeatureJoiners. The Geometry Handling Override on the first FeatureJoiner is what initialises the Edge Geometry to a Start Point, and the Attribute Handling Override on the second FeatureJoiner is what overrides the X, Y values with the End Node Coordinates to be consumed by the last VertexCreator

capture

 

View original
Did this help you find an answer to your question?

3 replies

david_r
Celebrity
  • david_rCelebrity
  • August 27, 2020

First, create the node point geometries (VertexCreator).

Then merge node point pairs (e.g. using two consecutive FeatureMergers) based on START_NODE and END_NODE and create the edge lines based on those point pairs (e.g. using a second VertexCreator in Add mode).

bwn
Evangelist
Forum|alt.badge.img+26
  • bwnEvangelist
  • Evangelist
  • Best Answer
  • August 27, 2020

Quickest workflow likely looks like this.

 

Note: VERY important to set the Attribute and Geometry Handling overrides on the two FeatureJoiners. The Geometry Handling Override on the first FeatureJoiner is what initialises the Edge Geometry to a Start Point, and the Attribute Handling Override on the second FeatureJoiner is what overrides the X, Y values with the End Node Coordinates to be consumed by the last VertexCreator

capture

 

A
  • arthur
  • Author
  • August 28, 2020

Thank you very much, I tried your solutions and worked perfectly both of them, hope that this solved question will be useful to other FME users too.

Reply


Helpful Members This Week

Community Stats

31,313
Posts
118,738
Replies
38,900
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.