Skip to main content
  • EN

Hello,

I am trying to write 3D Geometries (Points and Linestrings) to an Oracle-Database (21c Express). In the process all z-Coordinates get lost and SDO_GTYPE is wrongly written as 2001 or 2002 (2-Dimensional Geometries) instead of 3001 and 3002.

Multiple Geometries are entering the writer as an aggregate (example below).
 

 

Apart from the z-Coordinate missing these are written and interpreted correctly when writing to Oracle. I have checked the “Contains Z Ordinate” Option in the Writer-Parameters.

Does anyone have anymore ideas what I could try?

To answer this myself … this was solved by editing the Metadata in user_sdo_geom_metadata to explicitly contain 3D-Geometries.

Reply


Community Stats

31,358
Posts
118,954
Replies
38,988
Members

Latest FME

Terms & ConditionsCookie 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.