<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;} @font-face
{font-family:Wingdings}
@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:11.0pt;
font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif"}
span.EmailStyle17
{font-family:"Arial","sans-serif";
color:#3C3C3C}
span.BalloonTextChar
{font-family:"Tahoma","sans-serif"}
.MsoChpDefault
{font-family:"Calibri","sans-serif"}
@page WordSection1
{margin:72.0pt 72.0pt 72.0pt 72.0pt}p {margin-top:0; margin-bottom:0}--></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Hi Jonathan,</p>
<p><br>
</p>
<p>The project page for pointcloud is here: <a id="LPlnk182536" href="https://github.com/pgpointcloud/pointcloud">
https://github.com/pgpointcloud/pointcloud</a> and the mailing list here: <a id="LPlnk633423" href="http://lists.osgeo.org/mailman/listinfo/pgpointcloud/">
http://lists.osgeo.org/mailman/listinfo/pgpointcloud/</a><br>
</p>
<p><br>
</p>
<p>It is an extension to PostGIS, so that's why you aren't seeing any documentation in the core PostGIS project.</p>
<p><br>
</p>
<p>Best of luck,</p>
<p>Cheers,</p>
<p>Steve</p>
<p><br>
</p>
<div id="Signature"><style type="text/css" style="display:none"> <!-- p {margin-top:0; margin-bottom:0} --> </style>
<div id="divtagdefaultwrapper" style="font-size:12pt; color:#000000; background-color:#FFFFFF; font-family:Calibri,Arial,Helvetica,sans-serif">
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px">
<div class="WordSection1">
<p class="MsoNormal"><img style="-moz-user-select: none;" alt="http://sig.cmparks.net/cmp-ms-90x122.png" height="122" hspace="12" width="90" align="left" src="http://sig.cmparks.net/cmp-ms-90x122.png">
<span style="font-size:14pt; color:rgb(0,108,86); font-family:Helvetica,sans-serif">
<span style="font-family:Helvetica,sans-serif"><strong>Stephen V. Mather</strong></span><br style="font-family:Helvetica,sans-serif">
<span style="font-family:Helvetica,sans-serif"></span></span><span style="font-size:11pt; color:rgb(0,108,86); font-family:Helvetica,sans-serif"><span style="font-family:Helvetica,sans-serif">GIS Manager</span><br style="font-family:Helvetica,sans-serif">
<span style="font-family:Helvetica,sans-serif"></span></span><span style="font-size:9pt; color:rgb(0,108,86); font-family:Helvetica,sans-serif"><span style="font-family:Helvetica,sans-serif">(216) 635-3243 (Work)
</span></span><span style="font-size:11pt; color:rgb(31,73,125); font-family:Helvetica,sans-serif"><a id="LPNoLP" target="_blank" href="http://www.clemetparks.com" tabindex="0"><span style="font-family:Helvetica,sans-serif"><br style="font-family:Helvetica,sans-serif">
<span style="font-family:Helvetica,sans-serif">clevelandmetroparks.com</span></span></a></span></p>
<p class="MsoNormal"></p>
<br>
<br>
<br>
</div>
</div>
<div></div>
</div>
</div>
</div>
</div>
<div style="color: rgb(33, 33, 33);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" color="#000000" face="Calibri, sans-serif"><b>From:</b> postgis-users-bounces@lists.osgeo.org <postgis-users-bounces@lists.osgeo.org> on behalf of Jonathan Moules <J.Moules@hrwallingford.com><br>
<b>Sent:</b> Friday, February 13, 2015 7:46 AM<br>
<b>To:</b> 'postgis-users@lists.osgeo.org'<br>
<b>Subject:</b> [postgis-users] The pcpatch datatype</font>
<div> </div>
</div>
<div>
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C">Hi List,</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C">I’m new to PostGIS and have inherited a database which is being used to store a pointcloud.</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C">The data seems to be in a “pcpatch” Data type, and this is being converted into points for extraction with: “select pc_explode(pa)::geometry …”.</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C">The problem is, I can find no reference to pcpatch in the PostGIS documentation, or to the pc_explode function. I’ve tried both the online search and Ctrl-F
in the PDF.</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C">Is there any documentation for this? If so, can someone please point me to it that’d be really useful. Alternately, an explanation of the datatype would be
useful. Is it WKB?</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C">I‘ve figured out that the “::” (double colon) is casting the result into a geometry data type, so that’s one less problem.
</span><span style="font-size:10.0pt; font-family:Wingdings; color:#3C3C3C">J</span><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C"></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C">PostGIS 2.1.3</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#3C3C3C">Thanks,<br>
Jonathan</span></p>
</div>
<br>
<hr>
<p style="font-family:arial; font-size:8pt"><b>HR Wallingford and its subsidiaries</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>
HR Wallingford Limited<br>
Howbery Park, Wallingford, Oxfordshire, OX10 8BA, United Kingdom<br>
Registered in England No. 02562099<br>
</p>
<p></p>
<hr>
<p></p>
</div>
</div>
</div>
</body>
</html>