TR: Polygons to Polyhedrons

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

TR: Polygons to Polyhedrons

GUSTIN, Arthur

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.
postgis-users mailing list
[hidden email]

Arthur Gustin.vcf (22K) Download Attachment