postgis: union of faces of st_dump

المشرف العام

Administrator
طاقم الإدارة
I am trying to make a web application that renders 3D buildings (LoD1). I have a PostGIS (2.2.1dev) database which contains the 2D geometry of the buildings and the height. I used st_extrude to make a 3D geometry out of it.

The problem is that I end up with a PolyhedralSurface, while I need a MultiPolygon. I used st_dump to split up my polyhedralSurface into its faces (floor, roof, walls). I end up with a table that has an id-column and a geometry-column.

For each building, I now have multiple rows in the table. The geometry column is of the form:

({1}, 01030000A8...).

The {i} part is the identifier for which face of my building it is, the second part is the actual geometry of this face.

How can I join the multiple rows for one building together and end up with a MultiPolygon?



أكثر...
 
أعلى