# [postgis-users] Convert Box3D to TIN geometries

Tom Kazimiers tom at voodoo-arts.net
Tue Jul 24 06:09:38 PDT 2018

```That's nice indeed, thanks for the update!

I suppose there is no way to convert a Box3D to a TIN geometry without SFCGAL in a similar fashion? Specifiying vertices and triangles using ST_{X,Y,Z}{Min,Max} is no problem, it only gets pretty verbose and we can't add SFCGAL to our dependencies at the moment.

Cheers,
Tom

On July 24, 2018 10:20:09 AM UTC, Felix Kunde <felix-kunde at gmx.de> wrote:
>I was hoping for a news like this. Great. Thanks!
>
>
>Gesendet: Montag, 23. Juli 2018 um 20:17 Uhr
>Von: "Darafei \"Komяpa\" Praliaskouski" <me at komzpa.net>
>An: "PostGIS Users Discussion" <postgis-users at lists.osgeo.org>
>Betreff: Re: [postgis-users] Convert Box3D to TIN geometries
>
>Hi Felix,
>
>This was fixed in PostGIS 2.5.
>
>There your query ends up with geometry like this:
>
> GEOMETRYCOLLECTION Z (TIN Z (((0 0 0,0 1 0,1 1 0,0 0 0)),((1 0 0,0 0
>0,1 1 0,1 0 0)),((0 1 1,1 0 1,1 1 1,0 1 1)),((0 1 1,0 0 1,1 0 1,0 1
>1)),((0 0 0,0 0 1,0 1 1,0 0 0)),((0 1 0,0 0 0,0 1 1,0 1 0)),((1 0 1,1 1
>0,1 1 1,1 0 1)),((1 0 1,1 0 0,1 1 0,1 0 1)),((0 0 1,1 0 0,1 0 1,0 0
>1)),(
>(0 0 1,0 0 0,1 0 0,0 0 1)),((0 1 0,0 1 1,1 1 1,0 1 0)),((1 1 0,0 1 0,1
>1 1,1 1 0))))
>
>ср, 18 июл. 2018 г. в 11:21, Felix Kunde
><felix-kunde at gmx.de[mailto:felix-kunde at gmx.de]>:Hi,
>thought that's easy to do with the postgis_sfcgal extension, but no:
>SELECT ST_Tesselate('BOX3D(0 0 0,1 1 1)'::box3d::geometry));
>
>ERROR: Solid is invalid : PolyhedralSurface (shell) 0 is invalid: not
>connected : SOLID((((0/1 0/1 0/1,0/1 1/1 0/1,1/1 1/1 0/1,1/1 0/1
>0/1,0/1 0/1 0/1)),((0/1 0/1 1/1,0/1 1/1 1/1,1/1 1/1 1/1,1/1 0/1 1/1,0/1
>0/1 1/1)),((0/1 0/1 0/1,0/1 1/1 0/1,0/1 1/1 1/1,0/1 0/1
>SQL Status:XX000
>
>The polygons are not in the right order :-/
>Also tried dumping and delaunay triangulation but yet not solution.
>Anyone else?
>
>Cheers,
>Felix
>
>
>
>Gesendet: Dienstag, 17. Juli 2018 um 20:04 Uhr
>Von: "Tom Kazimiers" <tom at voodoo-arts.net[mailto:tom at voodoo-arts.net]>
>An: postgis-users at lists.osgeo.org[mailto:postgis-users at lists.osgeo.org]
>Betreff: [postgis-users] Convert Box3D to TIN geometries
>Hi all,
>
>I need to convert a lot of Box3D geometries to TIN geometries. Is there
>a way in PostGIS to do this without specifiying each triangle and
>vertex for the new TINs explicitly? Idealy, I would just be able to
>issue a simple update statement without needing to think about vertex
>order and triangle order.
>
>Thanks,
>Tom_______________________________________________ postgis-users
>mailing list
>postgis-users at lists.osgeo.org[mailto:postgis-users at lists.osgeo.org]
>https://lists.osgeo.org/mailman/listinfo/postgis-users
>_______________________________________________
>postgis-users mailing list
>postgis-users at lists.osgeo.org[mailto:postgis-users at lists.osgeo.org]
>https://lists.osgeo.org/mailman/listinfo/postgis-users--
>
>Support me:
>http://patreon.com/komzpa[http://patreon.com/komzpa]_______________________________________________
>postgis-users mailing list postgis-users at lists.osgeo.org
>https://lists.osgeo.org/mailman/listinfo/postgis-users[https://lists.osgeo.org/mailman/listinfo/postgis-users]
>_______________________________________________
>postgis-users mailing list
>postgis-users at lists.osgeo.org
>https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20180724/1c2cbb24/attachment.html>
```