Handling 3D geometries with circular arcs in Oracle Spatial via .NET

[Mganjirad]

Hello Oracle Community :)
I am working on integrating 3D spatial data (IFC, CityGML, OBJ, GLTF/GLB, etc.) into Oracle Spatial from a .NET application. I have some questions and challenges:

1. Polygons with arcs – Can a polygon with a circular arc (etype=2) be stored in Oracle Spatial in 3D? From what I understand, arcs are circular only in XY. We can not store 3d geometry with arcs. Is this correct?

2. Solids with curves – Is it possible to store a solid object with curved surfaces directly, or must they be approximated into planar polygons?

3. Data ingestion – What is the recommended approach to map common 3D formats (IFC, CityGML, OBJ, GLTF) into valid SDO_GEOMETRY objects via .NET?

4. Intermediate formats – Is there a suggested exchange/bridge format (e.g., WKT with Z, CityJSON, …) that helps in feeding these models into Oracle?

5. Best practices – Are there any references or examples of recommended pipelines for handling complex 3D data in Oracle Spatial with .NET?

6. In short: I want to confirm the support for arcs and curved solids in 3D, and understand the best practical workflow for importing external 3D formats into Oracle.

Thanks a lot for any guidance

[alexkeh]

@dlapp Can you answer some of these questions about Oracle Spatial?

[dlapp]

Hi Mohammad,
May I suggest you post this inquiry to our forum and will discuss in a thread there.

• Go to https://forums.oracle.com
• Click Developer Community
• Click Oracle Database Discussions
• Post your questions and add the tag spatial

[Mganjirad]

Hi David,

Thank you very much for your guidance.
I have now posted my questions in the Oracle Forum at the following links:
https://forums.oracle.com/ords/apexds/post/workflow-for-ingesting-3d-models-into-oracle-spatial-from-n-9642
https://forums.oracle.com/ords/apexds/post/support-for-3d-curves-polygon-surface-and-solid-in-oracle-s-2431
I hope the discussion there will help clarify these topics.
Currently, I found that there is not much clear documentation available regarding 3D SDO_GEOMETRY objects and the best practices for data ingestion, so your community’s insights will be very valuable.

Thanks again for pointing me in the right direction.

Best regards,
Mohammad

[alexkeh]

Closing this discussion as it has moved to an Oracle discussion forum.