Skip to main content
Question

3D geometry to Oracle

  • 20 February 2013
  • 2 replies
  • 14 views

Hello all.   I am reading a CAD file with 2d geometry, however in a certain moment I force it to 3d  geometry with 0 as z value, after that, I am trying to write to Oracle Spatial Object, but what returns is - The geometry type `3002' is not understood by the Oracle Spatial writer . Would you know what is happens? There is a relation with the version 11g?   Thanks in Advance.
3D support for this type of feature was introduced in Oracle 11.1. Is this the version of Oracle that you are attempting to load? http://docs.oracle.com/cd/B28359_01/appdev.111/b28400/sdo_intro.htm

Max - Are you trying to load 3D Solids or 3D Geometry? In Oracle 11.1 solid support was added as David says, but 3D Geometry was supported in versions before that. 

SDO_GTYPE 3002 is a 3D Line, 3008 is a Solid

 

  • How are you converting to 3D - with 3DForcer?
  • Which version of FME and which version of Oracle?
  • What is the setting for dimension in the writer Format Parameters?
  • What is the value from Oracle USER_SDO_GEOM_METADATA for this table?

 

 


Reply