Get sum of M-values using SQL

BB1234

I have multipart polylines in an ST_GEOMETRY feature class (in an Oracle 18c EGDB).

Using SQL, I want to get the sum of the M-values of each polyline.

For example, for the following multipart line, the calculation would be: 11.18 + 33.54 + 43.54 = 88.26

(The M-sum is not to be confused with the length of the line.)

How can I do that using SQL?

KimberlyGarbade

Sorry.  You are correct.  That does not do what you want (should have tested it).

I had to write a customized function (I had to alter the original so ALTER rather than CREATE is shown):

ALTER FUNCTION [GISDC].[TotalM] (@geom geometry)
RETURNS FLOAT
WITH EXECUTE AS CALLER
AS
BEGIN
  DECLARE @x integer;
  DECLARE @y integer;
  DECLARE @z float;
  DECLARE @q float;
  set @x = @geom.STNumPoints();
  set @y = 1;
  set @q = 0
  WHILE @y <= @x
  BEGIN
    set @z = convert(float, geometry::STGeomFromText(@geom.STPointN(@y).ToString(),0).M);
    set @q = @q + @z
	set @y = @y + 1
  END;
  RETURN(@q);
END;
GO

Input test line

result