Re: Miidpoint between two long/lat points? (earthdistance?) - Mailing list pgsql-general

From Brent Wood
Subject Re: Miidpoint between two long/lat points? (earthdistance?)
Date
Msg-id 4DDF63560200007B0003D44A@gwia.niwa.co.nz
Whole thread Raw
Responses Re: Miidpoint between two long/lat points? (earthdistance?)
List pgsql-general
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.

pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: copy record?
Next
From: "Gauthier, Dave"
Date:
Subject: Re: copy record?