[postgis-users] Extracting points from a line

[Tom van Tilburg]

Thanks for pointing that out David!

I got my example from an existing piece of code that needed measures 
later on, so at that time it made sense to create the measure.
Nevertheless I'm hoping for some upgrade of the linear referencing 
functions. Especially the option of offsetting along a line would be superb.

On 26-7-2012 16:52, David William Bitner wrote:
> Tom,
>
> You've got the right toolbox out, but you're doing a bit of 
> mismatching between the tools.
>
> You can certainly do this using the Linear Referencing tools by either 
> using ST_Add_Measure and then using ST_LocateAlong (or 
> ST_Locate_Along_Measure pre 2.0) OR just use ST_Line_Interpolate_Point 
> along with ST_Length.
>
> Examples of how to do this in a single step:
>
> With Measures:
> _____________________________________________
>
>     postgis-users mailing list
>     postgis-users at postgis.refractions.net
>     <mailto:postgis-users at postgis.refractions.net>
>     http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
>
> -- 
> ************************************
> David William Bitner
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120727/310d727d/attachment.html>