| From: | "Brent Wood" <b(dot)wood(at)niwa(dot)co(dot)nz> |
|---|---|
| To: | <mmoncure(at)gmail(dot)com>, <stonec(dot)register(at)sympatico(dot)ca> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Miidpoint between two long/lat points? (earthdistance?) |
| Date: | 2011-05-26 20:39:50 |
| Message-ID: | 4DDF63560200007B0003D44A@gwia.niwa.co.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 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(at)gmail(dot)com]
Sent: May 26, 2011 9:53 AM
To: Carlo Stonebanks
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Miidpoint between two long/lat points?
(earthdistance?)
On Thu, May 26, 2011 at 12:05 AM, Merlin Moncure 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(at)postgresql(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gauthier, Dave | 2011-05-26 21:04:04 | Re: copy record? |
| Previous Message | Gauthier, Dave | 2011-05-26 20:23:50 | copy record? |