Why not install PostGIS with full ellipsoidal & projection support & use the azimuth & distance functions available in SQL?
Brent Wood
Brent Wood
DBA/GIS consultant
NIWA, Wellington
New Zealand
>>> Carlo Stonebanks <stonec.register@sympatico.ca> 05/27/11 8:20 AM >>>
Nicely done, Merlin! Hope others with the same problem can find this post.
Thanks a lot.
-----Original Message-----
From: Merlin Moncure [mailto:mmoncure@gmail.com]
Sent: May 26, 2011 9:53 AM
To: Carlo Stonebanks
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Miidpoint between two long/lat points?
(earthdistance?)
On Thu, May 26, 2011 at 12:05 AM, Merlin Moncure <mmoncure@gmail.com> wrote:
> Converted from javascript from here: http://en.wikipedia.org/wiki/Atan2
whoops! meant to say here:
http://www.movable-type.co.uk/scripts/latlong.html
merlin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Please consider the environment before printing this email.
NIWA is the trading name of the National Institute of Water & Atmospheric Research Ltd.