Re: earthdistance compass bearing - Mailing list pgsql-general

From John R Pierce
Subject Re: earthdistance compass bearing
Date
Msg-id 51C0A690.1050208@hogranch.com
Whole thread Raw
In response to earthdistance compass bearing  (Jeff Herrin <jeff@openhotel.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Postgres DB crashing
Next
From: Steve Crawford
Date:
Subject: Re: earthdistance compass bearing