ST_X

Introduction: Returns the longitude (X coordinate) of a point geography. Returns NULL for non-point geographies and empty points.

Format:

ST_X (A: Geography)

Return type: Double

Since: v1.9.1

SQL Example

SELECT ST_X(ST_GeogFromWKT('POINT (-73.9857 40.7484)'));

Output:

-73.9857