[pdal] las2pg and las2col

[Oscar Martinez Rubi]

Hi,

We have added in liblas (master branch in github) two new tools that maybe useful for DB users:


-          las2pg: converts a LAS/LAZ into PostgreSQL binary dump format. It can be used for faster flat (1 point per row) data insertion in PostgreSQL. This is useful when you use flat tables for your point clouds (not recommended for large point clouds) of if you want to create pc_patches in a custom manner (other than what PDAL does). It is the alternative to making the insert with las2txt (essentially binary is faster than ASCII). Example of usage:

psql -c "create table flat (x double precision, y double precision, z double precision, r integer, g integer, b integer, i integer)"
las2pg -i 1.2-with-color.laz --parse xyzRGBi --stdout | psql -c "copy flat from stdin with binary"



-          las2col: similarly to las2pg, this tool converts a LAS/LAZ into binary columnar files to be imported in the column-store MonetDB (https://www.monetdb.org/). Example of usage:

las2col -i 1.2-with-color.laz -o out --parse XYZi
mclient <db_name> -s "create table flat (x decimal(8,2), y decimal(8,2), z decimal(8,2), i smallint)"
mclient <db_name> -s "COPY BINARY INTO flat FROM ('<full_parent_path>/out_col_x.dat','<full_parent_path>/out_col_y.dat','<full_parent_path>/out_col_z.dat','<full_parent_path>/out_col_i.dat')"

If time permits, we will add similar writers in PDAL, so the same functionality is available through PDAL 😊

Kind Regards,

O.

| 4th National eScience Symposium | Science in a Digital World |
| 13 October 2016 | https://www.esciencecenter.nl/event/4th-national-escience-symposium |

| Oscar Martinez Rubi | eScience Engineer | o.rubi at esciencecenter.nl |
| Netherlands eScience Center | http://www.esciencecenter.nl | T +31 (0) 6-10363806 |

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pdal/attachments/20160705/bdb64ba2/attachment.html>