[postgis-users] How can I create a point at a known distance & bearing from a point in Postgis?

David Rowley dgrowleyml at gmail.com
Sat Dec 14 21:08:37 PST 2013


On Sun, Dec 15, 2013 at 2:52 PM, Brent Wood <pcreso at pcreso.com> wrote:

>
>
> Hi,
>
> 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.
>
> 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.
>
>
Sounds like you need ST_Project()

Regards

David Rowley
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131215/0a33396d/attachment.html>


More information about the postgis-users mailing list