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