2 Replies Latest reply: Mar 11, 2013 4:50 PM by Rpitts-Oracle RSS

    SDO_CONCAVEHULL_BOUNDARY -- HANGS

    769733
      Hi,

      I have a couple of geometires that are causing the SDO_CONCAVEHULL_BOUNDARY function to hang, can anybody see what is causing this?

      Thanks,
      Jerry

      Example 1

      select SDO_GEOM.SDO_CONCAVEHULL_BOUNDARY(MDSYS.SDO_GEOMETRY(2005,82086,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1,5),MDSYS.SDO_ORDINATE_ARRAY
      (
      244941.797,454222.656,
      241894.984,457576.563,
      241923.625,457569.281,
      241903.828,457575,
      241937.156,457592.188)),0.005) from dual;

      Example 2

      SELECT SDO_GEOM.SDO_CONCAVEHULL_BOUNDARY(MDSYS.SDO_GEOMETRY(2005,82086,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1,84),MDSYS.SDO_ORDINATE_ARRAY(101542.742,174752.906,101554.461,174771.078,101799.023,174801.734,101897.883,174808.219,101899,174801.656,101900.672,174793.844,101914.07,174766.203,102056.023,174850.5,102008.508,174887.172,102000.492,174893.469,101947.602,174729.875,101776.727,174925.031,101751.453,174884.688,101932.664,175007.531,101947.609,175023.734,102085.766,174896.766,101800.875,174845.766,101838.188,174817.609,101857.992,174789.344,101866.93,174748.344,101902.07,174786.031,101930.93,174833.219,101941.766,174841.016,101936.781,174836.906,102067.93,174843.5,102073.797,174840.078,102089.43,174835.203,102096.023,174833.734,102115.57,174831.047,102053.031,174855.469,102033.609,174868.219,102028.188,174872.563,102026.063,174876.344,102005.039,174890.422,101995.938,174897.578,101962.781,174899.969,101953.031,174892.813,101927.891,174872.438,101932.445,174875.906,101957.797,174896.5,
      101671.625,174876.484,101607.008,174838.484,101378.047,174670.766,101515.594,174735.375,101565.211,174778.703,101662.625,174840.266,101686.563,174857.453,101694.133,174860.938,101720.789,174869.922,101793.617,174880.734,101829.055,174942.281,101843.641,174892.844,101845.563,174884.438,101849.609,174875.846,102880.555,176338.703,101992.258,174901.266,101948.484,174888.688,101940.461,174883.063,101936.781,174879.156,101922.695,174870.063,101918.359,174866.156,101887.047,174942.563,101791.68,174931.391,101755.773,174912.563,101745.773,174907.547,101730.07,174904.797,101724.586,174897.844,101696.609,174887.031,101661.117,174870.797,101329.992,174634.422,101583.039,174824.484,101678.258,174853.453,101702.219,174863.125,101764.602,174887.547,101829.992,174916.438,101848.18,174859.531,101857.773,174804.953,101902.586,174743.609,101946.961,174845.563,102109.953,174833.234,102039.031,174863.875,102013.711,174882.844,101944.234,174339.656,101941.922,174316.969)) ,0.005)
      FROM dual;