ArcGIS Pro 2.6.8, Oracle 18c 10.7.1 EGDB; SDE.ST_Geometry
If I understand correctly, a feature can either have:
- Null SHAPE field, or
- SHAPE field is not null, only the geometry is null
It is confusing when we need to account for both A and B in SQL queries. I can't think of a use case where B is wanted.
Could the SDE.ST_Geometry database datatype be enhanced so that B is prevented/not allowed?
Related: Attribute Table — Indicate if SHAPE field is null vs. object's geometry is empty