Re: Advice on geolocation

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Chris Albertson <chrisalbertson90278(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Advice on geolocation
Date: 2002-07-26 17:15:42
Message-ID: 20020726171542.GA19516@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jul 26, 2002 at 09:33:53 -0700,
Chris Albertson <chrisalbertson90278(at)yahoo(dot)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).

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Janning Vygen 2002-07-26 17:27:01 plpgsql: function throws error on second call!
Previous Message Janning Vygen 2002-07-26 17:12:35 Re: slow update