Skip to main content
  • EN

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


Community Stats

30,162
Posts
114,483
Replies
37,809
Members
Terms & ConditionsCookie 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.