| From: | Rick Genter <rick(dot)genter(at)gmail(dot)com> | 
|---|---|
| To: | pgsql <pgsql-general(at)postgresql(dot)org> | 
| Subject: | Re: Miidpoint between two long/lat points? (earthdistance?) | 
| Date: | 2011-05-25 16:59:33 | 
| Message-ID: | BANLkTik71UdWvZeiM786CjTPwK=LLU2hpg@mail.gmail.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
On Wed, May 25, 2011 at 9:47 AM, Carlo Stonebanks <
stonec(dot)register(at)sympatico(dot)ca> wrote:
>  I need to calculate the long/lat values between a line demarcated by two
> long/lat points.
>
>
>
> The points will be very close, but there is the 180 degree problem to
> consider, so a simple average won’t work.
>
>
>
> Does anyone know of a function or have a formula that will work using geo
> long/lat values? I don’t see anything obvious in the earthdistance module.
>
The simplest way to deal with "the 180 degree problem" is to remember that
you can add 360 degrees to a long and get a value that should continue to
work. So, assuming "West" is negative, -175 (175 degrees West) is the same
as -175+360 = 185 (185 degrees East). Then you don't have to worry about
wraparound. If the result is > 180, subtract 360.
-- 
Rick Genter
rick(dot)genter(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Farber | 2011-05-25 17:58:43 | PostgreSQL 8.4.8 bringing my website down every evening | 
| Previous Message | Carlo Stonebanks | 2011-05-25 16:47:05 | Miidpoint between two long/lat points? (earthdistance?) |