ST_LengthSphere - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).


ST_LengthSphere returns the length of a linear geometry in meters. For point, multipoint, and areal geometries, ST_LengthSphere returns 0. For geometry collections, ST_LengthSphere returns the total length of the linear geometries in the collection in meters.

ST_LengthSphere interprets the coordinates of each point of the input geometry as longitude and latitude in degrees. For 3DZ, 3DM, or 4D geometries, only the first two coordinates are used.





A value of data type GEOMETRY or an expression that evaluates to a GEOMETRY type.

Return type

DOUBLE PRECISION length in meters. The length computation is based on the spherical model of the Earth whose radius is Earth's mean radius of the World Geodetic System (WGS) 84 ellipsoidal model of the Earth.

If geom is null, then null is returned.


The following example SQL computes the length of a linestring in meters.

SELECT ST_LengthSphere(ST_GeomFromText('LINESTRING(10 10,45 45)'));
st_lengthsphere ------------------ 5127736.08292556