Select to view content in your preferred language

Spatial types: What type constructors auto-validate geometries?

429
0
06-07-2022 11:36 PM
Labels (1)
Bud
by
Honored Contributor

Regarding the various spatial types that are supported by ArcGIS:

What types auto-validate geometries? And what types don't auto-validate?

For example, if I were to create a polygon geometry from this incorrect WKT (the last vertex is slightly different from the first vertex, which is wrong), what would happen? Would the incorrect geometry be accepted, or would it throw an error?

--Example: SDE.ST_GEOMETRY
select sde.st_geometry ('polygon ((676832.320 4857578.086, 665287.423 4857578.086, 665277.423 4878109.585, 676832.320 4878119.585, 676842.320 4857588.086))', 26917) from dual 

ORA-20004: 
ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 12
ORA-06512: at "SDE.ST_GEOMETRY", line 55

 

  • SDE.ST_GEOMETRY in Oracle:
    Auto-validates — would throw an error.
  • SDO_GEOMETRY (Oracle):
    Doesn't auto-validate — doesn't throw an error, unless we explicitly perform a validation via a validation function(?).

Others?
Have I understood that correctly?

0 Kudos
0 Replies