[postgis-users] The pcpatch datatype

[Vincent Picavet - ML]

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