ST_Length2D

Introduction: Returns the perimeter of A. This function is an alias of ST_Length.

Warning

Since v1.7.0, this function only supports LineString, MultiLineString, and GeometryCollections containing linear geometries. Use ST_Perimeter for polygons.

Format: ST_Length2D (A:geometry)

Since: v1.6.1

SQL Example:

SELECT ST_Length2D(ST_GeomFromWKT('LINESTRING(38 16,38 50,65 50,66 16,38 16)'))

Output:

123.0147027033899