problems with some Oracle polygons

[Francesco Sozzi]

Hi Gerjan,

Thanks for answer.

I use Oracle 9i and the validation command does not give me any error.
About elem_info, I think that it right: it says that the polygon should have three list of segments:
- from coord at position 1 a list of line segments
- from coord at position 5 a list af arc segments
- from coord at position 13 a list of line segments

I think that the problem is on the first triplet into elem_info. If I specify "1,1005,3" instead of "1, 5, 3" mapserver works fine.
The problem is that I can't control that: I read data written by another system and I have many records with this problem.

Best regards

Francesco

  ----- Original Message ----- 
  From: Gerjan Walrecht 
  To: 'Francesco Sozzi' ; 'UMN MapServer Users List' 
  Sent: Monday, September 26, 2005 1:49 PM
  Subject: RE: [UMN_MAPSERVER-USERS] problems with some Oracle polygons


  Francesco,

   

  From a quick look at your geometry I think that the problem is that it is not valid (but I might be wrong). Have you validated the geometry with the validation procedure from Oracle? The sdo_geometry of 2003 suggests a single polygon, but you Eleminfo does not. Try updating your sdo_geometry type to 2007 (multipolygon).

   

  Hope this helps,

   

  Gerjan

   

   


------------------------------------------------------------------------------

  Van: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] Namens Francesco Sozzi
  Verzonden: maandag 26 september 2005 12:09
  Aan: MAPSERVER-USERS at LISTS.UMN.EDU
  Onderwerp: [UMN_MAPSERVER-USERS] problems with some Oracle polygons

   

  Hi Fernando,

   

  How are you?...

   

  In some cases I have polygon defined with a code "5" instead of "1005". In this case mapserver does not recognize the polygon format and it displayes an error:

  Warning: [MapServer Error]: msDrawShape(): Only polygon shapes can be drawn using a POLYGON layer definition. in...

   

  Here you are a sample polygon definition that gives me problems:

  SDO_GEOMETRY(2003, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 5, 3, 1, 2, 1, 5, 2, 2, 13, 2, 1), SDO_ORDINATE_ARRAY(717393.311, 96290.2075, 717393.843, 96286.1065, 717300.032, 96279.4307, 717301.79, 96281.1715, 717303.764, 96282.6628, 717305.79, 96283.6852, 717307.995, 96284.2265, 717309.425, 96284.41, 717352.296, 96287.4608, 717387.403, 96289.9591, 717393.311, 96290.2075))

   

  Any suggestions?...

   

  Best regards

   

  Francesco

   

   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20050926/965d6186/attachment.htm>