<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt">Thanks David - I do indeed...<br><br>Cheers,<br> <br><div><span>Brent<br></span></div><div><br></div> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font face="Arial" size="2"> <b><span style="font-weight:bold;">From:</span></b> David Rowley <dgrowleyml@gmail.com><br> <b><span style="font-weight: bold;">To:</span></b> Brent Wood <pcreso@pcreso.com>; PostGIS Users Discussion <postgis-users@lists.osgeo.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Sunday, December 15, 2013 6:08 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [postgis-users] How can I create a point at a known distance & bearing from a point in
Postgis?<br> </font> </div> <div class="y_msg_container"><br><div id="yiv5487265515"><div><div dir="ltr"><div class="yiv5487265515gmail_extra"><br clear="none"><div class="yiv5487265515yqt6710760012" id="yiv5487265515yqtfd15457"><div class="yiv5487265515gmail_quote">On Sun, Dec 15, 2013 at 2:52 PM, Brent Wood <span dir="ltr"><<a rel="nofollow" shape="rect" ymailto="mailto:pcreso@pcreso.com" target="_blank" href="mailto:pcreso@pcreso.com">pcreso@pcreso.com</a>></span> wrote:<br clear="none">
<blockquote class="yiv5487265515gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex;"><div><div style="font-size:12pt;font-family:'times new roman', 'new york', times, serif;">
<div></div><div><span><br clear="none"></span></div><br clear="none"><div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt;"><div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt;">
Hi,<br clear="none"><br clear="none">I
have a dataset with start & end points that we are represtnting as
linestrings. Many records do not have endpoints - so we are takimg the
median bearling for comparable startpoints & creating an arbitrary
endpoint.<br clear="none"><br clear="none">While it is easy to get a bearing for a known endpoint
with ST_Azimuth(), is there a simple way in Postgis to get the point at a
defined distance & bearing? I've perused the docs & nothing
jumped out as an obvious solution.</div></div><div><br clear="none"></div></div></div></blockquote><div><br clear="none"></div><div>Sounds like you need ST_Project()</div><div> </div><div>Regards</div><div><br clear="none"></div><div>David Rowley</div></div></div></div><div class="yiv5487265515yqt6710760012" id="yiv5487265515yqtfd31615">
</div></div></div></div><br><br></div> </div> </div> </div></body></html>