Skip to content
Apache Sedona 1.9.0 is out now, featuring Spark 4.1 support, proj4sedona CRS transformation, Bing Tile functions, and more!

ST_LineInterpolatePoint

Introduction: Returns a point interpolated along a line. First argument must be a LINESTRING. Second argument is a Double between 0 and 1 representing fraction of total linestring length the point has to be located.

ST_LineInterpolatePoint

Format: ST_LineInterpolatePoint (geom: Geometry, fraction: Double)

Return type: Geometry

Since: v1.0.1

SQL Example

SELECT ST_LineInterpolatePoint(ST_GeomFromWKT('LINESTRING(25 50, 100 125, 150 190)'), 0.2)

Output:

POINT (51.5974135047432 76.5974135047432)