https://community.esri.com/t5/arcgis-enterprise-ideas/getvertices-function-in-st-geometry/idi-p/1099658 <P>Oracle:&nbsp;</P><P>It would be really helpful if we could get a function in ST_Geometry that would let us select the vertices of a feature <STRONG>as rows</STRONG>.</P><P>Oracle’s SDO_Geometry has a function called GetVertices. It is extremely handy.</P><P><A href="https://docs.oracle.com/en/database/oracle/oracle-database/21/spatl/SDO_UTIL-reference.html#GUID-9CF1E8A9-EBCB-4938-BBB6-C2AAFE4897A7" target="_blank" rel="noopener">https://docs.oracle.com/en/database/oracle/oracle-database/21/spatl/SDO_UTIL-reference.html#GUID-9CF1E8A9-EBCB-4938-BBB6-C2AAFE4897A7</A></P><P>We need to be able to <STRONG><EM>easily</EM></STRONG> access ST_Geometry feature vertices using SQL -- without using clunky workarounds like cross joins or custom types/functions.</P> Sat, 21 May 2022 16:37:10 GMT Bud 2022-05-21T16:37:10Z https://community.esri.com/t5/arcgis-enterprise-ideas/getvertices-function-in-st-geometry/idi-p/1099658 <P>Oracle:&nbsp;</P><P>It would be really helpful if we could get a function in ST_Geometry that would let us select the vertices of a feature <STRONG>as rows</STRONG>.</P><P>Oracle’s SDO_Geometry has a function called GetVertices. It is extremely handy.</P><P><A href="https://docs.oracle.com/en/database/oracle/oracle-database/21/spatl/SDO_UTIL-reference.html#GUID-9CF1E8A9-EBCB-4938-BBB6-C2AAFE4897A7" target="_blank" rel="noopener">https://docs.oracle.com/en/database/oracle/oracle-database/21/spatl/SDO_UTIL-reference.html#GUID-9CF1E8A9-EBCB-4938-BBB6-C2AAFE4897A7</A></P><P>We need to be able to <STRONG><EM>easily</EM></STRONG> access ST_Geometry feature vertices using SQL -- without using clunky workarounds like cross joins or custom types/functions.</P> Sat, 21 May 2022 16:37:10 GMT https://community.esri.com/t5/arcgis-enterprise-ideas/getvertices-function-in-st-geometry/idi-p/1099658 Bud 2022-05-21T16:37:10Z