points in a multipolygon set from oraclespatial

[GIRAUD Pierre]

I isolated more precisely the sort of shapes it was crashing on.

Here are the details on an sample object that is responsible :

----------------------
SDO_GEOMETRY(*2007*, NULL, NULL, SDO_ELEM_INFO_ARRAY(*1, 2003, 1, 11,
1003, 1*), SDO_ORDINATE_ARRAY(58372002, 13596564, 58372473, 13596822,
58372131, 1359 7448, 58371680, 13597191, 58372002, 13596564, 58371824,
13596202, 58372312, 13596423, 58375405, 13599264, 58375545, 13599692,
58374401, 13601451, 5837 4241, 13601357, 58374256, 13601268, 58374285,
13600988, 58374288, 13600705, 58374266, 13600424, 58374219, 13600146,
58374147, 13599873, 58374051, 1359 9607, 58373685, 13599104, 58373443,
13598896, 58373292, 13598779, 58372510, 13598194, 58372119, 13597914,
58371517, 13597497, 58371824, 13596202))

aneto:~$ ogrinfo OCI:pierre/xbe9a51h at 192.168.226.149:1521/orcl -sql
"SELECT GEOMETRY, IDENT FROM REF_PARCELLE a WHERE a.GID = 11758"
INFO: Open of `OCI:pierre/xbe9a51h at 192.168.226.149:1521/orcl'
using driver `OCI' successful.

Layer name: SELECT GEOMETRY, IDENT FROM REF_PARCELLE a WHERE a.GID = 11758
Geometry: Unknown (any)
Segmentation fault
-------------------------------
In opposite, other multipolygons don't cause any troubles :

---------------------------------------
SDO_GEOMETRY(*2007*, NULL, NULL, SDO_ELEM_INFO_ARRAY(*1, 1003, 1, 17,
1003, 1*), SDO_ORDINATE_ARRAY(58463050, 13756514, 58463828, 13756121,
58465357, 1375 9194, 58462596, 13760943, 58462133, 13760742, 58461491,
13759405, 58463896, 13758201, 58463050, 13756514, 58464405, 13759663,
58464032, 13758872, 5846 3131, 13759330, 58463500, 13760121, 58464405,
13759663))

aneto:/etc/apache# ogrinfo OCI:pierre/xbe9a51h at 192.168.226.149:1521/orcl
-sql "SELECT GEOMETRY, IDENT FROM REF_PARCELLE a WHERE a.GID = 9789"
INFO: Open of `OCI:pierre/xbe9a51h at 192.168.226.149:1521/orcl'
using driver `OCI' successful.

Layer name: SELECT GEOMETRY, IDENT FROM REF_PARCELLE a WHERE a.GID = 9789
Geometry: Unknown (any)
Feature Count: 1
Extent: (58461491.000000, 13756121.000000) - (58465357.000000,
13760943.000000)
Layer SRS WKT:
(unknown)
IDENT: String (72.0)
OGRFeature(SELECT GEOMETRY, IDENT FROM REF_PARCELLE a WHERE a.GID = 9789):0
  IDENT (String) = TK396000AD0353C
  MULTIPOLYGON (((58463050 13756514,58463828 13756121,58465357
13759194,58462596 13760943,58462133 13760742,58461491 13759405,58463896
13758201,58463050 13756514)),((58464405 13759663,58464032
13758872,58463131 13759330,58463500 13760121,58464405 13759663)))
------------------------------

I'm now leaving office, but I began to prepare sql commands to create
trable entries to test this.

Thanks for all.

Pierre GIRAUD


Frank Warmerdam wrote:

> GIRAUD Pierre wrote:
>
>> Hi list,
>>
>> Today, I'm in front of a particular problem. For a customer, I need to
>> render oraclespatial data.
>> In the database, I have shapes with a '2007' SDO_GTYPE, that says
>> multipolygons. Hopelessly, in the SDO_ELEM_INFO_ARRAY, including the
>> polygons (2003), some points (1003) can be found. Curious for a
>> multipolygon, and you might want to say that it'd better be a Collection
>> (2004) ! But I can't modify data.
>>
>> The problem is that if define my layer with an oraclespatial
>> connectiontype, the layer is rendered. On the other hand, with an
>> OGR/OCI connectiontype, mapserver crashes.
>
>
> Pierre,
>
> I'm not readily able to work on Oracle support just now.  My NT partition
> with Oracle has become inaccessable due to an unfortunate "install"
> problem.
>
> My understanding from the code is that multipolygons should work in OGRs
> Oracle driver, but I am not sure how well tested it is.   Does ogrinfo
> also crash against the layer in question?  If so, I would suggest you
> submit a detailed bug including a snippet of SQL sufficient to create
> a one record table that will demonstrate the problem.
>
> That way I can fix it at some point when I have access to Oracle again.
>
> Best regards,
> --
> ---------------------------------------+--------------------------------------
>
> I set the clouds in motion - turn up   | Frank Warmerdam,
> warmerdam at pobox.com
> light and sound - activate the windows | http://pobox.com/~warmerdam
> and watch the world go round - Rush    | Geospatial Programmer for Rent