[postgis-users] LinearReferencing: measure vertex of linestring?

[Stephen Woodbridge]

On 3/28/2012 1:26 PM, Andrés Maneiro wrote:
> On 28/03/12 18:26, Sandro Santilli wrote:
>> On Wed, Mar 28, 2012 at 06:22:28PM +0200, Andrés Maneiro wrote:
>>
>>> LINESTRINGM(1 0 1,2 0 2,4 0 4)
>
> Oh, I get it. And there is a native way in postgis to calibrate the line
> from a given set of measured points instead of using the ends?
>
> --
>
> If I understand it correctly I could:
>
> 1) mylinestringm = ST_AddMeasure(mylinestring, measure_start, measure_end);
> 2) Add the given set of points to mylinestringm with ST_AddPoint
> 3) Using ST_SetPoint to move the original vertexes.
>
> Is that correct? I'm very interested to know if there is a more direct
> and proper way to create a route from a set of points.

ST_MakeLine [1] can be used to aggregate a sequence of points into a line.

[1] http://www.postgis.org/documentation/manual-1.5/ST_MakeLine.html