How to Make Geometry Valid From X & Y Points to a Geometry Column

When you are using Oracle, the "SDO_GEOM.VALIDATE_LAYER" feature will take the "x" and "y" values for different points in a geometry column to make sure that those points, taken together, form a valid geometry object. When you run it, the feature will load your table and indicate whether or not the shape is valid.

Instructions

    • 1

      Create an empty result table using this format: (pkey_column NUMBER, result VARCHAR2(10)).

    • 2

      Call the SDO_GEOM.VALIDATE_LAYER procedure. It is important to specify a "commit interval," which tells you the number of geometries that require validation before the application will give you a "DONE" message. This will help you monitor the progress of the validation while it is still ongoing.

    • 3

      Look at the "RESULT" column as the procedure operates. If a particular row has invalid geometry in it, this column will have a code indicating a particular error. By consulting your troubleshooting guide, you can find out the specific problem at that point in the column.

Learnify Hub © www.0685.com All Rights Reserved