<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7653.38">
<TITLE>RE : [mapserver-users] Impossible to draw SDO Geometries fromOraclewhen SDO_GTYPE is 2007 and the interpretation is2(connectivity by arcs : SDO_ELEM_INFO(1, 1003, 2, [...]) )</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Hello Bob,<BR>
<BR>
thanks for your fast response.<BR>
<BR>
These geometries are generated by Oracle : SDO_Buffer function on multipoints geometries.<BR>
<BR>
When i look to the SDO_GEOM example,there are three geometries (polygons) composed of five points with the first point being the same of the last one :<BR>
<BR>
MDSYS.SDO_GEOMETRY(2007,26273,null,<BR>
MDSYS.SDO_ELEM_INFO_ARRAY(<BR>
1,1003,2,<BR>
11,1003,2,<BR>
21,1003,2),<BR>
MDSYS.SDO_ORDINATE_ARRAY(<BR>
<BR>
--Geom 1 :<BR>
83933, 89879.010577196,<BR>
83936.989422804, 89883,<BR>
83933, 89886.989422804,<BR>
83929.010577196, 89883,<BR>
83933, 89879.010577196,<BR>
<BR>
--Geom 2 :<BR>
83345, 89445.010577196,<BR>
83348.989422804, 89449,<BR>
83345, 89452.989422804,<BR>
83341.010577196, 89449,<BR>
83345, 89445.010577196,<BR>
<BR>
--Geom 3 :<BR>
82793, 89490.010577196,<BR>
82796.989422804, 89494,<BR>
82793, 89497.989422804,<BR>
82789.010577196, 89494,<BR>
82793, 89490.010577196<BR>
))<BR>
<BR>
So i suppose that the problem must be something else.<BR>
<BR>
Other thing : If i change manually (but, of course, it's not a solution for the production version) the interpretation of the vertex from 2 to 1 (arcs to lines) Mapserver is able to draw the rectangles.<BR>
<BR>
Thanks,<BR>
<BR>
Julien Collaer<BR>
<BR>
<BR>
-------- Message d'origine--------<BR>
De: Bob Basques [<A HREF="mailto:Bob.Basques@ci.stpaul.mn.us">mailto:Bob.Basques@ci.stpaul.mn.us</A>]<BR>
Date: jeu. 30/07/2009 16:57<BR>
À: Julien Collaer<BR>
Objet : Re: [mapserver-users] Impossible to draw SDO Geometries fromOraclewhen SDO_GTYPE is 2007 and the interpretation is 2(connectivity by arcs : SDO_ELEM_INFO(1, 1003, 2, [...]) )<BR>
<BR>
Julien,<BR>
<BR>
Looking at the SDO description in the Oracle MAN for . . .<BR>
<BR>
<BR>
-----------<BR>
1003 or 2003 2<BR>
<BR>
Polygon made up of a connected sequence of circular arcs that closes on itself. The end point of the last arc is the same as the start point of the first arc.<BR>
<BR>
Each circular arc is described using three coordinates: the start point of the arc, any point on the arc, and the end point of the arc. The coordinates for a point designating the end of one arc and the start of the next arc are not repeated. For example, five coordinates are used to describe a polygon made up of two connected circular arcs. Points 1, 2, and 3 define the first arc, and points 3, 4, and 5 define the second arc. The coordinates for points 1 and 5 must be the same (tolerance is not considered), and point 3 is not repeated.<BR>
-----------<BR>
<BR>
<BR>
It looks like the first and last points need to be the same and your record shows different points for the first and last entries. You may have one extra point on the end as well (I think), or maybe you are just missing the last point on the end . . .<BR>
<BR>
bobb<BR>
<BR>
+<BR>
<BR>
>>> "Julien Collaer" <JC@sodiplan.be> wrote:<BR>
<BR>
<BR>
Hello list,<BR>
<BR>
I'm using Mapserver CGI 5.0.2 (and i'v tried with the 5.4.x too) to render a layer from an Oracle Spatial database (SDO geometries).<BR>
Everything is working fine except for some geometries : multipolygons with interpretation 2 (vertex connected by arcs).<BR>
<BR>
Here is an example of such geometry :<BR>
MDSYS.SDO_GEOMETRY(2007,26273,null,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,2,11,1003,2,21,1003,2),<BR>
MDSYS.SDO_ORDINATE_ARRAY(83933,89879.010577196,<BR>
83936.989422804,89883,<BR>
83933,89886.989422804,<BR>
83929.010577196,89883,<BR>
<BR>
83933,89879.010577196,<BR>
83345,89445.010577196,<BR>
<BR>
83348.989422804,89449,<BR>
83345,89452.989422804,<BR>
<BR>
83341.010577196,89449,<BR>
83345,89445.010577196,<BR>
<BR>
82793,89490.010577196,<BR>
82796.989422804,89494,<BR>
<BR>
82793,89497.989422804,<BR>
82789.010577196,89494,<BR>
<BR>
82793,89490.010577196))<BR>
The layer is rendered but no feature are displayed.<BR>
<BR>
The geomtries are correct (verified with the Oracle MapViewer).<BR>
<BR>
If someone knows a solution for this case it will be very useful...<BR>
<BR>
Thanks in advance,<BR>
<BR>
Julien Collaer<BR>
<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>