<div dir="ltr">I don't think this should be happening, but I'm not very familiar with pgpointcloud. Do you get the same overlapping tile behavior if you write to LAS, for example?</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Nov 30, 2020 at 10:00 PM Peter Lim <<a href="mailto:peter.lim@gpslands.com">peter.lim@gpslands.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div lang="EN-SG"><div class="gmail-m_6653623188670215846WordSection1"><p class="MsoNormal"><span style="color:rgb(54,95,145)">Hi,<u></u><u></u></span></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><span style="color:rgb(54,95,145)">I’m reading some las files, using filters.chipper and write to PostgreSQ database using the following pipeline:<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)">[<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"> {<u></u><u></u></span></p><p class="MsoNormal" style="text-indent:36pt"><span style="color:rgb(54,95,145)">"type":"readers.las",<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"> "filename":"X:/tem/*.las"<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"> },<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"> {<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"> "type":"filters.reprojection",<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"> "in_srs":"EPSG:32648",<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"> "out_srs":"EPSG:3414"<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"> },<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"> {<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"> "type":"filters.chipper",<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"> "capacity":600<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"> }, <u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"> {<u></u><u></u></span></p><p class="MsoNormal" style="text-indent:36pt"><span style="color:rgb(54,95,145)">"type":"writers.pgpointcloud",<u></u><u></u></span></p><p class="MsoNormal" style="text-indent:36pt"><span style="color:rgb(54,95,145)">"connection":"host='localhost' dbname='lidar' user='anyuser' ",<u></u><u></u></span></p><p class="MsoNormal" style="text-indent:36pt"><span style="color:rgb(54,95,145)">"table":"example",<u></u><u></u></span></p><p class="MsoNormal" style="text-indent:36pt"><span style="color:rgb(54,95,145)">"schema":"pc",<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"> "overwrite":"true", <u></u><u></u></span></p><p class="MsoNormal" style="margin-left:36pt"><span style="color:rgb(54,95,145)">"compression":"dimensional",<u></u><u></u></span></p><p class="MsoNormal" style="margin-left:36pt"><span style="color:rgb(54,95,145)">"srid":"3414",<u></u><u></u></span></p><p class="MsoNormal" style="text-indent:36pt"><span style="color:rgb(54,95,145)">"scale_x":"0.001",<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"> "scale_y":"0.001",<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"> "scale_z":"0.001",<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"> "offset_x":"2000",<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"> "offset_y":"20000", <u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"> "output_dims":"Intensity, X, Y, Z" <u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"> } <u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)">]<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)">However, the table has many overlapping patches as shown below:<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"><img width="450" height="452" id="gmail-m_6653623188670215846Picture_x0020_1" src="cid:1761e43703f6917eb1"><u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)">I had tried using filters.mortonorder but still the same results. <u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)">May I know is there anyway to avoid or reduce overlapping patches.<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)">Please advise.<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)">Thank you.<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)">Best Regards,<u></u><u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="color:rgb(54,95,145)">Peter Lim<u></u><u></u></span></p><p class="MsoNormal"><u></u> <u></u></p></div><div id="gmail-m_6653623188670215846DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
<table style="border-top:1px solid rgb(211,212,222)">
<tbody><tr>
<td style="width:55px;padding-top:13px"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" width="46" height="29" style="width: 46px; height: 29px;"></a></td>
<td style="width:470px;padding-top:12px;color:rgb(65,66,78);font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Virus-free. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" style="color:rgb(68,83,234)" target="_blank">www.avast.com</a>
</td>
</tr>
</tbody></table><a href="#m_6653623188670215846_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"> </a></div></div>_______________________________________________<br>
pdal mailing list<br>
<a href="mailto:pdal@lists.osgeo.org" target="_blank">pdal@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/pdal" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/pdal</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature">Andrew Bell<br><a href="mailto:andrew.bell.ia@gmail.com" target="_blank">andrew.bell.ia@gmail.com</a></div>