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
Thanks for the sharing Mark - very helpful stuff!
On Tue, Mar 10, 2015 at 6:28 AM, Mark Wynter
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/quadgr
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