Function to convert from ST_GEOMETRY subtype to supertype

Bud — Fri, 06 May 2022 04:07:52 GMT

ST_GEOMETRY; Oracle:

Could ESRI create a function to convert directly from the ST_POINT subtype to the ST_GEOMETRY supertype?

That would solve these issues:

Bug: Unable to define a query layer in ArcGIS where the data source uses an st_geometry subtype in Oracle
Get ArcGIS to recognize ST_POINT
Use TREAT() function to convert UDT subtype to supertype

I'm aware that there is a quick-and-dirty workaround, where we can convert from subtype to text to supertype (or use well-known binary instead of text). But that workaround is ugly and slow. It would be better to have a more robust & performant solution.

Re: Function to convert from ST_GEOMETRY subtype to supertype

Bud — Tue, 21 Nov 2023 21:25:17 GMT

In a reply to Create NIL (zero vertex) geometry, I mention that the bug has been updated. It now suggests that we use the st_geometry constructor to convert from subtypes to supertypes. Which seems to work for converting [SDE.ST_POLYFROMTEXT] to [SDE.ST_GEOMETRY].

But that doesn't help me when converting [ST_POINT] subtype to [ST_GEOMETRY] supertype:

idea Function to convert from ST_GEOMETRY subtype to supertype in ArcGIS Enterprise Ideas

Function to convert from ST_GEOMETRY subtype to supertype

Re: Function to convert from ST_GEOMETRY subtype to supertype