ST_LineLocatePoint
Signature
Parameters
ColumnOrName
required
Linestring geometry column to locate point on.
ColumnOrName
required
Point geometry column.
Returns
Column
double between 0 and 1 as a fraction of 2d line length.
Linear Referencing
ST_LineLocatePoint (Python)
Returns a double between 0 and 1 representing the location of the closest point on a LineString to the given Point, as a fraction of 2d line length.
Returns a double between 0 and 1 representing the location of the closest point on a LineString to the given Point, as a fraction of 2d line length.
SQL reference: