AW: [UMN_MAPSERVER-USERS] No drawing of certain polygon rings stroed in Oracle Spatial

"Schönhammer, Herbert" Schoenhammer.Herbert at REGENSBURG.DE
Thu May 3 08:49:31 EDT 2007


Hi Fernando,

now i found the time to answer your reply. SORRY  ;-)

Until now, I did not write the question into the Oracle Spatial forum. I will do it after giving you some new examples. (This is not as important for me as the examples for you, because the "wrong" geometries are drawn correctly by mapserver ! Only some of the correct stored geometries are not drawn !)

1.) A "circle" which is not drawn, and a error is reported
==========================================================
(Table=ax_gebaeude, Fid=14083066, only for me to find the objects again !)

SDO_GEOMETRY(2003, 82032, NULL, SDO_ELEM_INFO_ARRAY(1, 5, 1, 1, 2, 2), SDO_ORDINATE_ARRAY(4512485,81, 5426487,22, 4512491,74, 5426479,73, 4512485,28, 5426472,69, 4512477,01, 5426480,27, 4512485,81, 5426487,22))

The geometry validates (SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(c.geom, 0.005)), but the use of "5" as an SDO_ETYPE is discouraged by Oracle. So the following (mapserver) error message is okay:

- <ServiceExceptionReport version="1.1.1">
  <ServiceException>msDrawMap(): Image handling error. Failed to draw layer named 'stgk_gebaeude_orcl'. msDrawShape(): General error message. Only polygon shapes can be drawn using a POLYGON layer definition.</ServiceException> 
  </ServiceExceptionReport>

2.) Some "circles" which are drawn correctly by mapserver
=========================================================
(Table=ax_bes_geblinie, Fid=14196364 - 14196267)

SDO_GEOMETRY(2002, 82032, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 2), SDO_ORDINATE_ARRAY(4512475,44, 5426583,82, 4512473,81, 5426582,19, 4512475,44, 5426580,55, 4512477,08, 5426582,19, 4512475,44, 5426583,82))
SDO_GEOMETRY(2002, 82032, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 2), SDO_ORDINATE_ARRAY(4512475,24, 5426579,96, 4512473,6, 5426578,32, 4512475,24, 5426576,67, 4512476,88, 5426578,32, 4512475,24, 5426579,96))
SDO_GEOMETRY(2002, 82032, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 2), SDO_ORDINATE_ARRAY(4512474,96, 5426569,9, 4512474,1, 5426569,04, 4512474,96, 5426568,19, 4512475,82, 5426569,04, 4512474,96, 5426569,9))
SDO_GEOMETRY(2002, 82032, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 2), SDO_ORDINATE_ARRAY(4512475,08, 5426574,78, 4512474,24, 5426573,95, 4512475,08, 5426573,11, 4512475,92, 5426573,95, 4512475,08, 5426574,78))

These "circles" are made up of a connected sequence of circular arcs (SDO_ETYPE=2 AND SDO_INTERPRETATION=2). All "circles" are validating. Mapserver draws them correctly. 

"LINESTRING made up of a connected sequence of circular arcs." (Oracle Spatial 9i Documentation)

3.) Some "circles" which are validating by Oracle Spatial, not drawn by mapserver, no error message is generated
================================================================================================================
(Table=ax_gebaeude, Fid=14079065, 14079126, 14079128, 50153783)

The statement:

Select fid, geom, SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(geom, 0.005)
FROM ax_gebaeude 
WHERE  Fid=14079065
or fid=14079126
or fid=14079128
or fid=50153783;

The result:

  14079065
SDO_GEOMETRY(2003, 82032, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 2), SDO_ORDINATE_ARRAY(4505553,26, 5430757,29, 4505551,17, 5430755,2, 4505553,26, 5430753,11, 4505555,35, 5430755,2, 4505553,26, 5430757,29))
TRUE

  14079126
SDO_GEOMETRY(2003, 82032, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 2), SDO_ORDINATE_ARRAY(4505611,03, 5430848,55, 4505611,03, 5430845,19, 4505614,39, 5430845,19, 4505614,39, 5430848,55, 4505611,03, 5430848,55))
TRUE

  14079128
SDO_GEOMETRY(2003, 82032, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 2), SDO_ORDINATE_ARRAY(4505615,64, 5430849,9, 4505615,64, 5430847,3, 4505618,24, 5430847,3, 4505618,24, 5430849,9, 4505615,64, 5430849,9))
TRUE

  50153783
