(II) New SDO_GEOMETRY <-> Autodesk Map3d 2010

Author: Jonio, Dennis

The DrawAbleType enums were easy. I just had to give them values that could be distinguised via “OR”ing them together.

Point = 1,

Line = 2,

Surface = 4

Source code (C#):

+ expand sourceview plainprint?

1. public static int InferGeometryType(List<drawable> _drawables)  
2.  {  
3.      int rtnval = 0;  
4.      if (_drawables.Count == 1)  
5.      {  
6.          switch (_drawables[0].DrawEtype)  
7.          {  
8.              case DrawAbleType.Point:  
9.                  rtnval = 1;  
10.                  break;  
11.              case DrawAbleType.Line:  
12.                  rtnval = 2;  
13.                  break;  
14.              case DrawAbleType.Surface:  
15.                  rtnval = 3;  
16.                  break;  
17.          }  
18.      }  
19.      else  
20.      {  
21.          int ttype = 0;  
22.          foreach (DrawAble d in _drawables)  
23.              ttype = ttype | (int)d.DrawEtype;  
24.   
25.          switch (ttype)  
26.          {  
27.              case 1:  
28.                  rtnval = 5; //MultiPoint  
29.                  break;  
30.              case 2:  
31.                  rtnval = 6; //MultiLine  
32.                  break;  
33.              case 4:  
34.                  rtnval = 7; //MultiPolygon  
35.                  break;  
36.              default:  
37.                  rtnval = 4; //Collection  
38.                  break;  
39.          }  
40.      }  
41.      return rtnval;  
42.  }  
43. ble>  

       public static int InferGeometryType(List _drawables)
        {
            int rtnval = 0;
            if (_drawables.Count == 1)
            {
                switch (_drawables[0].DrawEtype)
                {
                    case DrawAbleType.Point:
                        rtnval = 1;
                        break;
                    case DrawAbleType.Line:
                        rtnval = 2;
                        break;
                    case DrawAbleType.Surface:
                        rtnval = 3;
                        break;
                }
            }
            else
            {
                int ttype = 0;
                foreach (DrawAble d in _drawables)
                    ttype = ttype | (int)d.DrawEtype;

                switch (ttype)
                {
                    case 1:
                        rtnval = 5; //MultiPoint
                        break;
                    case 2:
                        rtnval = 6; //MultiLine
                        break;
                    case 4:
                        rtnval = 7; //MultiPolygon
                        break;
                    default:
                        rtnval = 4; //Collection
                        break;
                }
            }
            return rtnval;
        }

I really wrestled with these DrawAbleSubComponentEType enums. I tried to be really clever with these values and somehow take advantage of the relationship between ETYPE and INTERPRETATION. Tried is the operative word.

Point = 1, //1

PointCluster = 10, //1 + n

PointOriented = 19, //Not supported OrientedPoint

SimpleLine = 3, //2 + 1

SimpleLineAllCurves = 4, //2 + 2

CompoundLine = 40, //4 + n

SimpleSurfaceOuterRingLine = 1004, //1003 + 1

SimpleSurfaceOuterRingAllCurves = 1005, //1003 + 2

SimpleSurfaceOuterRingRectangle = 1006, //1003 + 3

SimpleSurfaceOuterRingCircle = 1007, //1003 + 4

SimpleSurfaceInnerRingLine = 2004, //2003 + 1

SimpleSurfaceInnerRingAllCurves = 2005, //2003 + 2

SimpleSurfaceInnerRingRectangle = 2006, //2003 + 3

SimpleSurfaceInnerRingCircle = 2007, //2003 + 4

CompoundSurfaceOuterRingLine = 10050, //1005 + n

CompoundSurfaceInnerRingLine = 20050 //2005 + n
The specification has to many exceptions for this to work but at least I have my unique values.

I do wonder alot as to why Oracle set up the unique combinations for Circle, Rectangle and instances of all Curves. I did read the spec on “Oriented Point” and just arbitrarily decided NOT to support it. I will never use it and I guess I am the boss. So if you need that you will have to do it yourself. It should be a straight forward job for someone with the motivation.

When it gets time to resolve these into the “real” ETYPE and INTERPRETATION values I just set up a couple static methods in a static utility class.
Source code (C#):

+ expand sourceview plainprint?

1.  public static int BasicETYPE(DrawAbleSubComponentEType t)  
2.  {  
3.      int rtnval = 0;  
4.      switch (t)  
5.      {  
6.          case DrawAbleSubComponentEType.Point:  
7.          case DrawAbleSubComponentEType.PointCluster:  
8.          case DrawAbleSubComponentEType.PointOriented:  
9.              rtnval = 1;  
10.              break;  
11.          case DrawAbleSubComponentEType.SimpleLine:  
12.          case DrawAbleSubComponentEType.SimpleLineAllCurves:  
13.              rtnval = 2;  
14.              break;  
15.          case DrawAbleSubComponentEType.CompoundLine:  
16.              rtnval = 4;  
17.              break;  
18.          case DrawAbleSubComponentEType.SimpleSurfaceOuterRingLine:  
19.          case DrawAbleSubComponentEType.SimpleSurfaceOuterRingAllCurves:  
20.          case DrawAbleSubComponentEType.SimpleSurfaceOuterRingCircle:  
21.          case DrawAbleSubComponentEType.SimpleSurfaceOuterRingRectangle:  
22.              rtnval = 1003;  
23.              break;  
24.          case DrawAbleSubComponentEType.SimpleSurfaceInnerRingLine:  
25.          case DrawAbleSubComponentEType.SimpleSurfaceInnerRingAllCurves:  
26.          case DrawAbleSubComponentEType.SimpleSurfaceInnerRingCircle:  
27.          case DrawAbleSubComponentEType.SimpleSurfaceInnerRingRectangle:  
28.              rtnval = 2003;  
29.              break;  
30.          case DrawAbleSubComponentEType.CompoundSurfaceOuterRingLine:  
31.              rtnval = 1005;  
32.              break;  
33.          case DrawAbleSubComponentEType.CompoundSurfaceInnerRingLine:  
34.              rtnval = 2005;  
35.              break;  
36.          default:  
37.              break;  
38.      }  
39.      return rtnval;  
40.  }  
41. public static int BasicINTERPRETATION(DrawAbleSubComponentEType t)  
42.  {  
43.      int rtnval = 0;  
44.      switch (t)  
45.      {  
46.          case DrawAbleSubComponentEType.Point:  
47.          case DrawAbleSubComponentEType.SimpleLine:  
48.          case DrawAbleSubComponentEType.SimpleSurfaceInnerRingLine:  
49.          case DrawAbleSubComponentEType.SimpleSurfaceOuterRingLine:  
50.              rtnval = 1;  
51.              break;  
52.          case DrawAbleSubComponentEType.SimpleSurfaceInnerRingAllCurves:  
53.          case DrawAbleSubComponentEType.SimpleSurfaceOuterRingAllCurves:  
54.          case DrawAbleSubComponentEType.SimpleLineAllCurves:  
55.              rtnval = 2;  
56.              break;  
57.          case DrawAbleSubComponentEType.SimpleSurfaceOuterRingRectangle:  
58.          case DrawAbleSubComponentEType.SimpleSurfaceInnerRingRectangle:  
59.              rtnval = 3;  
60.              break;  
61.          case DrawAbleSubComponentEType.SimpleSurfaceInnerRingCircle:  
62.          case DrawAbleSubComponentEType.SimpleSurfaceOuterRingCircle:  
63.              rtnval = 4;  
64.              break;  
65.          case DrawAbleSubComponentEType.PointCluster:  
66.          case DrawAbleSubComponentEType.CompoundLine:  
67.          case DrawAbleSubComponentEType.CompoundSurfaceOuterRingLine:  
68.          case DrawAbleSubComponentEType.CompoundSurfaceInnerRingLine:  
69.              rtnval = 0;  
70.              break;  
71.          case DrawAbleSubComponentEType.PointOriented:  
72.              rtnval = 9;  
73.              break;  
74.          default:  
75.              break;  
76.      }  
77.      return rtnval;  
78.  }  

        public static int BasicETYPE(DrawAbleSubComponentEType t)
        {
            int rtnval = 0;
            switch (t)
            {
                case DrawAbleSubComponentEType.Point:
                case DrawAbleSubComponentEType.PointCluster:
                case DrawAbleSubComponentEType.PointOriented:
                    rtnval = 1;
                    break;
                case DrawAbleSubComponentEType.SimpleLine:
                case DrawAbleSubComponentEType.SimpleLineAllCurves:
                    rtnval = 2;
                    break;
                case DrawAbleSubComponentEType.CompoundLine:
                    rtnval = 4;
                    break;
                case DrawAbleSubComponentEType.SimpleSurfaceOuterRingLine:
                case DrawAbleSubComponentEType.SimpleSurfaceOuterRingAllCurves:
                case DrawAbleSubComponentEType.SimpleSurfaceOuterRingCircle:
                case DrawAbleSubComponentEType.SimpleSurfaceOuterRingRectangle:
                    rtnval = 1003;
                    break;
                case DrawAbleSubComponentEType.SimpleSurfaceInnerRingLine:
                case DrawAbleSubComponentEType.SimpleSurfaceInnerRingAllCurves:
                case DrawAbleSubComponentEType.SimpleSurfaceInnerRingCircle:
                case DrawAbleSubComponentEType.SimpleSurfaceInnerRingRectangle:
                    rtnval = 2003;
                    break;
                case DrawAbleSubComponentEType.CompoundSurfaceOuterRingLine:
                    rtnval = 1005;
                    break;
                case DrawAbleSubComponentEType.CompoundSurfaceInnerRingLine:
                    rtnval = 2005;
                    break;
                default:
                    break;
            }
            return rtnval;
        }
       public static int BasicINTERPRETATION(DrawAbleSubComponentEType t)
        {
            int rtnval = 0;
            switch (t)
            {
                case DrawAbleSubComponentEType.Point:
                case DrawAbleSubComponentEType.SimpleLine:
                case DrawAbleSubComponentEType.SimpleSurfaceInnerRingLine:
                case DrawAbleSubComponentEType.SimpleSurfaceOuterRingLine:
                    rtnval = 1;
                    break;
                case DrawAbleSubComponentEType.SimpleSurfaceInnerRingAllCurves:
                case DrawAbleSubComponentEType.SimpleSurfaceOuterRingAllCurves:
                case DrawAbleSubComponentEType.SimpleLineAllCurves:
                    rtnval = 2;
                    break;
                case DrawAbleSubComponentEType.SimpleSurfaceOuterRingRectangle:
                case DrawAbleSubComponentEType.SimpleSurfaceInnerRingRectangle:
                    rtnval = 3;
                    break;
                case DrawAbleSubComponentEType.SimpleSurfaceInnerRingCircle:
                case DrawAbleSubComponentEType.SimpleSurfaceOuterRingCircle:
                    rtnval = 4;
                    break;
                case DrawAbleSubComponentEType.PointCluster:
                case DrawAbleSubComponentEType.CompoundLine:
                case DrawAbleSubComponentEType.CompoundSurfaceOuterRingLine:
                case DrawAbleSubComponentEType.CompoundSurfaceInnerRingLine:
                    rtnval = 0;
                    break;
                case DrawAbleSubComponentEType.PointOriented:
                    rtnval = 9;
                    break;
                default:
                    break;
            }
            return rtnval;
        }

To be continued ...