[postgis-users] Extracting points from a line

[Tom van Tilburg]

David, I should read before I write... completely missed this in the new 
postgis version.

I was basing myself on a post from opengeo where it is still in a roadmap:
http://opengeo.org/technology/postgis/coredevelopment/lrs/

Again, thanks for pointing me out. Really happy to see this!

Cheers,
  Tom

On 27-7-2012 16:24, David William Bitner wrote:
> What kind of upgrades are you after? ST_LocateAlong does allow for 
> offsetting along a line.
>
> On Fri, Jul 27, 2012 at 3:16 AM, Tom van Tilburg 
> <tom.van.tilburg at gmail.com <mailto:tom.van.tilburg at gmail.com>> wrote:
>
>     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  <mailto:postgis-users at postgis.refractions.net>
>>     http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>     _______________________________________________
>     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/977e3f6d/attachment.html>