Skip to main content
  • EN

Hi

I am migrating data from an Oracle Spatial database to PostGIS with FME.

One table has a 3D geometry column.

The features are read correctly as 3D from Oracle, in the visual preview graphics view the are shown under "3D".

In the PostGIS table the features are only 2D, if I query the geometry column as text it contains only POINT(2532341.58213 1155047.32385) geometries.

Is there a was to force the writer to write 3D points?

Thanks,

Jean-Marc

 

hmmm well I guess this is so because some of the features have a 'null' Z dimension. PostGIS seems not to accept that. I'll try to set Z=0 if null

Reply


Community Stats

30,126
Posts
114,348
Replies
37,758
Members
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.