'Re: [postgis-users] The pcpatch datatype'

[prev in list] [next in list] [prev in thread] [next in thread] 

List: postgis-users
Subject: Re: [postgis-users] The pcpatch datatype
From: Rémi_Cura <remi.cura () gmail ! com>
Date: 2015-02-13 15:17:23
Message-ID: CAJvUf_vWmP37R4KKJqxsvu9kW0eGagUX-LyNk6494FxZwhSPFQ () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]

Some doc if you want  (I recommand also the readme on github):

   - General presentationof pgPointCloud by its creator @pramsey
   <http://boundlessgeo.com/wp-content/uploads/2013/10/pgpointcloud-foss4-2013.pdf>
   - A testimony of successful uses of pgPointCloud in a
   vector/raster/Lidar framework
   <http://www.coordinatesolutions.com/download/Jan2013OGI%20Presentation.pdf>
   - An Advanced presentation of various usages of a Point Cloud server,
   starting from basic to very complex examples
   <https://github.com/Remi-C/Postgres_Day_2014_10_RemiC/raw/master/presentation/A%20PostgreSQL%20Server%20for%20Point%20Cloud%20Storage%20and%20Processing.pdf>

   - A scientific paper comparing a pgPointCloud solution and a MonetDB
   solution <http://foss4g-e.org/sites/default/files/11-Martinez-Rubi_0.pdf>

2015-02-13 16:10 GMT+01:00 Vincent Picavet - ML <vincent.ml@oslandia.com>:

