Question

PostGIS writer looses Z dimension when writing 3D points

+1

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

+1

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

1 reply