ST_InterpolatePoint

Returns the interpolated measure value of a linear measured LineString at the point closest to the specified point.

Make sure that both geometries have the same SRID, otherwise the function will throw an IllegalArgumentException.

Signatures

ST_InterpolatePoint(linestringM: Geometry, point: Geometry)

linestringM

Geometry

required

The linestring m value.

point

Geometry

required

The point value.

A numeric value.

SELECT ST_InterpolatePoint(
    ST_GeomFromWKT("LINESTRING M (0 0 0, 2 0 2, 4 0 4)"),
    ST_GeomFromWKT("POINT (1 1)")
    )

1.0

⌘I