ST_Lat() method for type ST

Returns the latitude coordinate of the ST_Point value.

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

By default, ST_Lat 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.

point-expression.ST_Lat()

The following example gives an error because the spatial reference system identified by 0 is not a geographic spatial reference system.

SELECT NEW ST_Point( 10.0, 20.0, 0 ).ST_Lat()

The following example returns the result 20.0.

SELECT NEW ST_Point( 10.0, 20.0, 4326 ).ST_Lat()

Discuss this page in DocCommentXchange.