<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from rtf -->
<style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<font face="Arial, sans-serif" size="2">
<div>Hi list,</div>
<div> </div>
<div>( I had a similar discussion using Mapserver 4.10.x and Oracle Spatial 9i in May 2007. But the problems changed using Mapserver 5.2.0 .).</div>
<div> </div>
<div> </div>
<div>The new environmet:</div>
<div>===============</div>
<div>Server SLES10</div>
<div>Mapserver 5.2.0</div>
<div>Oracle OCI - Interface used with Oracle 11-Client-Software</div>
<div> </div>
<div>DB-Server Windows 2xxx</div>
<div>Oracle Spatial 10g</div>
<div> </div>
<div> </div>
<div>The new problem :</div>
<div>==============</div>
<div>Line strings made up of a connected sequence of circular arcs ARE NOT DRAWN. No error message is generated by mapserver, but the objects are not shown in the map.</div>
<div> </div>
<div>Example:</div>
<div>INSERT INTO AX_BES_GEBLINIE (FID,GEOM) VALUES (14196363,mdsys.sdo_geometry(2002,82032,null,mdsys.sdo_elem_info_array(1,2,2),mdsys.sdo_ordinate_array(4512474.1948,5426555.0979,4512473.3318,5426554.2349,4512474.1948,5426553.3719,4512475.0578,5426554.2349,4512474.1948,5426555.0979)));</div>
<div> </div>
<div>(Background: </div>
<div>In my mailing from May 2007 I reported that these Objects are drawn correctly by mapserver. This statement is indeed reproducable correct using mapserver 4.10.x. This is independent from the used oracle version ( 9i or 10g ).</div>
<div>Now, using mapserver 5.2.0 these objects are not drawn anymore. No error message is produced. This is also independent from the used oracle version ( 9i or 10g ). )</div>
<div> </div>
<div>The old problem:</div>
<div>============</div>
<div>Polygons made up of a connected sequence of circular arcs ARE NOT DRAWN. No error message is generated by mapserver, but the objects are not shown in the map.</div>
<div> </div>
<div>(This problem was already reported in May 2007. The behaviour did not change from mapserver 4.10.x to 5.2.0)</div>
<div> </div>
<div>Example:</div>
<div>INSERT INTO AX_GEBAEUDE (FID,GEOM) VALUES (14079065,mdsys.sdo_geometry(2003,82032,null,mdsys.sdo_elem_info_array(1,1003,2),mdsys.sdo_ordinate_array(4505553.2585,5430757.2937,4505551.1659,5430755.2011,4505553.2585,5430753.1085,4505555.3511,5430755.2011,4505553.2585,5430757.2937)));</div>
<div> </div>
<div> </div>
<div>Oracle Documentation:</div>
<div>=================</div>
<div>Reading the Oracle Docs, I think all the objects are correct defined. The geometries are validating by oracle 9i and oracle 10g (Using the st_valid - method, e.g. <font face="Courier" color="#0000F0">SELECT</font><font face="Courier"> a</font><font face="Courier" color="#0000F0">.</font><font face="Courier">GEOM</font><font face="Courier" color="#0000F0">.</font><font face="Courier">ST_IsValid</font><font face="Courier" color="#0000F0">()</font></div>
<div><font face="Courier" color="#0000F0">FROM<font color="#000000"> </font><font color="#808000">ax_bes_geblinie</font><font color="#000000"> a </font>WHERE<font color="#000000"> a</font>.<font color="#000000">fid </font>=<font color="#000000"> </font><font color="#800000">14196363</font>;).</font></div>
<div><font face="Courier" color="#0000F0"> </font></div>
<div><font face="Courier"> </font></div>
<div><font face="Courier"> </font></div>
<div>Does anybody know a solution how to draw these objects with mapserver ?</div>
<div> </div>
<div>greetings</div>
<div>Herbert</div>
<div> </div>
</font>
</body>
</html>