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 <[email protected]>: > 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: [email protected] > > [mailto:[email protected]] On Behalf Of Stephen V. > > Mather Sent: Friday, February 13, 2015 1:50 PM > > To: '[email protected]' > > 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: > > [email protected]<mailto: > [email protected] > > geo.org> > > <[email protected]<mailto: > [email protected] > > sgeo.org>> on behalf of Jonathan Moules > > <[email protected]<mailto:[email protected]>> Sent: > > Friday, February 13, 2015 7:46 AM > > To: '[email protected]' > > 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 > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
![http://sig.cmparks.net/cmp-ms-90x122.png]Stephen](http://sig.cmparks.net/cmp-ms-90x122.png]Stephen){kind=link}