From: Bruno Wolff III <bruno@wolff.to>
To: Michael Fuhr <mike@fuhr.org>
Cc: Andy Lewis <jumboc@comcast.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Radius of a zip code
Date: Fri, 26 Dec 2003 22:34:04 -0600
Message-ID: <20031227043404.GB5264@wolff.to> (raw)
In-Reply-To: <20031226194244.A15916@quality.qadas.com>
References: <000b01c3cc09$e043fd70$0201a8c0@andy2>
<20031226194244.A15916@quality.qadas.com>
On Fri, Dec 26, 2003 at 19:42:44 -0700,
Michael Fuhr <mike@fuhr.org> wrote:
>
> I have several databases with lat/lon coordinates and frequently make
> "show me all records within a certain distance of this point" queries.
> I wrote a haversine() function that uses the Haversine Formula to
> calculate the great circle distance between two points on a sphere
> (assuming the earth is a perfect sphere is accurate enough for my uses).
> Here's a web site with related info:
The distance operator in contrib/earthdistance got changed to use
haversine instead of the naive formula in 7.3. In 7.4 it also provides
some functions that work with contrib/cube that allow for indexed
searches.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bruno@wolff.to, mike@fuhr.org, jumboc@comcast.net
Subject: Re: Radius of a zip code
In-Reply-To: <20031227043404.GB5264@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox