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

George Silva georger.silva at gmail.com
Wed Mar 28 11:19:24 PDT 2012


I guess the best way to do this is to combine the actual line and a
"virtual" line, probably a view, with "measured" points.

This involves a bit of thinking but it might be possible.

George

On Wed, Mar 28, 2012 at 3:03 PM, Stephen Woodbridge <woodbri at swoodbridge.com
> wrote:

> 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<http://www.postgis.org/documentation/manual-1.5/ST_MakeLine.html>
>
> ______________________________**_________________
> postgis-users mailing list
> postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
> http://postgis.refractions.**net/mailman/listinfo/postgis-**users<http://postgis.refractions.net/mailman/listinfo/postgis-users>
>



-- 
George R. C. Silva

Desenvolvimento em GIS
http://geoprocessamento.net
http://blog.geoprocessamento.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120328/68412b70/attachment.html>


More information about the postgis-users mailing list