[postgis-users] Convert Box3D to TIN geometries

Darafei "Komяpa" Praliaskouski me at komzpa.net
Mon Jul 23 11:17:29 PDT 2018


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>:

> 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>
> An: 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
> 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

-- 
Darafei Praliaskouski
Support me: http://patreon.com/komzpa
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20180723/514675a8/attachment.html>


More information about the postgis-users mailing list