We're holding geodata in an Orcale database (11g) with spatial extension. I want to unload specific polygons and convert them into Shape for further local processing.
The table where I'm unloading from holds polygons/multipolygons: Oracle Spatial GeomTypes are 4003 and 4007 (4D-Polygon and 4D-Multipolygon - third and fourth axis are not used however).
For unloading and conversion I use this command within a python-script:
ogr2ogr.main(["", "-f", "ESRI Shapefile", result_path + query_result, connection_params,"-nlt", "MULTIPOLYGON", "-sql", the_sql_query_here])
Connection and convertion only seems to work for polygons with GeomType 4003 however:
Multipartpolygons or polygons with wholes (GeomType 4007) are completely ignored (white gaps). I already tried to rerun the command above with
PROMOTE_TO_MULTI instead of
MULTIPOLYGON. No change in the result though.
Any known caveats or workarounds regarding this problem?
My GDAL is v2.1.2
As requested in the comments I publish the geom-content of an object whose geometry couldn't be loaded:
Corresponding real life object is multipart and looks like this:
While the geometry doesn't get converted, the objects non-spatial attributes and values get fully converted to shape .