ST_ShortestLine

Returns the shortest LineString between two geometries. The line starts on geom1 and ends on geom2. If either geometry is empty, the function returns null.

Signatures

ST_ShortestLine(geom1: Geometry, geom2: Geometry)

Parameters

Geometry

required

The geometry where the shortest line starts.

Geometry

required

The geometry where the shortest line ends.

Return type

The shortest LineString connecting the two geometries.

Example

SELECT ST_ShortestLine(
        ST_GeomFromText('POINT (0 0)'),
        ST_GeomFromText('POINT (3 4)')
)

LINESTRING (0 0, 3 4)

Point to LineString:

ST_ShortestLine from a point to a linestring

SELECT ST_ShortestLine(
        ST_GeomFromText('POINT (0 1)'),
        ST_GeomFromText('LINESTRING (0 0, 1 0, 2 0, 3 0, 4 0, 5 0)')
)

LINESTRING (0 1, 0 0)

ST_Perimeter2D

ST_3DExtent

⌘I

Wherobots Cloud REST API

WherobotsDB

Vector tiles (PMTiles)

Havasu (Iceberg) table management

GeoStats and Map Matching

Rasterflow

Signatures

Parameters

Return type

Example

​Signatures

​Parameters

​Return type

​Example

Signatures

Parameters

Return type

Example