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

[mohit kumar]

Thanks Strk for the help.
I have now moved to postgresSQL implementation of the sp-gist indexing and
am working on it.

Hi Teodor,Oleg, actually along with the sp-gist index in  PostGIS Geometry
(point data) I wanted to store the zoom levels and number of child nodes
along the indexes for a better indexing at a given zoom level.

Regards,
Mohit


On Wed, Jun 4, 2014 at 3:00 PM, Sandro Santilli <strk at keybit.net> wrote:

> [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
>



-- 
Mohit Kumar
+91-970-3840-175
Lab For Spatial Informatics
International Institute of Information Technology
Hyderabad, India
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20140605/f890014e/attachment.html>