Hi Martin
From my point of view there is one big advantage of having LiDAR point clouds
in a database: SQL (or probably more precise DML). No more system calls or
different programs to solve a problem. Just pure SQL. One interface to rule
them all: vector processing? SQL. Raster processing? SQL. Point cloud
processing? SQL. Combining them all together? SQL.
I tested Paul Ramseys work [1] with our own data. It’s really great and
comfortable to work with. But can’t say much about performance. I needed to
work on a really slow fanless celeron pc with a slow harddrive.
[1]: http://workshops.boundlessgeo.com/tutorial-lidar/
Regards
Stefan
Von: Martin Isenburg [mailto:martin.isenb...@gmail.com]
Gesendet: Freitag, 24. Juli 2015 11:55
An: Tim Sutton
Cc: Ziegler Stefan; QGIS Developer Mailing List
Betreff: Re: [Qgis-developer] Postgis Pointcloud support
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
t...@kartoza.commailto:t...@kartoza.com wrote:
Hi
On 22 Jul 2015, at 09:39, Ziegler Stefan
stefan.zieg...@bd.so.chmailto:stefan.zieg...@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 96tel:%2B41%2032%20627%2075%2096
Telefax +41 32 627 75 98tel:%2B41%2032%20627%2075%2098
stefan.zieg...@bd.so.chmailto:stefan.zieg...@bd.so.ch
http://www.so.ch
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.orgmailto:Qgis-developer@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer
—
[cid:image001.png@01D0C613.072492A0]
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.nethttp://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@lists.osgeo.orgmailto:Qgis-developer@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer