Skip to main content
Return the geodesic perimeter of A using WGS84 spheroid. Unit is meter. Works better for large geometries (country level) compared to ST_Length + ST_Transform. It is equivalent to PostGIS ST_Length(geography, use_spheroid=true) and ST_LengthSpheroid function and produces nearly identical results. Geometry must be in EPSG:4326 (WGS84) projection and must be in ==lon/lat== order. You can use ==ST_FlipCoordinates== to swap lat and lon.
By default, this function uses lon/lat order since v1.5.0. Before, it used lat/lon order.
Since v1.7.0, this function only supports LineString, MultiLineString, and GeometryCollections containing linear geometries. Use ST_Perimeter for polygons.
ST_LengthSpheroid

​
Signatures

ST_LengthSpheroid (A: Geometry)

​
Parameters

​
A
Geometry
required
The input geometry.

​
Return type

A numeric value.

​
Example

SELECT ST_LengthSpheroid(ST_GeomFromWKT('LINESTRING (0 0, 2 0)'))

222638.98158654713