<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Andrew,<br>
<br>
I have been testing with the scale, selector and the new stuff and
everything works perfectly! Thanks!<br>
<br>
As an example for other people which may be interested in how to
make it work:<br>
<br>
createdb testdb<br>
psql testdb -f init.sql<br>
pdal pipeline pipeline.xml<br>
<br>
This stores only x, y and z as int_32 with dimensional compression
and block size of 3000 points<br>
<br>
Regards,<br>
<br>
O.<br>
<br>
-----<br>
where init.sql is:<br>
<br>
CREATE EXTENSION postgis;<br>
CREATE EXTENSION pointcloud;<br>
CREATE EXTENSION pointcloud_postgis;<br>
INSERT INTO pointcloud_formats (pcid, srid, schema) VALUES (1,
28992,<br>
'<?xml version="1.0"
encoding="UTF-8"?>
<br>
<pc:PointCloudSchema
xmlns:pc=<a class="moz-txt-link-rfc2396E" href="http://pointcloud.org/schemas/PC/">"http://pointcloud.org/schemas/PC/"</a>
xmlns:xsi=<a class="moz-txt-link-rfc2396E" href="http://www.w3.org/2001/XMLSchema-instance">"http://www.w3.org/2001/XMLSchema-instance"</a>><br>
<pc:dimension>
<br>
<pc:position>1</pc:position>
<br>
<pc:size>4</pc:size>
<br>
<pc:description>X
coordinate</pc:description>
<br>
<pc:scale>0.01</pc:scale>
<br>
<pc:offset>0</pc:offset>
<br>
<pc:name>X</pc:name>
<br>
<pc:interpretation>int32_t</pc:interpretation>
<br>
<pc:active>true</pc:active>
<br>
</pc:dimension>
<br>
<pc:dimension>
<br>
<pc:position>2</pc:position>
<br>
<pc:size>4</pc:size>
<br>
<pc:description>Y
coordinate</pc:description>
<br>
<pc:scale>0.01</pc:scale>
<br>
<pc:offset>0</pc:offset>
<br>
<pc:name>Y</pc:name>
<br>
<pc:interpretation>int32_t</pc:interpretation>
<br>
<pc:active>true</pc:active>
<br>
</pc:dimension>
<br>
<pc:dimension>
<br>
<pc:position>3</pc:position>
<br>
<pc:size>4</pc:size>
<br>
<pc:description>Z
coordinate</pc:description>
<br>
<pc:scale>0.01</pc:scale>
<br>
<pc:offset>0</pc:offset>
<br>
<pc:name>Z</pc:name>
<br>
<pc:interpretation>int32_t</pc:interpretation>
<br>
<pc:active>true</pc:active>
<br>
</pc:dimension>
<br>
<pc:metadata>
<br>
<Metadata name="compression"
type="string">dimensional</Metadata></pc:metadata>
<br>
<pc:orientation>point</pc:orientation>
<br>
</pc:PointCloudSchema>');<br>
<br>
CREATE TABLE patches (<br>
id SERIAL PRIMARY KEY,<br>
pa PCPATCH(1)<br>
);<br>
<br>
-----<br>
<br>
and pipeline.xml is:<br>
<br>
<?xml version="1.0" encoding="utf-8"?><br>
<Pipeline version="1.0"><br>
<Writer type="writers.pgpointcloud"><br>
<Option
name="connection">dbname='testdb'</Option><br>
<Option name="table">patches</Option><br>
<Option name="column">pa</Option><br>
<Option name="srid">28992</Option><br>
<Option name="overwrite">false</Option><br>
<Option name="pcid">1</Option><br>
<Option name="capacity">3000</Option><br>
<Option name="compression">dimensional</Option><br>
<Option name="output_dims">X,Y,Z</Option><br>
<Option name="offset_x">0</Option><br>
<Option name="offset_y">0</Option><br>
<Option name="offset_z">0</Option><br>
<Option name="scale_x">0.01</Option><br>
<Option name="scale_y">0.01</Option><br>
<Option name="scale_z">0.01</Option><br>
<Filter type="filters.chipper"><br>
<Option name="capacity">3000</Option><br>
<Reader type="readers.las"><br>
<Option
name="filename">/home/oscar/ahn_minibench.laz</Option><br>
<Option
name="spatialreference">EPSG:28992</Option><br>
</Reader><br>
</Filter><br>
</Writer><br>
</Pipeline><br>
<br>
<br>
<div class="moz-cite-prefix">On 05-02-15 09:44, Oscar Martinez Rubi
wrote:<br>
</div>
<blockquote
cite="mid:96abw2lclxum5jovxjbqfycy.1423125848493@email.android.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<div>That was fast! Thanks</div>
<div>I will pull latest pdal and give it a try.</div>
<div>Let me know how the selector works and i will also try that
one.</div>
<div>Regards</div>
<div>O.</div>
<div><br>
</div>
<div><br>
</div>
<div>
<div style="font-size:8px; color:#575757">Enviado de Samsung
Mobile</div>
</div>
<br>
<br>
<div>-------- Mensaje original --------</div>
<div>De: Andrew Bell </div>
<div>Fecha:05/02/2015 00:12 (GMT+01:00) </div>
<div>Para: Oscar Martinez Rubi </div>
<div>Cc: <a class="moz-txt-link-abbreviated" href="mailto:pdal@lists.osgeo.org">pdal@lists.osgeo.org</a> </div>
<div>Asunto: Re: [pdal] pgpointcloud selector filter and
max_capacity </div>
<div><br>
</div>
<div>
<div dir="ltr">
<div class="gmail_extra">
<div class="gmail_quote">On Wed, Feb 4, 2015 at 10:02 AM,
Oscar Martinez Rubi <span dir="ltr">
<<a moz-do-not-send="true"
href="mailto:o.martinezrubi@tudelft.nl"
target="_blank">o.martinezrubi@tudelft.nl</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;
border-left:1px #ccc solid; padding-left:1ex">
<div bgcolor="#FFFFFF">At some point I though that the
selection of dimensions could be done when I insert
the point cloud format in the DB (I only insert a
format with X,Y,Z) but I found out that after running
PDAL the one I inserted is ignored and a new format
with all the dimensions is used. So, we definitively
need a way to tell the writter which columns are
desired.<br>
<br>
Just to be clear, the scale_x..., is supposed to be
specified in the PDAL pipeline XML or in the point
cloud format inserted in the DB or in both?<br>
</div>
</blockquote>
<div><br>
</div>
<div>You specify this in the pipeline and the values are
stored as integers with a scaling factor instead of as
double. I'll document.</div>
<div><br>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;
border-left:1px #ccc solid; padding-left:1ex">
<div bgcolor="#FFFFFF">Well, I attach the sql file I
execute to set the DB <br>
and the pipeline xml I am using to run pdal pipeline.<br>
<br>
With these ones I get a PDAL: ERROR: unterminated
quoted string at or near "....
<br>
Looks like mismatch between expected format and the
actual block format</div>
</blockquote>
<div><br>
</div>
<div>I fixed this bug and it has been merged to the master
branch in github. </div>
<div><br>
</div>
<div>Also, I have selector-type behavior working and I
should have that in for the database drivers tomorrow.</div>
<div><br>
</div>
<div>Best,</div>
<div><br>
</div>
</div>
-- <br>
<div class="gmail_signature">Andrew Bell<br>
<a moz-do-not-send="true"
href="mailto:andrew.bell.ia@gmail.com">andrew.bell.ia@gmail.com</a></div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
pdal mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pdal@lists.osgeo.org">pdal@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/pdal">http://lists.osgeo.org/mailman/listinfo/pdal</a></pre>
</blockquote>
<br>
</body>
</html>