[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Extracting points from a line
From: Tom van Tilburg <tom.van.tilburg () gmail ! com>
Date: 2012-07-27 15:04:12
Message-ID: 5012ADEC.90301 () gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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@gmail.com <mailto:tom.van.tilburg@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@postgis.refractions.net
>> <mailto:postgis-users@postgis.refractions.net>
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>>
>>
>> --
>> ************************************
>> David William Bitner
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users@postgis.refractions.net <mailto:postgis-users@postgis.refractions.net>
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> <mailto:postgis-users@postgis.refractions.net>
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
>
> --
> ************************************
> David William Bitner
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
[Attachment #5 (text/html)]
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">David, I should read before I write...
completely missed this in the new postgis version.<br>
<br>
I was basing myself on a post from opengeo where it is still in a
roadmap:<br>
<a class="moz-txt-link-freetext" \
href="http://opengeo.org/technology/postgis/coredevelopment/lrs/">http://opengeo.org/technology/postgis/coredevelopment/lrs/</a><br>
<br>
Again, thanks for pointing me out. Really happy to see this!<br>
<br>
Cheers,<br>
Tom<br>
<br>
On 27-7-2012 16:24, David William Bitner wrote:<br>
</div>
<blockquote
cite="mid:CAEqvsZu9uxL=UJ+gU5om4yrki5wL63zryfwcc1W9QhJ6-WQUZQ@mail.gmail.com"
type="cite">What kind of upgrades are you after? ST_LocateAlong
does allow for offsetting along a line.<br>
<br>
<div class="gmail_quote">On Fri, Jul 27, 2012 at 3:16 AM, Tom van
Tilburg <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:tom.van.tilburg@gmail.com" \
target="_blank">tom.van.tilburg@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Thanks for pointing that out David!<br>
<br>
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.<br>
Nevertheless I'm hoping for some upgrade of the linear
referencing functions. Especially the option of offsetting
along a line would be superb.
<div class="im"><br>
<br>
On 26-7-2012 16:52, David William Bitner wrote:<br>
</div>
</div>
<blockquote type="cite">
<div class="im">Tom,
<div><br>
</div>
<div>You've got the right toolbox out, but you're doing
a bit of mismatching between the tools.</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Examples of how to do this in a single step:</div>
<div><br>
</div>
<div>With Measures:</div>
</div>
<div class="im">
_____________________________________________<br>
<div>
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
postgis-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:postgis-users@postgis.refractions.net"
target="_blank">postgis-users@postgis.refractions.net</a><br>
<a moz-do-not-send="true"
\
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
\
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br> \
<br> </blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
************************************<br>
David William Bitner<br>
</div>
<br>
<fieldset></fieldset>
<br>
</div>
<div class="im">
<pre>_______________________________________________
postgis-users mailing list
<a moz-do-not-send="true" href="mailto:postgis-users@postgis.refractions.net" \
target="_blank">postgis-users@postgis.refractions.net</a> <a moz-do-not-send="true" \
href="http://postgis.refractions.net/mailman/listinfo/postgis-users" \
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a> \
</pre> </div>
</blockquote>
<br>
</div>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a moz-do-not-send="true"
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
************************************<br>
David William Bitner<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" \
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" \
href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
</body>
</html>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic