Re: Points, Circles, Indexes, and query-by-Radius?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bryan Field-Elliot <bryan_lists(at)netmeme(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Points, Circles, Indexes, and query-by-Radius?
Date: 2001-08-02 21:04:03
Message-ID: 13886.996786243@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bryan Field-Elliot <bryan_lists(at)netmeme(dot)org> writes:
> I'm developing a GIS system on PostgreSQL. I need to store a table of
> points (latitude and longitude), and do queries such as "return all
> points enclosed with the given circle ((X,Y),R)".

You might care to look at

http://postgis.refractions.net/postgis-0.5.1.tar.gz

and see if you're not reinventing the wheel.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Konstantinos Agouros 2001-08-02 21:18:19 'group by day' possible?
Previous Message Tom Lane 2001-08-02 20:44:33 Re: Re: [HOW TO:] timestamp WITHOUT timezone