<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style>
<!--
@font-face
{font-family:Helvetica}
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
@font-face
{font-family:Tahoma}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
p
{margin-right:0cm;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif"}
span.apple-converted-space
{}
span.EmailStyle19
{font-family:"Arial","sans-serif";
color:#1F497D}
.MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:72.0pt 72.0pt 72.0pt 72.0pt}
div.WordSection1
{}
-->
</style>
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#1F497D">Hi Paul,</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#1F497D">Thanks for your reply. I have added further comments below.</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#1F497D">Nilesh</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#1F497D"> </span></p>
<div>
<div style="border:none; border-top:solid #B5C4DF 1.0pt; padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt; font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt; font-family:"Tahoma","sans-serif""> Paul Ramsey [mailto:pramsey@cleverelephant.ca]
<br>
<b>Sent:</b> Thursday, January 30, 2014 3:48 PM<br>
<b>To:</b> Nilesh Vyavahare; pgpointcloud@lists.osgeo.org<br>
<b>Subject:</b> Re: [pgpointcloud] Overlapping patches</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<div id="bloop_customfont">
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Helvetica","sans-serif"; color:#A0A0A8">On January 30, 2014 at 5:12:51 AM, Nilesh Vyavahare (</span><span style="font-size:10.0pt; font-family:"Helvetica","sans-serif""><a href="mailto://nilesh.vyavahare@seazone.com">nilesh.vyavahare@seazone.com</a><span style="color:#A0A0A8">)
wrote:</span></span></p>
</div>
<div>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt; orphans:auto; text-align:start; widows:auto; word-spacing:0px">
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C">Hello everyone,</span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C">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>
</blockquote>
</div>
<p><span style="font-size:10.0pt; font-family:"Helvetica","sans-serif"">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"</span></p>
<p><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#1F497D">The amount of overlap I am getting between patches is usually more than 90%. The reason I am more after non-overlapping patches is because I am thinking of first comparing patch
extents with a geometry to work out intersecting points, which hopefully should reduce time to work out intersecting points with a geometry. Or do you think it takes about the same time to work out the intersection either you compare patch extent or patch
itself? </span></p>
<div>
<div>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt; orphans:auto; text-align:start; widows:auto; word-spacing:0px">
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C">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>
</blockquote>
</div>
<p><span style="font-size:10.0pt; font-family:"Helvetica","sans-serif"">You can get the extent of the patch just by casting it to geometry. To experience, just</span></p>
<p><span style="font-size:10.0pt; font-family:"Helvetica","sans-serif"">select st_astext(mypatch::geometry) from mytable;</span></p>
<p><span style="font-size:10.0pt; font-family:"Helvetica","sans-serif"">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.</span></p>
<p><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#1F497D">Thanks for this Paul. I am probably being bit more demanding but the extent given by this way is an MBR, can I get hexbin extent in pgpointcloud similar to the ones shown in
Howard’s PDAL hexbin filters?</span></p>
<p><span style="font-size:10.0pt; font-family:"Helvetica","sans-serif"">P.</span></p>
<p><span style="font-size:10.0pt; font-family:"Helvetica","sans-serif""> </span></p>
<p><span style="font-size:10.0pt; font-family:"Helvetica","sans-serif""> </span></p>
<div>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt; orphans:auto; text-align:start; widows:auto; word-spacing:0px">
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C"><br>
</span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C">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" style="background:white"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C"> </span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C">Thanks in advance for your help.</span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C"> </span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C">Regards,</span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C">Nilesh</span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C"> </span></p>
<p class="MsoNormal" style="background:white"><b><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C">Nilesh Vyavahare</span></b><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C"><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" style="background:white"><a href="http://www.hrwallingford.com/banner.html"><span style="text-decoration:none"><img border="0" width="1" height="1" id="_x0000_i1057" 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; background:white">
<span style="font-size:10.0pt; font-family:"Helvetica","sans-serif"">
<hr size="1" width="100%" align="center">
</span></div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td width="205" style="width:153.75pt; padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal" style=""><span style="color:#3C3C3C"><img border="0" width="197" height="66" id="_x0000_i1059" src="http://www.hrwallingford.com/site/images/SZ_Logo.gif" alt="SeaZone Logo" name="_x0000_i1028"></span></p>
</td>
<td style="padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal" style=""><b><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:gray">SeaZone</span></b><span style="font-size:10.0pt; 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 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal" style=""><span style="color:#3C3C3C"><img border="0" width="170" height="64" id="_x0000_i1060" 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; background:white">
<span style="font-size:10.0pt; font-family:"Helvetica","sans-serif"">
<hr size="1" width="100%" align="center">
</span></div>
</div>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Helvetica","sans-serif""> </span></p>
<div class="MsoNormal" align="center" style="text-align:center; background:white">
<span style="font-size:10.0pt; font-family:"Helvetica","sans-serif"">
<hr size="2" width="100%" align="center">
</span></div>
<p style="background:white; color:grey"><b><span style="font-size:10.0pt; font-family:"Arial","sans-serif"">SeaZone</span></b><span class="apple-converted-space"><span style="font-size:10.0pt; font-family:"Arial","sans-serif""> </span></span><span style="font-size:10.0pt; font-family:"Arial","sans-serif"">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</span></p>
<div class="MsoNormal" align="center" style="text-align:center; background:white">
<span style="font-size:10.0pt; font-family:"Helvetica","sans-serif"">
<hr size="2" width="100%" align="center">
</span></div>
<div class="MsoNormal" align="center" style="text-align:center; background:white">
<span style="font-size:10.0pt; font-family:"Helvetica","sans-serif"">
<hr size="2" width="100%" align="center">
</span></div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Helvetica","sans-serif"">- Pipeline_Template.xml, 4 KB</span></p>
</div>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Helvetica","sans-serif"">_______________________________________________<span class="apple-converted-space"> </span><br>
pgpointcloud mailing list<span class="apple-converted-space"> </span><br>
<a href="mailto:pgpointcloud@lists.osgeo.org">pgpointcloud@lists.osgeo.org</a><span class="apple-converted-space"> </span><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/pgpointcloud">http://lists.osgeo.org/cgi-bin/mailman/listinfo/pgpointcloud</a></span></p>
</div>
</blockquote>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt; font-family:"Helvetica","sans-serif"; background:white"> </span></p>
<p align="center" style="text-align:center"><span style="font-size:10.0pt; font-family:"Helvetica","sans-serif"; background:white">Click
<a href="https://www.mailcontrol.com/sr/YGehixijnMzGX2PQPOmvUv8Fcr8RSh1BYsYR6eU5OVKg35blZVxRo2SzKLPN3ZpuGL0GFYTJej9Ppv0P1Tfw+Q==">
here</a> to report this email as spam.</span></p>
</div>
<br>
<hr>
<p style="font-family:arial; color:grey"><b>SeaZone</b> 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>
<p></p>
<hr>
<p></p>
</body>
</html>