PostGIS

ST_InterpolatePoint
Prev	7.19. Linear Referencing	Next

ST_InterpolatePoint

7.19. Linear Referencing

Name

ST_InterpolatePoint — Returns the interpolated measure of a geometry closest to a point.

float8 +`*`+ST_InterpolatePoint*(`geometry `linear_geom_with_measure, geometry point`)`;

Returns an interpolated measure value of a linear measured geometry at the location closest to the given point.

Note

Use this function only for linear geometries with an M component

Availability: 2.0.0

check This function supports 3d and will not drop the z-index.

SELECT ST_InterpolatePoint('LINESTRING M (0 0 0, 10 0 20)', 'POINT(5 5)');
 ---------------------
         10