SDO_GEOMETRY(2003, 82032, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 2), SDO_ORDINATE_ARRAY(4505553,29, 5430751,3, 4505555,38, 5430749,21, 4505557,47, 5430751,3, 4505555,38, 5430753,39, 4505553,29, 5430751,3))
TRUE

The geometries are validating. No error is reported. The geometries are NOT drawn ba mapserver. 

I think, the combination of SDO_ETYPE=1003 and SDO_INTERPRETATION=2 is valid: "POLYGON made up of a connected sequence of circular arcs that closes on itself.  ....) (Oracle Spatial 9i Documentation)
That is just the description of the picture which should be drawn !!!

Note: COMPOUND POLYGONS with circular arcs are drawn
====================================================
If there is a COMPOUND POLYGON with some vertices connected by straight line segments and some by circular arcs, this PLOYGON is drawn correctly. The geometry validates by Oracle Spatial. 

Statement:

Select fid, geom, SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(geom, 0.005)
FROM ax_gebaeude 
WHERE  Fid=14080250;

Result:

  14080250
SDO_GEOMETRY(2003, 82032, NULL, SDO_ELEM_INFO_ARRAY(1, 1005, 2, 1, 2, 2, 13, 2, 1), SDO_ORDINATE_ARRAY(4507524,52, 5430348,32, 4507526,76, 5430348,68, 4507528,88, 5430349,49, 4507531,16, 5430351,04, 4507532,99, 5430353,11, 4507534,27, 5430355,63, 4507534,86, 5430358,4, 4507537,64, 5430358,38, 4507537,65, 5430358,56, 4507537,71, 5430358,56, 4507537,72, 5430366,92, 4507538,53, 5430366,92, 4507538,6, 5430382,06, 4507535,31, 5430382,07, 4507479,2, 5430382,24, 4507479,18, 5430374,96, 4507479,16, 5430366,28, 4507478,79, 5430366,28, 4507478,73, 5430340,61, 4507484,01, 5430340,91, 4507505,57, 5430342,15, 4507524,53, 5430343,3, 4507524,52, 5430348,32))
TRUE



Conclusio:
==========

LINESTRING's making a connected sequence of circular arcs are drawn, even if they are closing on themselves.

If a POLYGON made up ONLY of circular arcs AND it CLOSES ON ITSELF, it is NOT drawn. 

If there are arcs in a COMPOUND POLYGON, the whole Polygon is drawn correct.

All geometry-types are validating by Oracle Spatial, the used combination of SDO_ETYPE and SDO_INTERPRETATION is okay.

I really think, that this a problem of mapserver's Oracle-driver !

Best regards
Herbert






