<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p style="margin-top: 0px; margin-bottom: 0px;"><span>Hello</span></p>
<p>Using PDAL 1.5, PostgreSQL 9.5 and PostGIS bundle 2.3 on Windows 7.</p>
<p><br>
</p>
<p>We have followed the instructions found at https://github.com/pgpointcloud/pointcloud<br>
(Created database, added extensions, created pcpoint and pcpatch tables).</p>
<p><br>
</p>
<p>We have inserted a schema into pointcloud_formats (samme as https://github.com/pgpointcloud/pointcloud but without Intensity).</p>
<p><br>
</p>
<p>We have successfully insert data into pcpoint table from sql shell.<br>
INSERT INTO pcpoint(pa) VALUES(PC_MakePoint(1, ARRAY[1,2,3])); <br>
This results in a data blob that is 17 bytes.</p>
<p><br>
</p>
<p>However using PDAL pipeline to insert data into table causes the following error;<br>
pc_patch_uncompressed_from_wkb: wkb size and expected size does not match.</p>
<p><br>
</p>
<p>The sql log file shows that PDAL execute the following sql statement;<br>
INSERT INTO pcpoint(pa) VALUES('0103000000........0840');<br>
This data blob is 37 bytes and is very different to above test (17 bytes).</p>
<p><br>
</p>
<p>The pipeline script looks like this;<br>
{<br>
"pipeline": [<br>
{<br>
"type": "readers.text",<br>
"filename": "data.txt",<br>
"separator": ";"<br>
},<br>
{<br>
"type":"filters.chipper",<br>
"capacity":100<br>
},<br>
{<br>
"type": "writers.pgpointcloud",<br>
"connection": "host='localhost' dbname='aaa' port='5433' user='aaa' password='aaa'",<br>
"table": "pcpoint",<br>
"pcid":"1",<br>
"compression": "none"<br>
}<br>
]<br>
}<br>
The data.txt file looks like this;<br>
X;Y;Z<br>
1.00;2.00;3.00</p>
<p><br>
</p>
<p><span>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><span><br>
</span></p>
<p><span>Thanks.</span></p>
<p><br>
</p>
</div>
</body>
</html>