[postgis-users] lidar: what is the recommended way of storing/indexing

Peter Baumann p.baumann at jacobs-university.de
Thu Jul 8 06:31:48 PDT 2010

Indeed, a column store for arrays is usually quite ;-) inefficient.
Let me point you to the rasdaman array DBMS which plugs into PostgreSQL 
and offers an optimized array query language on top. See www.rasdaman.org.


Paul Ramsey wrote:
> Oh, actually one-row-per-point is a bad idea, because the size of
> lidar sets mitigates against that. Putting them into multipoint
> collections of 50 or 100 points is better. But that implies
> preprocessing things a bit to find good patches. In generally, there's
> a lot of tooling needed to do this well, I fear.
> P
> On Thu, Jul 8, 2010 at 6:27 AM, Paul Ramsey <pramsey at opengeo.org> wrote:
>> There is no recommended way right now. It's a core development
>> activity I'd love to have funded... :)
>> http://opengeo.org/products/coredevelopment/postgis/pointclouds/
>> In the meanwhile a approach might be to put the x/y/z into a postgis
>> geometry and stuff the rest of the data into an array of doubles in
>> another column. Your app would need to know which array element was
>> which kind of data, but you'd still have it all available.
>> P.
>> On Thu, Jul 8, 2010 at 2:53 AM, Biddy <newskatze at riomhphost.net> wrote:
>>> Hi everyone,
>>> is there a recommended way of storing lidar data in postgis?
>>> In particular, I am interested in not just storing long, lat, alt but also
>>> keeping all the raw data (for example range, target number, reflectance,
>>> etc.)
>>> Regards,
>>> B.
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

Dr. Peter Baumann
 - Professor of Computer Science, Jacobs University Bremen
   mail: p.baumann at jacobs-university.de
   tel: +49-421-200-3178, fax: +49-421-200-493178
 - Executive Director, rasdaman GmbH Bremen (HRB 147737)
   www.rasdaman.com, mail: baumann at rasdaman.com
   tel: 0800-rasdaman, fax: 0800-rasdafax, mobile: +49-173-5837882
"Si forte in alienas manus oberraverit hec peregrina epistola incertis ventis dimissa, sed Deo commendata, precamur ut ei reddatur cui soli destinata, nec preripiat quisquam non sibi parata." (mail disclaimer, AD 10xx)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100708/cba62068/attachment.html>

More information about the postgis-users mailing list