Thread: Re: Miidpoint between two long/lat points? (earthdistance?)

Why not install PostGIS with full ellipsoidal & projection support & use the azimuth & distance functions available in SQL?

Brent Wood



>>> 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

On Thu, May 26, 2011 at 3:39 PM, Brent Wood <b.wood@niwa.co.nz> wrote:
> Why not install PostGIS with full ellipsoidal & projection support & use the
> azimuth & distance functions available in SQL?

installing postgis is a bit much if all you need to do are simple
distance calculations etc.

merlin