earthdistance

From: Olivier Chaussavoine <olivier(dot)chaussavoine(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: earthdistance
Date: 2013-08-09 19:29:49
Message-ID: CAKJCXwqPXbmWMQdpXQtOjH9wOoE0i0t6s+XBaTTzwi=sxg3s3g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I develope a project openbarter that needs to match objects based on a
maximum distance between their positions on earth. I saw that the
documentation of the extension earthdistance was interesting, but the
promise was not in the code. It would be nice to have these functions
available independently of sophisticated geographic systems. There is a
circle object for flat two dimensional space, but earth deals with
spherical caps. It would not be exact but enough to suppose that earth is a
sphere and that all dimensions latitude, longitude and distance are in
radian.
What would need to be done to adapt the circle type to a new type
'spherical cap' that would allow simple geographic indexing?

--
Olivier Chaussavoine

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2013-08-09 19:32:55 Re: Weird error when setting up streaming replication
Previous Message Jeff Janes 2013-08-09 19:03:52 Re: Weird error when setting up streaming replication