ST_ClosestPoint
Signature
Parameters
ColumnOrName
required
Geometry column to use in the calculation.
ColumnOrName
required
Geometry column to use in the calculation.
Returns
Column
the 2-dimensional point on a that is closest to b.
Measurement
ST_ClosestPoint (Python)
Returns the 2-dimensional point on geom1 that is closest to geom2.
Returns the 2-dimensional point on geom1 that is closest to geom2.
This is the first point of the shortest line between the geometries.
SQL reference: