<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Your report also mentions PDAL 1.5. Can you try 1.7.1? It is packaged with OSGeo4W and available on that platform.<div class=""><br class=""></div><div class="">Howard</div><div class=""><br class=""><div><blockquote type="cite" class=""><div class="">On Apr 12, 2018, at 7:58 AM, Andrew Bell <<a href="mailto:andrew.bell.ia@gmail.com" class="">andrew.bell.ia@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">I'd have to do some more work to figure out the discrepancy, but if your goal is to use PDAL to read/write to postgres, you don't need to do all the setup that you've done. PDAL will handle this for you. Simply point PDAL at your (empty) database and let it do the setup and writing for you.<div class=""><br class=""></div><div class="">Normally PDAL will create a schema that writes X,Y and Z as double-precision values. You can have it write 32-bit scaled integers by providing scaling factors (see <a href="https://www.pdal.io/stages/writers.pgpointcloud.html" class="">https://www.pdal.io/stages/writers.pgpointcloud.html</a> for more info). I think the issue is that the schema PDAL wants to use isn't the one you've created.</div><div class=""><br class=""></div><div class="">If I have time I'll try to reproduce your steps so that I can give a more precise answer.</div></div><div class="gmail_extra"><br class=""><div class="gmail_quote">On Thu, Apr 12, 2018 at 6:14 AM, Lars <span dir="ltr" class=""><<a href="mailto:laasunde@hotmail.com" target="_blank" class="">laasunde@hotmail.com</a>></span> wrote:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr" class="">
<div id="m_-386678794954824380divtagdefaultwrapper" style="font-size: 12pt; font-family: Calibri, Helvetica, sans-serif;" dir="ltr" class=""><div style="margin-top: 0px; margin-bottom: 0px;" class=""><span class="">Hello</span></div><p class="">Using PDAL 1.5, PostgreSQL 9.5 and PostGIS bundle 2.3 on Windows 7.</p><p class=""><br class="">
</p><p class="">We have followed the instructions found at <a href="https://github.com/pgpointcloud/pointcloud" target="_blank" class="">https://github.com/<wbr class="">pgpointcloud/pointcloud</a><br class="">
(Created database, added extensions, created pcpoint and pcpatch tables).</p><p class=""><br class="">
</p><p class="">We have inserted a schema into pointcloud_formats (samme as <a href="https://github.com/pgpointcloud/pointcloud" target="_blank" class="">https://github.com/<wbr class="">pgpointcloud/pointcloud</a> but without Intensity).</p><p class=""><br class="">
</p><p class="">We have successfully insert data into pcpoint table from sql shell.<br class="">
INSERT INTO pcpoint(pa) VALUES(PC_MakePoint(1, ARRAY[1,2,3])); <br class="">
This results in a data blob that is 17 bytes.</p><p class=""><br class="">
</p><p class="">However using PDAL pipeline to insert data into table causes the following error;<br class="">
pc_patch_uncompressed_from_<wbr class="">wkb: wkb size and expected size does not match.</p><p class=""><br class="">
</p><p class="">The sql log file shows that PDAL execute the following sql statement;<br class="">
INSERT INTO pcpoint(pa) VALUES('0103000000........<wbr class="">0840');<br class="">
This data blob is 37 bytes and is very different to above test (17 bytes).</p><p class=""><br class="">
</p><p class="">The pipeline script looks like this;<br class="">
{<br class="">
"pipeline": [<br class="">
{<br class="">
"type": "readers.text",<br class="">
"filename": "data.txt",<br class="">
"separator": ";"<br class="">
},<br class="">
{<br class="">
"type":"filters.chipper",<br class="">
"capacity":100<br class="">
},<br class="">
{<br class="">
"type": "writers.pgpointcloud",<br class="">
"connection": "host='localhost' dbname='aaa' port='5433' user='aaa' password='aaa'",<br class="">
"table": "pcpoint",<br class="">
"pcid":"1",<br class="">
"compression": "none"<br class="">
}<br class="">
]<br class="">
}<br class="">
The data.txt file looks like this;<br class="">
X;Y;Z<br class="">
1.00;2.00;3.00</p><p class=""><br class="">
</p><p class=""><span class="">What are we doing wrong? How can I can make PDAL pipeline produce the correct data blob that matches the schema used in db?
</span></p><p class=""><span class=""><br class="">
</span></p><p class=""><span class="">Thanks.</span></p><p class=""><br class="">
</p>
</div>
</div>
<br class="">______________________________<wbr class="">_________________<br class="">
pdal mailing list<br class="">
<a href="mailto:pdal@lists.osgeo.org" class="">pdal@lists.osgeo.org</a><br class="">
<a href="https://lists.osgeo.org/mailman/listinfo/pdal" rel="noreferrer" target="_blank" class="">https://lists.osgeo.org/<wbr class="">mailman/listinfo/pdal</a><br class=""></blockquote></div><br class=""><br clear="all" class=""><div class=""><br class=""></div>-- <br class=""><div class="gmail_signature" data-smartmail="gmail_signature">Andrew Bell<br class=""><a href="mailto:andrew.bell.ia@gmail.com" target="_blank" class="">andrew.bell.ia@gmail.com</a></div>
</div>
_______________________________________________<br class="">pdal mailing list<br class=""><a href="mailto:pdal@lists.osgeo.org" class="">pdal@lists.osgeo.org</a><br class="">https://lists.osgeo.org/mailman/listinfo/pdal</div></blockquote></div><br class=""></div></body></html>