Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.wherobots.com/llms.txt

Use this file to discover all available pages before exploring further.

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.
ST_InterpolatePoint

​
Signatures

ST_InterpolatePoint(linestringM: Geometry, point: Geometry)

​
Parameters

​
linestringM
Geometry
required
The linestring m value.
​
point
Geometry
required
The point value.

​
Return type

A numeric value.

​
Example

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

1.0