[postgis-users] Get point certain degree of another point

Marc Jansen jansen at terrestris.de
Sat Jan 23 06:15:55 PST 2010


Hi tommy408,

I would construct a horizontal line with your starting point and the 
distance you need and afterwards rotate that line using ST_Rotate
http://postgis.refractions.net/documentation/manual-svn/ST_Rotate.html

The new endpoint should be what  you are searching.

Regards,
Marc

tommy408 schrieb:
> How can I get a point at a certain distance and degree from another point. 
> For example 10 meter distance to another point at 45 degrees.
>
> I'm thinking, draw some kind of imaginary circle around point A with radius
> R, convert it to a line, and use ST_Line_Interpolate_Point.
>
>   




More information about the postgis-users mailing list