[postgis-users] The pcpatch datatype

[Rémi Cura]

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 at 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 at lists.osgeo.org
> > [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Stephen V.
> > Mather Sent: Friday, February 13, 2015 1:50 PM
> > To: 'postgis-users at 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 at lists.osgeo.org<mailto:
> postgis-users-bounces at lists.os
> > geo.org>
> > <postgis-users-bounces at lists.osgeo.org<mailto:
> postgis-users-bounces at lists.o
> > sgeo.org>> on behalf of Jonathan Moules
> > <J.Moules at hrwallingford.com<mailto:J.Moules at hrwallingford.com>> Sent:
> > Friday, February 13, 2015 7:46 AM
> > To: 'postgis-users at 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 at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150213/22ba6a76/attachment.html>