[pgpointcloud] Easiest way to get 3D Bounding Box

[Eric Lemoine]

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.


-- 
Éric Lemoine
Oslandia
+33 1 86 95 95 55
-------------- next part --------------
A non-text attachment was scrubbed...
Name: eric_lemoine.vcf
Type: text/x-vcard
Size: 209 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/pgpointcloud/attachments/20170606/42d2545a/attachment.vcf>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 488 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/pgpointcloud/attachments/20170606/42d2545a/attachment.sig>