[Mapserver-users] Is it possible to display compound polygon with arcs (on Oracle Spatial)

[Jiri Potocny]

Fernando,

thank you for your response, it's again me who uses Oracle SQLLDR utility.
The geometry I reported in the original e-mail looks like this:

2111|"33/1"|2007|
|pt||||1|1005|3|1|2|1|7|2|2|11|2|1|;-549829,25|-1287249,45|-549843,560000000
06|-1287256,9399999999|-549838,90000000002|-1287265,71|-549833,06999999995|-
1287262,6699999999|-549830,54919697763|-1287262,1895820161|-549828,709999999
96|-1287260,3999999999|-549824,58999999997|-1287258,24|-549829,25|-1287249,4
5|:1|

I'm able to determine extents using SDO_TUNE.EXTENT_OF and create
appropriate entry in USER_SDO_GEOM_METADATA table as well as create spatial
indexes (R-tree). Some minor geometry problems were found by
SDO_GEOM.VALIDATE_LAYER, but not in records causing the problem.

If useful, I'll send you other scripts, so that you can easily import these
sample data into Oracle database.

Regards,
Jirka

----- Original Message -----
From: Fernando S.
To: Jiri Potocny ; mapserver-users at lists.gis.umn.edu
Sent: Monday, March 22, 2004 6:08 PM
Subject: Re: [Mapserver-users] Is it possible to display compound polygon
with arcs (on Oracle Spatial)


Hi,
    I already had problems with this type. We (G10-LCA) know this problem
with this type. The real problem it's with arc type. We have some problems
to convert between the way that mapserv draw arcs and the Oracle Spatial
store the arc type. We are stunding the best way to do this convertion.
    I have only two question, what function you use to generate this type?
When I used oracle spatial function SDO_BUFFER I had this problem. And what
do you what to draw?

    Some help you can report me.

==================================================================
Fernando Simon - simon at cttmar.univali.br
==================================================================
DataBase Manager, Mapserver, OracleSpatial and PostGis Developer
G10 - Laboratório de Computaçao Aplicada
MapOracleSpatial developer
http://g10.cttmar.univali.br
==================================================================


Jiri Potocny wrote:
Dear All,

I experienced troubles dsiplaying compound polygon containing arcs stored in
Oracle Spatial, such as:
SDO_GEOMETRY(2007, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1005, 3, 1, 2, 1, 7,
2, 2, 11, 2, 1),
SDO_ORDINATE_ARRAY(-549829,25, -1287249,5, -549843,56, -1287256,9, -549838,9
, -1287265,7, -549833,07, -1287262,7, -549830,55, -1287262,2, -549828,71, -1
287260,4, -549824,59, -1287258,2, -549829,25, -1287249,5))
The map server returns following error:
msDrawMap(): Image handling error. Failed to draw layer named 'parcels'.
msDrawShape(): General error message. Only polygon shapes can be drawn using
a POLYGON layer definition.

Did anybody experienced the same trouble or does anybody know how to treat
such geometries, please?

Regards,
Jirka