I am converting Oracle spatial database to postgis. Most of of the spatial data is 2.5d. Meaning we have a Z-coordinate which indicates the depth/height of the element compared to soil level.
Getting the 2D elements is pretty easy: I select the WKT presentation of the element and insert that back into postgis. But, in Oracle the
sdo_util.to_wktgeometry only works on 2D geometries. I can convert geometries to 2D using
sdo_cs.make_2d but only for those elements that have no height at all.
What is the best way to convert the data?
- is WKB exchangeable between databases? (I guess not)
- are there other formats to extract data from oracle in a format postgis understands?