[postgis-devel] [cartodb] Re: GSOC weekly report 2 : Spatial clustering in PostGIS and CartoDB

[Sandro Santilli]

[moved exclusively to postgis-devel]

On Wed, Jun 04, 2014 at 12:29:56AM +0530, mohit kumar wrote:
> On Tue, Jun 3, 2014 at 5:20 PM, Sandro Santilli <strk at cartodb.com> wrote:

> > What's in that package that isn't already in the PostgreSQL
> > SP-GiST index ?
> > http://www.postgresql.org/docs/9.2/static/spgist.html
> >
> > I mean, don't you only need to implement the PostGIS connector ?
> 
> I wanted to modify the code for sp-gist to inculcate another integer field
> for various levels of clustering, so worked on the source code by purdue
> research group.

The best would be to contribute a patch back to PostgreSQL to make the
existing sp-gist code capable of doing what you need, if it isn't already.

I've added Teodor and Oleg (authors of the PostgreSQL implmentation) in Cc,
could you describe what your additional integer is meant to provide ?

Teodor, Oleg, the context here is adding sp-gist support to PostGIS Geometry
and using those indices to quickly compute population in a quadtree tile.

REF:
http://www.google-melange.com/gsoc/proposal/public/google/gsoc2014/mohitkharb/5698390809640960

--strk;

 ()  ASCII ribbon campaign  --  Keep it simple !
 /\  http://strk.keybit.net/rants/ascii_mails.txt