0

Doing:

        SELECT SDO_AGGR_LRS_CONCAT_3D(SDOAGGRTYPE(
            SDO_GEOMETRY(z.SDO_GTYPE, z.SDO_SRID, z.SDO_POINT, z.SDO_ELEM_INFO, z.SDO_ORDINATES), 
            0.005))
        into l_geoloc
        from (select * from TABLE(Pi_geom_array)) z;

Pi_geom_array is series of rows:

  1. MDSYS.SDO_GEOMETRY(4402, 4326, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 2, 1), MDSYS.SDO_ORDINATE_ARRAY(-87.5471018117985, 41.6482888766313, 588.16578218591, 506.44231, ...)
  2. MDSYS.SDO_GEOMETRY(4402, 4326, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 2, 1), MDSYS.SDO_ORDINATE_ARRAY(-87.5471018117988, 41.6482888766318, 588.16578218598, 506.44238, ...)
  3. etc...

l_geoloc is: MDSYS.SDO_GEOMETRY(4402, 4326, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 2, 1), MDSYS.SDO_ORDINATE_ARRAY(-87.5471018117985, 41.6482888766313, 0, 506.44231, -87.5471437282998, 41.6483175668031, 0, 506.44531, ...)

where the SDO_ORDINATE_ARRAY is correct union of input SDO_ORDINATE_ARRAY's. But where the z index are all zeroed out.

Why is this occurring? There doesn't seem to be lot of documentation out there on oracle spatial functions. Is there a setting somewhere else, or how the function is being called that's causing this? Or is there an error with the SDO_AGGR_LRS_CONCAT_3D 3d function perhaps..?

New to oracle spatial...

The third dimension i.e. z values (since this is 3D version of the function) should not be zeroed out...

gurunara5
  • 1
  • 1
  • Tried: `dim_array SDO_DIM_ARRAY := SDO_DIM_ARRAY( SDO_DIM_ELEMENT('X', 0, 20, 0.005), SDO_DIM_ELEMENT('Y', 0, 20, 0.005), SDO_DIM_ELEMENT('Z', 0, 20, 0.005), SDO_DIM_ELEMENT('M', 0, 20, 0.005)); ` geom_segment := Pi_geom_array(g); SDO_LRS.DEFINE_GEOM_SEGMENT(l_geoloc, dim_array); SDO_LRS.DEFINE_GEOM_SEGMENT(geom_segment, dim_array); l_geoloc := SDO_LRS.CONCATENATE_GEOM_SEGMENTS_3D(l_geoloc, dim_array, geom_segment, dim_array); which still clips out the z values in the output... – gurunara5 Dec 21 '22 at 17:16
  • Is there a bug with oracle spatial? It's like none of the 3d versions of the lrs functions are working properly in that they are ignoring the z dimension. Does it depend on the version of oracle spatial installed? How does one check the version of oracle spatial and also how to upgrade to the latest? – gurunara5 Dec 22 '22 at 04:56

0 Answers0