<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>