[fdo-users] Autodesk.Oracle provider defect on MultiPolygon

Bruno Scott bscott at geomapgis.com
Fri May 23 09:17:47 EDT 2008


i'm trying to insert this type of geometry in oracle using the
Autodesk.Oracle.3.3 provider
GeomFromText('MULTIPOLYGON XY ((( 80 170  , 85 170  , 85 165  , 80 165  , 80
170 )),(( 85 165  , 85 160  , 90 160  , 90 165  , 85 165 )))')

This is what we find in oracle after the insert is done:
SDO_GEOMETRY(2007, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3, 5, 1003, 1),
SDO_ORDINATE_ARRAY(80, 170, 85, 165, 85, 165, 85, 160, 90, 160, 90, 165, 85,
165))

it should be something like this
SDO_GEOMETRY(2007, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3, 11, 1003, 1),
SDO_ORDINATE_ARRAY(80, 170, 85, 170  ,85, 165, 80, 165 ,80, 170, 85, 165
,85, 160, 90, 160, 90, 165, 85, 165 ))



This same syntax works perfectly with the MySQL,SDF and PostGIS providers
Whit the SHP provider it failes, but it is normal because the shape format
does not support multi-polygon
But Oracle does.

I know of a workaround, in my application i have included a special case
if(provider is SHP or Autodesk.Oracle) then
  Transform multiPolygon to Polygon

But it is not very clean programming

Bruno Scott

-- 
View this message in context: http://www.nabble.com/Autodesk.Oracle-provider-defect-on-MultiPolygon-tp17425411p17425411.html
Sent from the FDO Users mailing list archive at Nabble.com.



More information about the fdo-users mailing list