What spatial type does Esri recommend for Oracle EGDBs?

Question

* SDE.ST_GEOMETRY?
* SDO_GEOMETRY?

The reason I ask:
SDE.ST_GEOMETRY seems to have gone stagnant in the last 5-10 years. There haven’t been many enhancements made in recent memory, despite there being open ideas/requests submitted.

Has Esri shifted focus away from SDE.ST_GEOMETRY, and are now recommending we use SDO_GEOMETRY instead?

It would help if Esri could provide clarity in this area. Thanks.

Bud · Answer

Related: SDO_Geometry vs ST_Geometry in an Oracle DB

Jon Emch · Answer

There isn't really a recommendation to make here, Enterprise Geodatabases supports both. It really boils down to your needs and competencies with either geometry type.

As you've mentioned SDO_GEOMETRY has more extensibility, whereas ST_GEOMETRY is relatively more locked down. It seems that you have usage experience with SDO, and your intent is on using that functionality. With that logic, SDO_GEOMETRY would work best here.