<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><span style="color: rgb(160, 160, 168);">On January 30, 2014 at 5:12:51 AM, Nilesh Vyavahare (</span><a href="mailto://nilesh.vyavahare@seazone.com">nilesh.vyavahare@seazone.com</a><span style="color: rgb(160, 160, 168);">) wrote:</span></div><div id="bloop_sign_1391096739226490880" class="bloop_sign"><span style="font-family:helvetica,arial;font-size:13px"></span></div> <div><blockquote type="cite" class="clean_bq" style="font-family: Helvetica, Arial; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"><span><div lang="EN-GB" link="blue" vlink="purple" xml:lang="EN-GB"><div class="WordSection1"><p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(60, 60, 60);">Hello everyone,</span></p><p class="MsoNormal"><span style="color: rgb(60, 60, 60); font-family: Arial, sans-serif; font-size: 10pt;">1) I am using PDAL pcpipeline to upload some data into Postgres. In the pcpipeline I have specified to split the data into the patches of 400 points. From the demonstration example I understand that the patches will not be overlapping but when I look at the extents of patches (and the points themselves) they appear to be overlapping. I have attached the pipeline xml I am using. Am I missing some trick here?</span></p></div></div></span></blockquote></div><p>I’ll wait for Howard to answer this one, but even if the patches are not perfectly non-overlapping that’s not the end of the world, pgpointcloud really doesn’t care either way, and patches that are “mostly not overlapping” will be just as efficient as ones “totally not overlapping"</p><div><div><blockquote type="cite" class="clean_bq" style="font-family: Helvetica, Arial; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"><span><div lang="EN-GB" link="blue" vlink="purple" xml:lang="EN-GB"><div class="WordSection1"><p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(60, 60, 60);">2) Another thing I was wondering is that, in PDAL you have one filter called “filters.hexabin” which is supposed draw an outline around the patch. At the moment the only way I could get the patch extent out, is to write out an xml file. Is there any way to write that extent into PostGIS directly next to the patch?</span></p></div></div></span></blockquote></div><p>You can get the extent of the patch just by casting it to geometry. To experience, just</p><p>select st_astext(mypatch::geometry) from mytable;</p><p>Now, it may be that I made the wrong choice in that cast and it should create a multi-point, but I’m sticking with it for now. Folks who want points can also explode their patches first. Casting a pcpoint to geometry returns a pointz.</p><p>P.</p><p><br></p><p><br></p><div><blockquote type="cite" class="clean_bq" style="font-family: Helvetica, Arial; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"><span><div lang="EN-GB" link="blue" vlink="purple" xml:lang="EN-GB"><div class="WordSection1"><p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(60, 60, 60);"><br class="Apple-interchange-newline"> </span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(60, 60, 60);">Just a note, in case you are specifying pre_sql/post_sql inside your pipeline, specifying the SQL statement inside the pipeline xml file didn’t work for me so I had to write SQL statement in some other file and put the location of that sql file in there and it worked.</span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(60, 60, 60);"> </span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(60, 60, 60);">Thanks in advance for your help.</span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(60, 60, 60);"> </span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(60, 60, 60);">Regards,</span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(60, 60, 60);">Nilesh</span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(60, 60, 60);"> </span></p><p class="MsoNormal"><b><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(60, 60, 60);">Nilesh Vyavahare</span></b><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(60, 60, 60);"><br>Senior GIS Analyst, SeaZone<br><br>E:<span class="Apple-converted-space"> </span><a href="mailto:nilesh.vyavahare@seazone.com"><span style="color: black;">nilesh.vyavahare@seazone.com</span></a><br>T: +44 (0)1491 822861</span></p><p class="MsoNormal"><a href="http://www.hrwallingford.com/banner.html"><span style="font-size: 12pt; font-family: 'Times New Roman', serif; color: blue; text-decoration: none;"><img border="0" width="1" height="1" id="_x0000_i1029" src="http://www.hrwallingford.com/site/images/SZ_Banner.gif" alt="SeaZone Banner" name="_x0000_i1029"></span></a></p><div class="MsoNormal" align="center" style="text-align: center;"><hr size="1" width="100%" align="center"></div><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0"><tbody><tr><td width="205" style="width: 153.75pt; padding: 3.75pt;"><p class="MsoNormal"><span style="font-size: 12pt; font-family: 'Times New Roman', serif; color: rgb(60, 60, 60);"><img border="0" width="197" height="66" id="_x0000_i1028" src="http://www.hrwallingford.com/site/images/SZ_Logo.gif" alt="SeaZone Logo" name="_x0000_i1028"></span></p></td><td style="padding: 3.75pt;"><p class="MsoNormal"><b><span style="font-size: 10pt; font-family: Arial, sans-serif; color: gray;">SeaZone</span></b><span style="font-size: 10pt; font-family: Arial, sans-serif; color: gray;"><br>Howbery Park, Wallingford, Oxfordshire OX10 8BA, United Kingdom<br>T: +44 (0)870 013 0607 F: +44 (0)870 013 0608<br><a href="www.seazone.com"><span style="color: gray;">www.seazone.com</span></a></span></p></td><td width="205" style="width: 153.75pt; padding: 3.75pt;"><p class="MsoNormal"><span style="font-size: 12pt; font-family: 'Times New Roman', serif; color: rgb(60, 60, 60);"><img border="0" width="170" height="64" id="_x0000_i1027" src="http://www.hrwallingford.com/site/images/SZ_Logo2.gif" alt="SeaZone Secondary Logo" name="_x0000_i1027"></span></p></td></tr></tbody></table><div class="MsoNormal" align="center" style="text-align: center;"><hr size="1" width="100%" align="center"></div></div><br><hr><p style="font-family: arial; color: grey;"><b>SeaZone</b><span class="Apple-converted-space"> </span>uses faxes and emails for confidential and legally privileged business communications. They do not of themselves create legal commitments. Disclosure to parties other than addressees requires our specific consent. We are not liable for unauthorised disclosures nor reliance upon them.<br>If you have received this message in error please advise us immediately and destroy all copies of it.<br><br>SeaZone is a division of HR Wallingford Limited.<br>Howbery Park, Wallingford, Oxfordshire, OX10 8BA, United Kingdom<br>Registered in England No. 2562099<br></p><hr><hr><div>- Pipeline_Template.xml, 4 KB</div>_______________________________________________<span class="Apple-converted-space"> </span><br>pgpointcloud mailing list<span class="Apple-converted-space"> </span><br>pgpointcloud@lists.osgeo.org<span class="Apple-converted-space"> </span><br>http://lists.osgeo.org/cgi-bin/mailman/listinfo/pgpointcloud</div></span></blockquote></div></div></body></html>