Skip to main content
Question

How to transform complex geometries to a single format - and save them as polyhedralSurface in postGIS

E

I have several IFC files, each one has its own structure.

I managed to save some of the data as a polyhedralSurfaceZ in postGIS, but some of the data structure is more complicated, and saves as a geometry collection of several types.

 

I only managed to save it to postGIS when the geom type is the general "GeometryZ" but then I cannot used the indexing power of postGIS and queries take forever, and some don't run at all ( like st_volume)

 

is there a way to transform the geometry collections to a solid that will be saved as polyhedralSurfaceZ?

 

example of such data:

GEOMETRYCOLLECTION Z (CURVEPOLYGON Z (COMPOUNDCURVE Z ((....

some also have PolygonZ , some have POLYHEDRALSURFACE Z

 

 

 

2 replies

virtualcitymatt
Celebrity
Forum|alt.badge.img+35

I'm not exactly sure what you want, however, perhaps I can help

 

You probably wont be able to convert a collection into a Solid but you should be able to extract each solid from the collection(s).

 

A few tools which might help:

  • AggregateFilter (can be used to find aggregates (and maybe? collections)
  • GeometryFilter (in FME 2022 there are lots of options to get specific and can also be used to get rid of <null> geometries)
  • GeometryPartExtractor (Can be used to extract BRep solids directly out of Aggregates/Collections) super helpful
  • GeometryCoercer (Can be used to go from CompositeSurface to BRepSolid or Mesh)

 

E
virtualcitymatt wrote:

I'm not exactly sure what you want, however, perhaps I can help

 

You probably wont be able to convert a collection into a Solid but you should be able to extract each solid from the collection(s).

 

A few tools which might help:

  • AggregateFilter (can be used to find aggregates (and maybe? collections)
  • GeometryFilter (in FME 2022 there are lots of options to get specific and can also be used to get rid of <null> geometries)
  • GeometryPartExtractor (Can be used to extract BRep solids directly out of Aggregates/Collections) super helpful
  • GeometryCoercer (Can be used to go from CompositeSurface to BRepSolid or Mesh)

 

thanks, I will try them

Reply


Helpful Members This Week

Community Stats

31,319
Posts
118,816
Replies
38,946
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.