<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Indeed, a column store for arrays is usually quite ;-) inefficient.<br>
Let me point you to the rasdaman array DBMS which plugs into PostgreSQL
and offers an optimized array query language on top. See
<a class="moz-txt-link-abbreviated" href="http://www.rasdaman.org">www.rasdaman.org</a>.<br>
<br>
-Peter<br>
<br>
<br>
<br>
<br>
Paul Ramsey wrote:
<blockquote
cite="mid:AANLkTilgFs1vR5ZCkKy3ECu9pDE9tokfqX7Aks9YQadV@mail.gmail.com"
type="cite">
<pre wrap="">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 <a class="moz-txt-link-rfc2396E" href="mailto:pramsey@opengeo.org"><pramsey@opengeo.org></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">There is no recommended way right now. It's a core development
activity I'd love to have funded... :)
<a class="moz-txt-link-freetext" href="http://opengeo.org/products/coredevelopment/postgis/pointclouds/">http://opengeo.org/products/coredevelopment/postgis/pointclouds/</a>
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 <a class="moz-txt-link-rfc2396E" href="mailto:newskatze@riomhphost.net"><newskatze@riomhphost.net></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!---->_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="80">--
Dr. Peter Baumann
- Professor of Computer Science, Jacobs University Bremen
<a class="moz-txt-link-abbreviated" href="http://www.faculty.jacobs-university.de/pbaumann">www.faculty.jacobs-university.de/pbaumann</a>
mail: <a class="moz-txt-link-abbreviated" href="mailto:p.baumann@jacobs-university.de">p.baumann@jacobs-university.de</a>
tel: +49-421-200-3178, fax: +49-421-200-493178
- Executive Director, rasdaman GmbH Bremen (HRB 147737)
<a class="moz-txt-link-abbreviated" href="http://www.rasdaman.com">www.rasdaman.com</a>, mail: <a class="moz-txt-link-abbreviated" href="mailto:baumann@rasdaman.com">baumann@rasdaman.com</a>
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)
</pre>
</body>
</html>