What spatial type does Esri recommend for Oracle EGDBs?

396
2
04-01-2022 08:07 AM
Bud
by
Notable Contributor

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.

0 Kudos
2 Replies
JonEmch
Esri Regular Contributor

   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.

Keep on keeping on!
Bud
by
Notable Contributor
0 Kudos