[Qgis-developer] Postgis Pointcloud support

[Martin Isenburg]

Hello,

I am a bit hesitant to recommend inserting LiDAR point clouds into a
database (because I believe - for LiDAR or dense-matching points -- you
should just only insert the shapefile outlines into a database and then run
a las2las query on those spatially indexed (amd possibly resorted) LAS /
LAZ  files whose outlines overlap the queried area) as this has shown not
to be very performant in a large study by TU Delft involving many different
spatial databases ... but in some use cases it may make sense. The papers
and relevant discussions are linked here:

http://groups.google.com/d/topic/lastools/MoYPFzFVxa8/discussion
http://groups.google.com/d/topic/lastools/jkB1UK5DxN4/discussion

That said ... one case where it may make sense is when you insert once and
then look-up *a lot* in small batched. Something like what Yuriv Czoli from
developmentseed did will give you some pointers to get started:

http://developmentseed.org/blog/2014/08/07/processing-lidar-point-cloud/
http://gist.github.com/YKCzoli/3605e014b8ed09a571e5

Regards,

Martin

On Thu, Jul 23, 2015 at 8:11 PM, Tim Sutton <tim at kartoza.com> wrote:

> Hi
>
>
> On 22 Jul 2015, at 09:39, Ziegler Stefan <Stefan.Ziegler at bd.so.ch> wrote:
>
> Hi
>
> I just read in the changelog that there is some postgis pointcloud layers
> support? What does this mean? Can I load e.g. the patches as polygon into
> QGIS?
>
>
> I tried to replicate / test etc. when working on the changeling, and
> couldn’t figure out how to make it do anything useful, get hold of a usable
> test dataset etc. Hopefully someone out there will write up a little
> tutorial or something.
>
> Regards
>
> Tim
>
> Regards
> Stefan
>
> Freundliche Grüsse
> Stefan Ziegler
> Kantonsgeometer
>
> Amt für Geoinformation
> Amtliche Vermessung
> Rötistrasse 4
> 4500 Solothurn
>
> Telefon +41 32 627 75 96
> Telefax +41 32 627 75 98
> stefan.ziegler at bd.so.ch
> http://www.so.ch
>
>
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
>
> —
>
>
>
>
> Tim Sutton
>
> Visit http://kartoza.com to find out about open source:
>
> * Desktop GIS programming services
> * Geospatial web development
> * GIS Training
> * Consulting Services
>
> Skype: timlinux Irc: timlinux on #qgis at freenode.net
> Tim is a member of the QGIS Project Steering Committee
>
> Kartoza is a merger between Linfiniti and Afrispatial
>
>
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20150724/dc17b13a/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: KartozaLogo160x66.png
Type: image/png
Size: 9324 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20150724/dc17b13a/attachment.png>