[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