Miidpoint between two long/lat points? (earthdistance?)

From: Carlo Stonebanks <stonec(dot)register(at)sympatico(dot)ca>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Miidpoint between two long/lat points? (earthdistance?)
Date: 2011-05-25 16:47:05
Message-ID: BLU0-SMTP78EBE1162D71ADE9BE9AAE96740@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rick Genter 2011-05-25 16:59:33 Re: Miidpoint between two long/lat points? (earthdistance?)
Previous Message Bosco Rama 2011-05-25 16:33:38 Re: Postgres 8.3.5 - ECPG and the use of descriptors and cursors in multi-threaded programs