Bug report #21267

Geometries stored in Oracle table fail sdo_geom.validate_geometry_with_context(..) check

Added by Steve Pritchard almost 2 years ago.

Status:Open
Priority:Normal
Assignee:Jürgen Fischer
Category:Data Provider/Oracle
Affected QGIS version:3.4.4 Regression?:No
Operating System:Windows 10 Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:29085

Description

The geometries that QGIS writes to Oracle are often "invalid" according to Oracle Spatial - sdo_geom.validate_geometry_with_context(..) returns an error code:

ORA-13367: wrong orientation for interior/exterior rings

Cause:
In an Oracle Spatial geometry, the exterior and/or interior rings are not oriented correctly.

Action:
Be sure that the exterior rings are oriented counterclockwise and the interior rings are oriented clockwise.

If the vertices of a simple polygon are drawn in an anticlockwise order, then Oracle regards the geometry as valid.
But if the vertices as drawn in a clockwise order, sdo_geom.validate_geometry_with_context(...) returns 13367.
Also if I start with a polygon that is valid in Oracle and then split it in QGIS, I end up with two polygons that are both invalid (13367).

This problem doesn't appear to have been reported before, which suggests that it doesn't cause problems within QGIS. However, if you are preparing data in QGIS that is then going to be used within an Oracle Spatial application, then the invalid geometries can cause Oracle Spatial functions/operators to fail or return incorrect results.

Also available in: Atom PDF