Skip to main content
When trying to validate the Oracle Spatial geometry using GeometryValidator. It returns the following issues for many records.

 

 

GeometryTrait(string) : `_issues{0}.issue_found' has value `Fails OGC Simple'

 

GeometryTrait(64 bit real): `_issues{0}.location_sample.x' has value `'

 

GeometryTrait(64 bit real): `_issues{0}.location_sample.y' has value `'

 

GeometryTrait(string) : `_issues{0}.supplementary_info' has value `Self Intersection'

 

 

If self-intersection is happening in the geometry, what is the issue here? If the geometry is repaired, does the original geometry shape and type changes?

 

 

However when I am validating with sdo_geom.validate_geometry_with_context, it is validating the geometry.

 

 

Regards,

 

Ananda
Hi,

 

 

I think it is normal that the Oracle validator and the FME GeometryValidator differ somewhat in their definition of what constitutes a "valid" geometry. It is all depending on context.

 

 

Regarding how self-intersects are repaired by FME, take a look at the GeometryValidator help, it is quite detailed. You could also output the same feature with and without repair to see how they differ.

 

 

Generally speaking, the GeometryValidator shouldn't change neither the shape nor the type of the geometry. It may, however, insert vertices and create multi-part geometries at the intersection point(s).

 

 

David

Reply