ST_ClosestPoint¶

Returns the 2-dimensional point on geom1 that is closest to geom2.

Usage¶

geometry ST_ClosestPoint(geomA: geometry, geomB: geometry)
geography ST_ClosestPoint(geogA: geography, geogB: geography)

Arguments¶

geogA (geography): Input geography
geogB (geography): Input geography
geomA (geometry): Input geometry
geomB (geometry): Input geometry

Examples¶

SELECT ST_ClosestPoint(
    ST_GeogFromText('LINESTRING(0 0, 10 10)'),
    ST_GeogPoint(5, 0)
);

┌──────────────────────────────────────────────────────────────────────────────┐
│ st_closestpoint(st_geogfromtext(Utf8("LINESTRING(0 0, 10 10)")),st_geogpoint │
│                             (Int64(5),Int64(0)))…                            │
╞══════════════════════════════════════════════════════════════════════════════╡
│ POINT(2.466474353124253 2.5021583528406395)                                  │
└──────────────────────────────────────────────────────────────────────────────┘