+12I have a spreadsheet that has 50 rows of data including Lat/Longs. Each row is considered a pipeline segment. I would like to create a segmented line. I found a post that recommended NeighborFinder, ListExploder and VertexCreator to accomplish this. My line comes out with gaps. I have tried all options I can think of for the LineBuilder, but I only get one line or it still outputs points.
Output:
What am I missing?
Best answer by geomancer
FME can add those extra attributes for you, using ‘Adjacent Feature Attributes'.
(Edit: added workspace)
+23Hi
Thanks,
Dan
+12
+64Assuming the points are in the correct order: Use a VertexCreator, followed by a LineBuilder.
+12
+12I see my NeighborFinder is not producing the results needed to create that 2nd point. I can make it work if I edit the xls to add a ToLatitude and ToLongitude fields. I then set my VertexCreator2 to that new field. I am hoping to limit the amount of editing that needs to be done to the xls.
+64FME can add those extra attributes for you, using ‘Adjacent Feature Attributes'.
(Edit: added workspace)
The gaps usually happen when your matching logic with NeighborFinder isn’t pairing the end of one segment to the start of the next perfectly. Instead of VertexCreator twice, try sorting all your lat/long points by your pipeline sequence ID first with a Sorter transformer, then feed the ordered points straight into LineBuilder set to build lines per segment ID. That skips the neighbor matching list workflow that’s causing broken gaps for your data.
