4 Replies Latest reply: Jul 16, 2014 8:23 PM by 1064020 RSS

    Validation with 2d vs 3d

    1064020

      We have some geometries in srid 4326 that were converted to 3d using the sdo_cs.make_3d function. A height of 0 and a arid of 4326 was given as the parameters. The 2d geometries pass validation when validate_geometry_with_context is called. The 3d geometries fail validation when validate_geometry_with_context is called. Example is below. Has anyone seen this behavior?

       

      Create table export_table

      (

      bestgeometry sdo_geometry

      );

       

       

      Insert into EXPORT_TABLE (BESTGEOMETRY)

      values

      (

      MDSYS.SDO_GEOMETRY(3003,4326,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-21.5916061401367,76.6099700927734,0,-21.4999885559082,76.5628890991211,0,-21.1517276763916,76.5508041381836,0,-21.1400337219238,76.6254196166992,0,-21.2099494934082,76.5995559692383,0,-21.2483730316162,76.6333084106445,0,-21.4101276397705,76.6446075439453,0,-21.5916061401367,76.6099700927734,0))

      );

       

      select sdo_geom.validate_geometry_with_context(BESTGEOMETRY,0.05) validation3d, sdo_geom.validate_geometry_with_context(sdo_cs.make_2d(bestgeometry),.05) validation2d

      from export_table