Skip to main content
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. ST_AddMeasure

​
Signatures

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

​
Parameters

​
geom
Geometry
required
The input geometry.
​
measureStart
Double
required
The measure start value.
​
measureEnd
Double
required
The measure end value.

​
Return type

The resulting geometry.

​
Example

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

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