Skip to main content

Hello,

I have consecutive Oracle LRS geometric segments in several locations that I would like to concatenate (see attached or the description below).

 

First LRS Geometric Segment : from distance a1 to distance b1
 
Second LRS geometric Segement: from distance a2 to distance b2 with a2=b1
 
Third LRS geometric segment: from distance a3 to distance b3 with a3 = b2
 
.
.
.
Nth LRS geometric segment from distance an to bn with an= bn-1

 

I'm able to write a query to merge all the N geometric segments and to compute the distance from (a1) and the distance to (bn).

 

How can I create the corresponding LRS geometry which will be the concatenation of all the touching geometry segments in the right order? 

Any suggestion?

@Takashi Iijima​, @jdh​, @david_r​  and others?


I would probably just use a LineCombiner followed by a MeasureGenerator to get a clean set of measures.

 

If that is not desirable you would need to create a list of all the (new) measure values for each line and use a MeasureSetter in mode Whole Line.


Reply