ST_MakeLine

Creates a Geography LineString from two Point, MultiPoint, or LineString geographies. Its edges are interpreted as great-circle arcs by Geography measurement functions.

Signatures

ST_MakeLine(geog1: Geography, geog2: Geography)

Parameters

Geography

required

The first geography.

Geography

required

The second geography.

Return type

A Geography LineString.

Only the two-argument signature accepts Geography inputs. The output copies the first input’s SRID.

Example

SELECT ST_AsText(ST_MakeLine(
  ST_GeogFromWKT('POINT (0 0)', 4326),
  ST_GeogFromWKT('POINT (1 0)', 4326)
))

LINESTRING (0 0, 1 0)

⌘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