[gdal-dev] ogr2ogr OCI to shape : Multipolygon (Oracle Gtype = 7 ) not supported ?

[Rémy GOURRAT]

Hi,

I try to export in shape a buffer from union of lines.

I validated this query in Sqldevelopper before use it with Ogr :
"select '1' as "FID",sdo_geom.sdo_buffer(SDO_AGGR_CONCAT_LINES(sdo_util.rectify_geometry(GEOMETRY,0.001) ),50,0.001) as geometry from assc"

After created this geometry in oracle temporary table, I can display it without issue in Autocad Map with Fdo Oracle Provider.

With ogr2ogr, Shape is created but when I open with Qgis i see 1 attribute line (it's Ok) but i don't see geometry on the map and the shape size is only 1ko.

This is my command line :

ogr2ogr -f "ESRI Shapefile" c:\temp\ASSC.shp OCI:[username]/[password]@[instance] -sql "select '1' as "FID",sdo_geom.sdo_buffer(SDO_AGGR_CONCAT_LINES(sdo_util.rectify_geometry(GEOMETRY,0.001) ),50,0.001) as geometry from assc" -skipfailures -overwrite -dim 2

it's running well and no issue in debug mode :
OGR2OGR: 1 features written in layer 'ASSC'
OCI: 1 features read on layer 'select 'EU01'...

If I don't use SDO_AGGR_CONCAT_LINES in my query wich create the unique multi-polygon (Oracle Gtype = 7), the shape is created too and I can see more 2000 buffer polygon geometry (Oracle Gtype = 3) in Qgis.

ogr2ogr -f "ESRI Shapefile" c:\temp\ASSC.shp OCI:[username]/[password]@[instance] -sql "select '1' as "FID",sdo_geom.sdo_buffer(sdo_util.rectify_geometry(GEOMETRY,0.001),50,0.001) as geometry from assc" -skipfailures -overwrite -dim 2

So I ask me the question is there a issue with ogr2ogr with Oracle Multipolygon (Gtype = 7) ?

Is there a work around ?

Thanks

Rémy
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20140715/3df92975/attachment.html>