ST_AddMeasure

Introduction: Computes a new geometry with measure (M) values linearly interpolated between start and end points. For geometries lacking M dimensions, M values are added. Existing M values are overwritten by the new values. Applies only to LineString and MultiLineString inputs.

Format: ST_AddMeasure(geom: Geometry, measureStart: Double, measureEnd: Double)

Since: v1.6.1

SQL Example:

SELECT ST_AsText(ST_AddMeasure(
        ST_GeomFromWKT('LINESTRING (0 0, 1 0, 2 0, 3 0, 4 0, 5 0)')
))

Output:

LINESTRING M(0 0 10, 1 0 16, 2 0 22, 3 0 28, 4 0 34, 5 0 40)