On 6/18/2013 10:42 AM, Jeff Herrin wrote:
I'm trying to get a compass bearing (N,S,NW,etc) using earthdistance. I can successfully get the distance between 2 points using either the point or cube method, but I've been struggling with getting the bearing. Any tips?
calculating the angle between two points on the surface of a sphere is non-trivial.
You'll probably need to use PostGIS for that, and the ST_Azimuth() function, which returns angle in radians betweeen two points (multiple by 180/PI to get degrees)
-- john r pierce 37N 122W somewhere on the middle of the left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
