Home > mailing lists

Re: Points, Circles, Indexes, and query-by-Radius? - Mailing list pgsql-general

From	Tom Lane
Subject	Re: Points, Circles, Indexes, and query-by-Radius?
Date	August 2, 2001 20:25:45
Msg-id	13886.996786243@sss.pgh.pa.us Whole thread Raw
In response to	Points, Circles, Indexes, and query-by-Radius? (Bryan Field-Elliot <bryan_lists@netmeme.org>)
List	pgsql-general

Tree view

Bryan Field-Elliot <bryan_lists@netmeme.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

pgsql-general by date:

From: "Jim Ballard"
Date: 02 August 2001, 19:59:54
Subject: Timestamp with time zone issue

From: elwood@agouros.de (Konstantinos Agouros)
Date: 02 August 2001, 20:49:17
Subject: 'group by day' possible?

Re: Points, Circles, Indexes, and query-by-Radius? - Mailing list pgsql-general

Previous

Next