[postgis-users] Extracting points from a line

David William Bitner bitner at gyttja.org
Fri Jul 27 07:24:30 PDT 2012


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>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
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>
>
>  --
> ************************************
> David William Bitner
>
>
> _______________________________________________
> postgis-users mailing listpostgis-users at postgis.refractions.nethttp://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>


-- 
************************************
David William Bitner
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120727/fa873d4c/attachment.html>


More information about the postgis-users mailing list