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@xxxxxxxxxxxx> 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@xxxxxxxxx] Sent: May 26, 2011 9:53 AM To: Carlo Stonebanks Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Miidpoint between two long/lat points? (earthdistance?) On Thu, May 26, 2011 at 12:05 AM, Merlin Moncure <mmoncure@xxxxxxxxx> 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@xxxxxxxxxxxxxx) 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. |