Postgres Pro
Downloads
Home   >   mailing lists

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

From Carlo Stonebanks
Subject Miidpoint between two long/lat points? (earthdistance?)
Date
Msg-id BLU0-SMTP78EBE1162D71ADE9BE9AAE96740@phx.gbl
Whole thread Raw
Responses Re: Miidpoint between two long/lat points? (earthdistance?)  (Rick Genter <rick.genter@gmail.com>)
Re: Miidpoint between two long/lat points? (earthdistance?)  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Tree view

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.

pgsql-general by date:

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