ST_LongWest method

geometry-expression.ST_LongWest()

DOUBLE Retrieves the longitude of the western boundary of the geometry-expression.

Returns the longitude of the western boundary of the geometry-expression. If the geometry crosses the date line in the round-Earth model, ST_LongWest will be greater than the ST_LongEast value.

Note

If the geometry-expression is an empty geometry (ST_IsEmpty()=1), then this method returns NULL.

Note

By default, ST_LongWest uses the original format for a geometry, if it is available. Otherwise, the internal format is used. For more information about internal and original formats, see STORAGE FORMAT clause, CREATE SPATIAL REFERENCE SYSTEM statement.

SQL/MM (ISO/IEC 13249-3: 2006) Vendor extension

The following example returns the result 144.5.

SELECT NEW ST_LineString( 'LineString( -157.8 21.3, 144.5 13 )', 4326 )
                .ST_LongWest()