earthdistance - Mailing list pgsql-general

From Olivier Chaussavoine
Subject earthdistance
Date
Msg-id CAKJCXwqPXbmWMQdpXQtOjH9wOoE0i0t6s+XBaTTzwi=sxg3s3g@mail.gmail.com
Whole thread Raw
Responses Re: earthdistance  (Brent Wood <Brent.Wood@niwa.co.nz>)
Re: earthdistance  (Uwe Schroeder <uwe@oss4u.com>)
Re: earthdistance  (Dann Corbit <DCorbit@connx.com>)
List 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

pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Weird error when setting up streaming replication
Next
From: Jeff Janes
Date:
Subject: Re: Weird error when setting up streaming replication