Skip to main content

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?

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).


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

 


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