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

From Bruce Momjian
Subject Re: Points, Circles, Indexes, and query-by-Radius?
Date
Msg-id 200108060259.f762xpB16835@candle.pha.pa.us
Whole thread Raw
In response to Re: Points, Circles, Indexes, and query-by-Radius?  (Brent Wood <baw@frc.niwa.cri.nz>)
List pgsql-general
> > For extra credit, it would be nice if I could store circles instead of
> > points, and issue queries like the following:
> >
> > "given a circle ((X,Y),R), return all circles which share some common area"
> >
>
> I haven't yet played with it, but look at PostGIS, an add-on for
> PostgreSQL which claims to have better spatial indexing & querying
> capabilities for geometric datatypes.
>
> As an aside, can anyone comment on the likelihood of this becoming a part
> of mainstream pgsql? Or what is currently happening with pgsql spatial
> support, especially regarding fmaps development?

PostGIS is sitting in my mailbox and I am waiting to hear if it should
be added to contrib.  It is 132k.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: Dave Page
Date:
Subject: RE: [ODBC] Visual Basic and PostgreSQL ODBC
Next
From:
Date:
Subject: Improved Load Speed From Current Sources