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

[Gavin Cramer]

Hello, Bruno.  There is an issue here with the Autodesk Oracle Provider.  I filed a defect report for this, including your email message.  If you have an Autodesk tech support contact, you can use that channel to track the issue.

Thanx
Gavin


-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Bruno Scott
Sent: Friday, May 23, 2008 9:18 AM
To: fdo-users at lists.osgeo.org
Subject: [fdo-users] Autodesk.Oracle provider defect on MultiPolygon


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.

_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users