[postgis-users] Quadgrid Recursive SQL Function - Now Available on Github

[Rémi Cura]

Most interesting !
I really like the LATERAL, even at the price of postgres >=9.3, it is well
worth it.

I spent a lot of time to efficiently build quad tree over point cloud
(plpgsql, then python),
and I must say 20 sec for 1 million points is good.

Cheers,
Rémi-C

2015-03-10 8:54 GMT+01:00 Andre Mano <andre.s.mano at gmail.com>:

> Thanks for the sharing Mark - very helpful stuff!
>
>
> On Tue, Mar 10, 2015 at 6:28 AM, Mark Wynter <mark at dimensionaledge.com>
> wrote:
>
>> Hi everyone
>>
>> I’ve been talking about sharing this code for some time - well here it
>> is.   You can find the code on GitHub.
>>
>> Here’s the write up
>>
>>
>> http://dimensionaledge.com/quadgrid-generation-using-recursive-sql-function/
>>
>> The blog post includes a GIF animation that shows the recursive quadgrid
>> in action, plus a 3D representation of Sydney’s population density.
>>
>> Quadgrids are not limited to underlying points.  You can use any value
>> criteria, such as the length of line strings, if for say quadgridding a set
>> of watercourses or roads.
>>
>> Best regards
>> Mark
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>
>
>
> --
> ..................................
> André Mano
> http://opussig.blogspot.com/
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150310/14bfa66c/attachment.html>