topic What spatial type does Esri recommend for Oracle EGDBs? in ArcGIS Enterprise Questions

What spatial type does Esri recommend for Oracle EGDBs?

Bud — Thu, 19 May 2022 23:09:59 GMT

What spatial type does Esri recommend for Oracle EGDBs?

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.

Re: What spatial type does Esri recommend for Oracle EGDBs?

JonEmch — Tue, 05 Apr 2022 15:51:31 GMT

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.

Re: What spatial type does Esri recommend for Oracle EGDBs?

Bud — Wed, 21 Feb 2024 04:34:07 GMT