> Hi,
> 
> Le vendredi 13 février 2015, 14:35:51 Jonathan Moules a écrit :
> > Thanks Steve (and Martijn!)
> > An extension of an extension then, that might get confusing.
> 
> PointCloud is actually a PostgreSQL extension, and can work without
> PostGIS.
> There are convenience functions on top of PointCloud and PostGIS to allow
> data
> to be converted to and from both data types and do spatial filtering.
> 
> It is activated like this :
> 
> CREATE EXTENSION postgis;
> CREATE EXTENSION pointcloud;
> CREATE EXTENSION pointcloud_postgis;
> 
> This is therefore not really a PostGIS extension per se, as SFCGAL would
> be.
> My 2 cents.
> 
> Vincent
> 
> > 
> > Cheers,
> > Jonathan
> > 
> > From: postgis-users-bounces@lists.osgeo.org
> > [mailto:postgis-users-bounces@lists.osgeo.org] On Behalf Of Stephen V.
> > Mather Sent: Friday, February 13, 2015 1:50 PM
> > To: 'postgis-users@lists.osgeo.org'
> > Subject: Re: [postgis-users] The pcpatch datatype
> > 
> > 
> > Hi Jonathan,
> > 
> > 
> > 
> > The project page for pointcloud is here:
> > https://github.com/pgpointcloud/pointcloud and the mailing list here:
> > http://lists.osgeo.org/mailman/listinfo/pgpointcloud/
> > 
> > 
> > 
> > It is an extension to PostGIS, so that's why you aren't seeing any
> > documentation in the core PostGIS project.
> > 
> > 
> > 
> > Best of luck,
> > 
> > Cheers,
> > 
> > Steve
> > 
> > 
> > [http://sig.cmparks.net/cmp-ms-90x122.png]Stephen V. Mather
> > GIS Manager
> > (216) 635-3243 (Work)
> > clevelandmetroparks.com<http://www.clemetparks.com>
> > 
> > 
> > ________________________________
> > From:
> > postgis-users-bounces@lists.osgeo.org<mailto:
> postgis-users-bounces@lists.os
> > geo.org>
> > <postgis-users-bounces@lists.osgeo.org<mailto:
> postgis-users-bounces@lists.o
> > sgeo.org>> on behalf of Jonathan Moules
> > <J.Moules@hrwallingford.com<mailto:J.Moules@hrwallingford.com>> Sent:
> > Friday, February 13, 2015 7:46 AM
> > To: 'postgis-users@lists.osgeo.org'
> > Subject: [postgis-users] The pcpatch datatype
> > 
> > Hi List,
> > I'm new to PostGIS and have inherited a database which is being used to
> > store a pointcloud.
> > 
> > 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 …".
> > 
> > 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.
> > 
> > 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?
> > 
> > I‘ve figured out that the "::" (double colon) is casting the result into
> a
> > geometry data type, so that's one less problem. :)
> > 
> > PostGIS 2.1.3
> > 
> > Thanks,
> > Jonathan
> > 
> > ________________________________
> > 
> > HR Wallingford and its subsidiaries 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. If you have received this message in
> > error please advise us immediately and destroy all copies of it.
> > 
> > HR Wallingford Limited
> > Howbery Park, Wallingford, Oxfordshire, OX10 8BA, United Kingdom
> > Registered in England No. 02562099
> > 
> > ________________________________
> > 
> > 
> > This message has been scanned for viruses by
> > MailControl<http://www.mailcontrol.com/>, a service from BlackSpider
> > Technology
> > 
> > Click
> > 
> here<
> https://www.mailcontrol.com/sr/C5T+ArodN4bGX2PQPOmvUml+xXZX6Ibq!s03C+J
> > WLa6pFyTwcLbQKgTol!QpvrqmvD9w1fK+b76W4Hi4JZPuPA==> to report this
> email as
> > spam.
> > 
> > 
> > 
> > ________________________________
> > 
> > HR Wallingford and its subsidiaries 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. If you have received this message in
> > error please advise us immediately and destroy all copies of it.
> > 
> > HR Wallingford Limited
> > Howbery Park, Wallingford, Oxfordshire, OX10 8BA, United Kingdom
> > Registered in England No. 02562099
> > 
> > ________________________________
> 
> --
> Vincent Picavet - Gérant Oslandia
> www.oslandia.com
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

[Attachment #5 (text/html)]

<div dir="ltr">Some doc if you want (I recommand also the readme on \
github): <ul><li> <a \
href="http://boundlessgeo.com/wp-content/uploads/2013/10/pgpointcloud-foss4-2013.pdf">General \
presentationof pgPointCloud by its creator @pramsey</a> </li><li><a \
href="http://www.coordinatesolutions.com/download/Jan2013OGI%20Presentation.pdf">A \
testimony of successful uses of pgPointCloud in a vector/raster/Lidar framework \
</a></li><li><a href="https://github.com/Remi-C/Postgres_Day_2014_10_RemiC/raw/master/ \
presentation/A%20PostgreSQL%20Server%20for%20Point%20Cloud%20Storage%20and%20Processing.pdf">An \
Advanced presentation of various usages of a Point Cloud server, starting from basic \
to very complex examples</a></li><li><a \
href="http://foss4g-e.org/sites/default/files/11-Martinez-Rubi_0.pdf">A scientific \
paper comparing a pgPointCloud solution and a MonetDB \
solution</a></li></ul> </div><div class="gmail_extra"> <div \
class="gmail_quote">2015-02-13 16:10 GMT+01:00 Vincent Picavet - ML &lt;<a href="mailto:vincent.ml@oslandia.com" \
target="_blank">vincent.ml@oslandia.com</a>&gt;: <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">Hi, 
Le vendredi 13 février 2015, 14:35:51 Jonathan Moules a écrit : 
&gt; Thanks Steve (and Martijn!) 
&gt; An extension of an extension then, that might get confusing. 
 
PointCloud is actually a PostgreSQL extension, and can work without \
PostGIS. There are convenience functions on top of PointCloud and PostGIS to \
allow data to be converted to and from both data types and do spatial \
filtering. 
It is activated like this : 
 
CREATE EXTENSION postgis; 
CREATE EXTENSION pointcloud; 
CREATE EXTENSION pointcloud_postgis; 
 
This is therefore not really a PostGIS extension per se, as SFCGAL would be. 
My 2 cents. 
 
Vincent 
 
&gt; 
&gt; Cheers, 
&gt; Jonathan 
&gt; 
&gt; From: <a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a> 
 &gt; [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a>] \
On Behalf Of Stephen V. &gt; Mather Sent: Friday, February 13, 2015 1:50 PM 
&gt; To: &#39;<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>&#39; 
 &gt; Subject: Re: [postgis-users] The pcpatch datatype 
&gt; 
&gt; 
&gt; Hi Jonathan, 
&gt; 
&gt; 
&gt; 
&gt; The project page for pointcloud is here: 
&gt; <a href="https://github.com/pgpointcloud/pointcloud" \
target="_blank">https://github.com/pgpointcloud/pointcloud</a> and the mailing list \
here: &gt; <a href="http://lists.osgeo.org/mailman/listinfo/pgpointcloud/" \
target="_blank">http://lists.osgeo.org/mailman/listinfo/pgpointcloud/</a> \
&gt; &gt; 
&gt; 
&gt; It is an extension to PostGIS, so that&#39;s why you aren&#39;t seeing any 
&gt; documentation in the core PostGIS project. 
&gt; 
&gt; 
&gt; 
&gt; Best of luck, 
&gt; 
&gt; Cheers, 
&gt; 
&gt; Steve 
&gt; 
&gt; 
&gt; [<a href="http://sig.cmparks.net/cmp-ms-90x122.png]Stephen" \
target="_blank">http://sig.cmparks.net/cmp-ms-90x122.png]Stephen</a> V. Mather \
&gt; GIS Manager &gt; (216) 635-3243 (Work) 
&gt; <a href="http://clevelandmetroparks.com" \
target="_blank">clevelandmetroparks.com</a>&lt;<a href="http://www.clemetparks.com" \
target="_blank">http://www.clemetparks.com</a>&gt; &gt; 
&gt; 
&gt; ________________________________ 
&gt; From: 
&gt; <a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a>&lt;mailto:<a \
href="mailto:postgis-users-bounces@lists.os">postgis-users-bounces@lists.os</a> \
&gt; <a href="http://geo.org" target="_blank">geo.org</a>&gt; &gt; &lt;<a \
href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a>&lt;mailto:<a \
href="mailto:postgis-users-bounces@lists.o">postgis-users-bounces@lists.o</a> \
&gt; <a href="http://sgeo.org" target="_blank">sgeo.org</a>&gt;&gt; on \
behalf of Jonathan Moules &gt; &lt;<a \
href="mailto:J.Moules@hrwallingford.com">J.Moules@hrwallingford.com</a>&lt;mailto:<a \
href="mailto:J.Moules@hrwallingford.com">J.Moules@hrwallingford.com</a>&gt;&gt; \
Sent: &gt; Friday, February 13, 2015 7:46 AM 
&gt; To: &#39;<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>&#39; 
 &gt; Subject: [postgis-users] The pcpatch datatype 
&gt; 
&gt; Hi List, 
&gt; I'm new to PostGIS and have inherited a database which is being used to 
&gt; store a pointcloud. 
&gt; 
&gt; The data seems to be in a "pcpatch" Data type, and this is being converted 
&gt; into points for extraction with: "select pc_explode(pa)::geometry …". 
&gt; 
&gt; The problem is, I can find no reference to pcpatch in the PostGIS 
&gt; documentation, or to the pc_explode function. I've tried both the online 
&gt; search and Ctrl-F in the PDF. 
&gt; 
&gt; Is there any documentation for this? If so, can someone please point me to 
&gt; it that'd be really useful. Alternately, an explanation of the datatype 
&gt; would be useful. Is it WKB? 
&gt; 
&gt; I‘ve figured out that the "::" (double colon) is casting the result into a 
&gt; geometry data type, so that's one less problem. :) 
&gt; 
&gt; PostGIS 2.1.3 
&gt; 
&gt; Thanks, 
&gt; Jonathan 
&gt; 
&gt; ________________________________ 
&gt; 
&gt; HR Wallingford and its subsidiaries uses faxes and emails for confidential 
&gt; and legally privileged business communications. They do not of themselves 
&gt; create legal commitments. Disclosure to parties other than addressees 
&gt; requires our specific consent. We are not liable for unauthorised 
&gt; disclosures nor reliance upon them. If you have received this message in 
&gt; error please advise us immediately and destroy all copies of it. 
&gt; 
&gt; HR Wallingford Limited 
&gt; Howbery Park, Wallingford, Oxfordshire, OX10 8BA, United Kingdom 
&gt; Registered in England No. 02562099 
&gt; 
&gt; ________________________________ 
&gt; 
&gt; 
&gt; This message has been scanned for viruses by 
&gt; MailControl&lt;<a href="http://www.mailcontrol.com/" \
target="_blank">http://www.mailcontrol.com/</a>&gt;, a service from BlackSpider \
&gt; Technology &gt; 
&gt; Click 
&gt; 
here&lt;<a href="https://www.mailcontrol.com/sr/C5T+ArodN4bGX2PQPOmvUml+xXZX6Ibq!s03C+J" \
target="_blank">https://www.mailcontrol.com/sr/C5T+ArodN4bGX2PQPOmvUml+xXZX6Ibq!s03C+J</a> 
 &gt; WLa6pFyTwcLbQKgTol!QpvrqmvD9w1fK+b76W4Hi4JZPuPA==&gt; to report this 
<div class="HOEnZb"><div class="h5">email as 
&gt; spam. 
&gt; 
&gt; 
&gt; 
&gt; ________________________________ 
&gt; 
&gt; HR Wallingford and its subsidiaries uses faxes and emails for confidential 
&gt; and legally privileged business communications. They do not of themselves 
&gt; create legal commitments. Disclosure to parties other than addressees 
&gt; requires our specific consent. We are not liable for unauthorised 
&gt; disclosures nor reliance upon them. If you have received this message in 
&gt; error please advise us immediately and destroy all copies of it. 
&gt; 
&gt; HR Wallingford Limited 
&gt; Howbery Park, Wallingford, Oxfordshire, OX10 8BA, United Kingdom 
&gt; Registered in England No. 02562099 
&gt; 
&gt; ________________________________ 
 
</div></div>-- 
Vincent Picavet - Gérant Oslandia 
<a href="http://www.oslandia.com" target="_blank">www.oslandia.com</a> 
_______________________________________________ 
postgis-users mailing list 
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a> 
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" \
target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></blockquote></div> </div>

_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread] 