>-----Ursprüngliche Nachricht-----
>Von: Fernando Simon [mailto:fsimon at univali.br] 
>Gesendet: Mittwoch, 25. April 2007 16:02
>An: Schönhammer, Herbert
>Betreff: Re: [UMN_MAPSERVER-USERS] AW: [UMN_MAPSERVER-USERS] 
>No drawing of certain polygon rings stroed in Oracle Spatial
>
>
>Hi Hebert,
>    Sorry again for the delay. Just this morning I could reply 
>some e-mails.
>    The validation returned true, so for the Oracle Spatial core the 
>object it's right and the Mapserver needs to draw it. But the 
>strange is 
>that in the official documentation these SDO_GTYPE, SDO_ETYPE and 
>SDO_INTERPRETATION are not allowed. You can try to write in the Oracle 
>Spatial forum in the Oracle site (otn.oracle.com) to ask about this 
>strange values, the guys that reply there are the developers 
>of Spatial.
>     You can use the SDO_ARC_DENSIFY to change the object, but will be 
>an approximation for your arc. The parameters reflect the 
>options of the 
>approximation, you need to conjugate the arc_tolerance with 
>the unit of 
>your SRID. You can see the the unit of your SRID in the MDSYS.CS_SRS 
>table (describe in the 5.4.1 chapter of the Oracle Spatil 9i 
>reference). 
>Remember to use both in the test, the arc_tolerance and unit.
>     Another way is just to change the SDO_ETYPE to reflect the 
>documentation, in the first e-mail you told that the same object (just 
>changing the ETYPE) was draw without problem. You can create a trigger 
>that for every object with the wrong ETYPE and INTERPRETATION 
>you change 
>to the correct one. Of course that it is not the solution, just a 
>workaround.
>    To help me to find the core of the problem in Mapserver driver you 
>need to provide some examples (5 objects is fine) of the 
>objects that is 
>not draw. In the first e-mail that you sent (15/03/2007) the first 
>object (1, 1003, 2) is not draw by Mapserver, right? The other 
>are draw 
>correctly?
>    Best regards.
>
>Fernando Simon
>
>
>Schönhammer, Herbert wrote:
>> Hi Fernando,
>>
>> I'm in hurry, but a short report of my results:
>>
>> 1.
>> ==
>> Yes, the validate function returns true !
>>
>> 2.
>> ==
>> After using SDO_GEOM.SDO_ARC_DENSIFY geometries with 
>SDO_ELEM_INFO (1;1003;1 ...) are built. These geometries are 
>drawn by mapserver. (Of Course; now these geometries are 
>simple polygons, connected by stright lines.)
>>
>> 3.
>> ==
>> I really don't understand the 'arc_tolerance= xx' parameter 
>of this function. Chosing them very big, smaller, .... 
>smallest, ... I NEVER could create a simpler object, which is 
>an approximation of the original geometry. (A polygon with 5 
>edges is NO approximation of a circle). So I have to play with 
>this command. (I don't understand the dependencies of the 
>tolerance-value in the diminfo-array of the layer at this 
>point of time )
>>
>> regards
>> Herbert
>>
>>
>>
>>   
>>> -----Ursprüngliche Nachricht-----
>>> Von: Fernando Simon [mailto:fsimon at univali.br] 
>>> Gesendet: Mittwoch, 18. April 2007 13:35
>>> An: Schönhammer, Herbert
>>> Betreff: Re: AW: AW: [UMN_MAPSERVER-USERS] No drawing of 
>>> certain polygon rings stroed in Oracle Spatial
>>>
>>>
>>> Hi Hebert,
>>>   Sorry for the delay to send some news. In the last week I was 
>>> thinking about your problem, the validate function return 
>true, right? 
>>> Did you already try to use, and validate, the objects in 
>>> another Oracle 
>>> versions (9i, 10g)?
>>>   Another thing is try to test the function 
>>> SDO_GEOM.SDO_ARC_DENSIFY to 
>>> convert this objects to a more simple object. Can you try 
>this to test?
>>>   Sorry again for the delay.
>>>
>>> Fernando Simon
>>>
>>> Schönhammer, Herbert wrote:
>>>     
>>>> Hi Fernando,
>>>>
>>>> have you got some time for searching a solution for "my" problem ?
>>>>
>>>> Actual i have to build a WMS using Mapserver to support 
>>>>       
>>> another project in my work. So i Don't have a lot of time anymore.
>>>     
>>>> I will be glad of any kind of solution or tipp or workaraound.
>>>>
>>>> Main problem: the application used for generating and 
>>>>       
>>> editing the data in the oracle database (Autodesk Topobase 3) 
>>> is storing circles as described in my mails. About 20 
>>> employees are working every day with this database. So i'm not 
>>> able to make a copy of the database and make some workarounds, 
>>> because i have to deliver the actual data !
>>>     
>>>> Thanks very much,
>>>>
>>>> regards
>>>> Herbert
>>>>
>>>>   
>>>>       
>>>>> -----Ursprüngliche Nachricht-----
>>>>> Von: Fernando Simon [mailto:fsimon at univali.br] 
>>>>> Gesendet: Montag, 2. April 2007 14:05
>>>>> An: Schönhammer, Herbert
>>>>> Betreff: Re: AW: [UMN_MAPSERVER-USERS] No drawing of certain 
>>>>> polygon rings stroed in Oracle Spatial
>>>>>
>>>>>
>>>>> Hi Schönhamer,
>>>>>    Sorry for the delay to reply some news from Brazil.
>>>>>    I didn't have much time to look about this issue, the 
>>>>>         
>>> Master was a 
>>>     
>>>>> little complicated last week. I already started to 
>investigate the 
>>>>> problem, the Oracle standard and the driver for Mapserver.
>>>>>    I don't know if this week (With the easter holiday) I can 
>>>>> work more, 
>>>>> but I will try to develop something.
>>>>>    Before it, can you send to me all the info about your 
>>>>>         
>>> system? And 
>>>     
>>>>> the objects that not work. Another importnt thing is the 
>>>>>         
>>> UMN Mapserver 
>>>     
>>>>> version and the Mapfile that you used.
>>>>>    Sorry again for the delay.
>>>>>    Best regards from Brazil.
>>>>>   
>>>>> Fernando Simon
>>>>>
>>>>>
>>>>> Schönhammer, Herbert wrote:
>>>>>     
>>>>>         
>>>>>> Hi,
>>>>>>
>>>>>> have you got some time for looking at the problem ??
>>>>>>
>>>>>> Best regards
>>>>>> Herbert Schönhammer
>>>>>>
>>>>>>   
>>>>>>       
>>>>>>           
>>>>>>> -----Ursprüngliche Nachricht-----
>>>>>>> Von: UMN MapServer Users List 
>>>>>>> [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] Im Auftrag von 
>>>>>>>             
>>> Fernando Simon
>>>     
>>>>>>> Gesendet: Montag, 19. März 2007 04:33
>>>>>>> An: MAPSERVER-USERS at LISTS.UMN.EDU
>>>>>>> Betreff: Re: [UMN_MAPSERVER-USERS] No drawing of certain 
>>>>>>> polygon rings stroed in Oracle Spatial
>>>>>>>
>>>>>>>
>>>>>>> Hi,
>>>>>>>    The problem that you report it's strange, I need to 
>>>>>>> investigate more
>>>>>>> to try find the solution. This approach to draw the circle I 
>>>>>>> never used.
>>>>>>>    Maybe (very possible) that the problem with the 
>>>>>>>         
>>>>>>>             
>>>>> SDO_INTERPRETATION
>>>>>     
>>>>>         
>>>>>>> and SDO_GTYPE that you relate is the core of the problem.
>>>>>>>    You can try to simplify your arc's as lines, Oracle 9i 
>>>>>>>             
>>> contains a
>>>     
>>>>>>> function that transform arc's to lines, I don't remember the 
>>>>>>> name now (I
>>>>>>> don't have the docs here now). You can try this way to solve the
>>>>>>> problem, you need to test the interoperability of these 
>converted
>>>>>>> polygons with Topoase.
>>>>>>>    Now I can't test (I'm starting my Master), I just can 
>>>>>>>         
>>>>>>>             
>>>>> test, change
>>>>>     
>>>>>         
>>>>>>> the code and report a solution after the day 26.
>>>>>>>    Best regards.
>>>>>>>
>>>>>>>
>>>>>>>             
>>> -------------------------------------------------------------------
>>>     
>>>>>>> Fernando Simon
>>>>>>> UMN Mapserver and Oracle Spatial developer
>>>>>>>
>>>>>>>             
>>> -------------------------------------------------------------------
>>>     
>>>>>>> Schönhammer, Herbert wrote:
>>>>>>>     
>>>>>>>         
>>>>>>>             
>>>>>>>> Hi,
>>>>>>>>
>>>>>>>> I have some troubles drawing of certain geometries, stored 
>>>>>>>>           
>>>>>>>>               
>>>>> in Oracle
>>>>>     
>>>>>         
>>>>>>>> Spatial 9i.
>>>>>>>>
>>>>>>>> In general, I'm able to say, that polygon rings are 
>drawn without
>>>>>>>> problems (Connected by line strings or compound line strings 
>>>>>>>>       
>>>>>>>>           
>>>>>>>>               
>>>>>>> connected
>>>>>>>     
>>>>>>>         
>>>>>>>             
>>>>>>>> by circular arcs AND line strings). But there are some 
>>>>>>>>               
>>> types, which
>>>     
>>>>>>>> are not drawn by mapserver. There is no warning or error 
>>>>>>>>           
>>>>>>>>               
>>>>> reported by
>>>>>     
>>>>>         
>>>>>>>> mapserver ! These certain geometries only are not present in 
>>>>>>>>       
>>>>>>>>           
>>>>>>>>               
>>>>>>> the drawn
>>>>>>>     
>>>>>>>         
>>>>>>>             
>>>>>>>> png-file (or what ever). The geometries in the neighbourhood 
>>>>>>>>       
>>>>>>>>           
>>>>>>>>               
>>>>>>> are drawn !
>>>>>>>     
>>>>>>>         
>>>>>>>             
>>>>>>>> My Environment
>>>>>>>> ==============
>>>>>>>>
>>>>>>>> - Oracle 9i with Spatial Option on a Windows 2003 Server
>>>>>>>> - MapServer 4.8.4 (Mapserver 4.10.1 does the same !) on a 
>>>>>>>>           
>>>>>>>>               
>>>>> SuSE SLES 9
>>>>>     
>>>>>         
>>>>>>>> compiled with an Oracle 10g - Client
>>>>>>>> - MapServer used as WMS-Server
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> In detail the geometry, whis is NOT drawn by mapserver
>>>>>>>> ======================================================
>>>>>>>> Our application (Autodesk Topoase 3) is not storing a 
>circle as a
>>>>>>>> circle in Oracle Spatial. The circle is splitted into two arcs,
>>>>>>>> connected to each other at the end-/start-points of 
>the arcs. The
>>>>>>>> drawn picture should be the picture of a circle.
>>>>>>>>
>>>>>>>> The stored geometry has the properties:
>>>>>>>> GTYPE 2003 (= 2-dim POLYGON)
>>>>>>>>
>>>>>>>> In Detail:
>>>>>>>> (2003; 82032; ; (1; 1003; 2; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; 
>>>>>>>>       
>>>>>>>>           
>>>>>>>>               
>>>>>>> ; ; ; ; ;
>>>>>>>     
>>>>>>>         
>>>>>>>             
>>>>>>>> ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; 
>>>>>>>>           
>>>>>>>>               
>>>>> ; ; ; ; ; ;
>>>>>     
>>>>>         
>>>>>>>> ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; 
>>>>>>>>           
>>>>>>>>               
>>>>> ; ; ; ; ; ;
>>>>>     
>>>>>         
>>>>>>>> ; ; ; ; ; ); (4505542,97176542; 5430753,10554764; 
>>>>>>>>               
>>> 4505541,58808944;
>>>     
>>>>>>>> 5430750,58265205; 4505544,16794032; 5430749,30831663;
>>>>>>>> 4505545,28931113; 5430751,74858283; 4505542,97176542;
>>>>>>>> 5430753,10554764; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; 
>>>>>>>>           
>>>>>>>>               
>>>>> ; ; ; ; ; ;
>>>>>     
>>>>>         
>>>>>>>> ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; 
>>>>>>>>           
>>>>>>>>               
>>>>> ; ; ; ; ; ;
>>>>>     
>>>>>         
>>>>>>>> ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ))
>>>>>>>>
>>>>>>>> The geometry validates 
>>>>>>>>           
>>>>>>>>               
>>>>> (SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT), the
>>>>>     
>>>>>         
>>>>>>>> result is TRUE.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> The same geometry stored as LINE or CURVE IS drawn !!
>>>>>>>> =====================================================
>>>>>>>>
>>>>>>>> GTYPE 2002  (= 2-dim LINE or CURVE)
>>>>>>>>
>>>>>>>>
>>>>>>>> (2002; 82032; ; (1; 2; 2; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; 
>>>>>>>>           
>>>>>>>>               
>>>>> ; ; ; ; ; ;
>>>>>     
>>>>>         
>>>>>>>> ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; 
>>>>>>>>           
>>>>>>>>               
>>>>> ; ; ; ; ; ;
>>>>>     
>>>>>         
>>>>>>>> ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; 
>>>>>>>>           
>>>>>>>>               
>>>>> ; ; ; ; ; ;
>>>>>     
>>>>>         
>>>>>>>> ; ; ; ; ); (4505542,97176542; 5430753,10554764; 
>4505541,58808944;
>>>>>>>> 5430750,58265206; 4505544,16794032; 5430749,30831663;
>>>>>>>> 4505545,28931113; 5430751,74858283; 4505542,97176542;
>>>>>>>> 5430753,10554764; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; 
>>>>>>>>           
>>>>>>>>               
>>>>> ; ; ; ; ; ;
>>>>>     
>>>>>         
>>>>>>>> ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; 
>>>>>>>>           
>>>>>>>>               
>>>>> ; ; ; ; ; ;
>>>>>     
>>>>>         
>>>>>>>> ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ))
>>>>>>>>
>>>>>>>>
>>>>>>>> Note
>>>>>>>> ====
>>>>>>>>
>>>>>>>> Changing the mapserver Layer TYPE from POLYGON to LINE (or 
>>>>>>>>       
>>>>>>>>           
>>>>>>>>               
>>>>>>> vice versa)
>>>>>>>     
>>>>>>>         
>>>>>>>             
>>>>>>>> does not have any effect !!!
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> In detail a "circle", which IS drawn by mapserver
>>>>>>>> =================================================
>>>>>>>>
>>>>>>>> GTYPE 2002 (= 2-dim LINE or CURVE)
>>>>>>>>
>>>>>>>> (2002; 82032; ; (1; 4; 1; 1; 2; 2; ; ; ; ; ; ; ; ; ; ; ; ; ; 
>>>>>>>>       
>>>>>>>>           
>>>>>>>>               
>>>>>>> ; ; ; ; ;
>>>>>>>     
>>>>>>>         
>>>>>>>             
>>>>>>>> ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; 
>>>>>>>>           
>>>>>>>>               
>>>>> ; ; ; ; ; ;
>>>>>     
>>>>>         
>>>>>>>> ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; 
>>>>>>>>           
>>>>>>>>               
>>>>> ; ; ; ; ; ;
>>>>>     
>>>>>         
>>>>>>>> ; ; ; ; ; ); (4506079,8746; 5430398,0938; 4506070,0144; 
>>>>>>>>           
>>>>>>>>               
>>>>> 5430388,2336;
>>>>>     
>>>>>         
>>>>>>>> 4506079,8746; 5430378,3734; 4506089,7348; 5430388,2336; 
>>>>>>>>           
>>>>>>>>               
>>>>> 4506079,8746;
>>>>>     
>>>>>         
>>>>>>>> 5430398,0938; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; 
>>>>>>>>           
>>>>>>>>               
>>>>> ; ; ; ; ; ;
>>>>>     
>>>>>         
>>>>>>>> ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; 
>>>>>>>>           
>>>>>>>>               
>>>>> ; ; ; ; ; ;
>>>>>     
>>>>>         
>>>>>>>> ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ))
>>>>>>>>
>>>>>>>> The geometry also validates 
>>>>>>>>       
>>>>>>>>           
>>>>>>>>               
>>>>>>> (SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT),
>>>>>>>     
>>>>>>>         
>>>>>>>             
>>>>>>>> the result is TRUE.
>>>>>>>>
>>>>>>>> BUT:
>>>>>>>> ----
>>>>>>>> Please look at the first triplet of SDO_ELEM_INFO.
>>>>>>>> Looking in Oracle Documentation, the combination of 
>>>>>>>>       
>>>>>>>>           
>>>>>>>>               
>>>>>>> SDO_ETYPE=4 with a
>>>>>>>     
>>>>>>>         
>>>>>>>             
>>>>>>>> SDO_INTERPRETATION=1 is NOT allowed. SDO_INTERPRETATION MUST 
>>>>>>>>       
>>>>>>>>           
>>>>>>>>               
>>>>>>> be bigger
>>>>>>>     
>>>>>>>         
>>>>>>>             
>>>>>>>> than 1.
>>>>>>>>
>>>>>>>> (Is there a bug in the doc ??????)
>>>>>>>>
>>>>>>>>
>>>>>>>> My problem
>>>>>>>> ==========
>>>>>>>> Creating new circles, the application stores them as GTYPE 
>>>>>>>>       
>>>>>>>>           
>>>>>>>>               
>>>>>>> 2003, which
>>>>>>>     
>>>>>>>         
>>>>>>>             
>>>>>>>> is not drawn !
>>>>>>>>
>>>>>>>>
>>>>>>>> Does anybody know, what's the matter?
>>>>>>>> =====================================
>>>>>>>>
>>>>>>>> Is there anybody, who has some tipps for me ?
>>>>>>>>
>>>>>>>>
>>>>>>>> With kind regards
>>>>>>>>
>>>>>>>> *Schönhammer Herbert*
>>>>>>>>
>>>>>>>>
>>>>>>>>       
>>>>>>>>           
>>>>>>>>               
>>>>>>   
>>>>>>       
>>>>>>           
>>>>>     
>>>>>         
>>>>   
>>>>       
>>>
>>>     
>>
>>   
>
>
>



More information about the mapserver-users mailing list