Skip to content
πŸŽ‰ Apache Sedona 1.9.1 is out now! πŸ—ΊοΈ Geography SQL functions, Box2D & Box3D types, raster Python UDFs & more. Read the release notes β†’

ST_LineFromMultiPoint

Introduction: Creates a LineString from a MultiPoint geometry.

ST_LineFromMultiPoint

Format: ST_LineFromMultiPoint (A: Geometry)

Return type: Geometry

Since: v1.3.0

Example:

SELECT ST_LineFromMultiPoint(ST_GeomFromText('MULTIPOINT((10 40), (40 30), (20 20), (30 10))'))

Output:

LINESTRING (10 40, 40 30, 20 20, 30 10)