Skip to main content
Question

PostGIS writer looses Z dimension when writing 3D points

  • June 21, 2022
  • 1 reply
  • 51 views

Forum|alt.badge.img+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 reply

Forum|alt.badge.img+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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings