[pgpointcloud] pgpointcloud Digest, Vol 26, Issue 1

[Florent Poux]

Hi Eric,

Thanks for the answer. Yes that will solve the problem hopefully. 
However, I noticed the function

PC_BoundingDiagonalGeometry(patch)


is not installed on my 1.1.0 pgpointcloud extension, thus I cannot yet 
test it. I will do as you suggest to build from master source

Thanks,

Florent Poux

Le 06/06/2017 à 21:00, pgpointcloud-request at lists.osgeo.org a écrit :
> Send pgpointcloud mailing list submissions to
> 	pgpointcloud at lists.osgeo.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> 	https://lists.osgeo.org/mailman/listinfo/pgpointcloud
> or, via email, send a message with subject or body 'help' to
> 	pgpointcloud-request at lists.osgeo.org
>
> You can reach the person managing the list at
> 	pgpointcloud-owner at lists.osgeo.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of pgpointcloud digest..."
>
>
> Today's Topics:
>
>     1. Easiest way to get 3D Bounding Box (Florent Poux)
>     2. Re: Easiest way to get 3D Bounding Box (Eric Lemoine)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 6 Jun 2017 16:49:39 +0200
> From: Florent Poux <fpoux at ulg.ac.be>
> To: pgpointcloud at lists.osgeo.org
> Subject: [pgpointcloud] Easiest way to get 3D Bounding Box
> Message-ID: <8ed177f6-20f6-fe8c-7c7d-e9eaccb18b26 at ulg.ac.be>
> Content-Type: text/plain; charset=utf-8; format=flowed
>
> Dear all,
>
> What is the easiest (and/or most efficient) way to access the 3D
> Bounding Box of a patch ?
> Ideally a SQL statement would provide the best solution.
>
> Also, is there the possibility to use 3D Functions from PostGIS directly
> with patches (for example Box3D, ST_3DUnion, ST_ConvexHull, ...) ? with
> points ?
> I tried so far with no success.
>
> Thanks in advance :) !
>
> Florent Poux
>
>
> ------------------------------
>
> Message: 2
> Date: Tue, 6 Jun 2017 17:06:13 +0200
> From: Eric Lemoine <eric.lemoine at oslandia.com>
> To: pgpointcloud at lists.osgeo.org
> Subject: Re: [pgpointcloud] Easiest way to get 3D Bounding Box
> Message-ID: <e4299bf9-a113-5a46-4061-bfa519d631ca at oslandia.com>
> Content-Type: text/plain; charset="utf-8"
>
> On 06/06/2017 04:49 PM, Florent Poux wrote:
>> Dear all,
>>
>> What is the easiest (and/or most efficient) way to access the 3D
>> Bounding Box of a patch ?
>> Ideally a SQL statement would provide the best solution.
>
> PC_BoundingDiagonalGeometry(PCPatch) returns the 3D bounding diagonal of
> a patch. Is is a PostGIS LineString.
>
> So you can use this to get the box3d:
>
> select BOX3D(PC_BoundingDiagonalGeometry(patch))
>
>
>> Also, is there the possibility to use 3D Functions from PostGIS directly
>> with patches (for example Box3D, ST_3DUnion, ST_ConvexHull, ...) ? with
>> points ?
> Does the above answer?
>
>
> Note that PC_BoundingDiagonalGeometry is available in master, not in the
> v1.0.1 tag.
>
> Hope this helps.
>
>