ST_GEOMETRY SQL function: Set M-value to cumulative length of line

153
0
01-31-2022 07:47 AM
Status: Open
Bud
by
Notable Contributor

Oracle; SDE.ST_GEOMETRY:

For existing SDE.ST_GEOMETRY polylines that have M-values (aka 'measure values' for linear referencing purposes).

It would be really helpful if ESRI could add a ST_GEOMETRY SQL function that could be used to UPDATE the M-values to the cumulative length of line.

In other words, if we look at the image below, the M-values would be updated so that they're the same as the length of the line at a given vertex.

Bud_0-1643645924855.png

 

Could ESRI consider adding a function for that?

I believe it would be the equivalent of Oracle Spatial's REDEFINE_GEOM_SEGMENT function.

Thanks.