[postgis-users] TR: Polygons to Polyhedrons

GUSTIN, Arthur arthur.gustin at sogeti.com
Thu Oct 20 00:50:31 PDT 2016

Hello postgis users, I'm a new-comer in this community !
I use postgresql/postgis + django/geodjango in a project. I need to be able to transform dimensions to the upper dimension, merge objects, etc...

Currently, I'm able to :

-        Transform 3D POINTS to 3D LINE with ST_MakeLine

-        Transform 3D LINE to 3D POLYGON with ST_Polygon

However, I did not find any function like ST_MakePolyhedron. While reading the documentation, I found ST_Dump that perform the opposite of what I want.
I guess I'm able to create a polyhedron in Python, retrieving data from db, parse the text representation, fill a POLYHEDRALSURFACE(((...))) and then reinsert into the database, but I'd prefer a simplest way.
This problem is not easy, because polygons have to be well-oriented. Also the function ST_IsValid does not work for POLYHEDRALSURFACE (ERROR:  ST_MakeValid: unsupported geometry type PolyhedralSurface)

Does anyone has already faced this problem ? Any plan for this ?

[Arthur Gustin]
This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20161020/1d216197/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 11900 bytes
Desc: image001.jpg
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20161020/1d216197/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Arthur Gustin.vcf
Type: text/x-vcard
Size: 16998 bytes
Desc: Arthur Gustin.vcf
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20161020/1d216197/attachment.vcf>

More information about the postgis-users mailing list