Mid Point function in SDE.ST_GEOMETRY

Idea created by avanamesriaustralia-com-au-esridist Employee on Dec 7, 2019

    I could not able to find the way to calculate the mid-point of the line geometry in the SDE database where the geometries are stored in SDE.ST_GEOMETRY object.

    There needs to be a function in ST_GEOMETRY object to create a mid point of a line and polyline. 


    Currently the midpoint calculating is possible in ArcGIS Geoprocessing tool. The similar function should be made available in SDE.ST_Geometry functions (SQL functions used with ST_Geometry—Help | ArcGIS Desktop ) which helps in processing the data within the database server.