Re: Advice on geolocation - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Advice on geolocation
Date
Msg-id 20020726171542.GA19516@wolff.to
Whole thread Raw
In response to Re: Advice on geolocation  (Chris Albertson <chrisalbertson90278@yahoo.com>)
Responses Re: Advice on geolocation
Re: Advice on geolocation
List pgsql-general
On Fri, Jul 26, 2002 at 09:33:53 -0700,
  Chris Albertson <chrisalbertson90278@yahoo.com> wrote:
>
> I've done quite a bit of this as I used to work on a GIS
> product.  Given to lat,lon pairs it is not hard to find
> the great circle distance between them.  This assumes a
> spherical Earth but good enough for your purposes as the
> error will be under a few hundred meters

My concern about this is that it will not be indexable. I suspect, but don't
know, that this won't really be an issue for the small number (~5000) points
of data (especially since I expect other constraints to be used in most
queries).

pgsql-general by date:

Previous
From: Elielson Fontanezi
Date:
Subject: Numeric Style format
Next
From: Janning Vygen
Date:
Subject: Re: slow update