Easier access to ST_GEOMETRY vertices

Bud — Fri, 01 Jul 2022 13:43:34 GMT

ST_GEOMETRY vertices should be easier to access (Oracle).

Currently, ST_GEOMETRY vertices are obscured in a BLOB/LOB column within the shape object, which makes accessing the vertices difficult.

An alternative idea might be: store the vertex ordinates in a more transparent datatype, such as a varray, a nested table column, or some other table collection datatype — as an additional/separate attribute within the existing SHAPE object column (not to be confused with creating an entirely new column in the table).

That would make it a lot easier to work with ST_GEOMETRY vertices.

We're aware there are workarounds like cross joins and parsing WKT. But they're too clunky & slow. An easier-to-access collection datatype would be better.

idea Easier access to ST_GEOMETRY vertices in ArcGIS Enterprise Ideas

Easier access to ST_GEOMETRY vertices