ST_X¶

Returns the X coordinate of the point, or NULL if not available.

Usage¶

double ST_X(geom: geometry)

Arguments¶

geom (geometry): Input geometry

Description¶

Returns NULL for non-point geometries or NULL input.

Examples¶

SELECT ST_X(ST_Point(-74.0060, 40.7128));
-- Returns: -74.006

┌───────────────────────────────────────────────────┐
│ st_x(st_point(Float64(-74.006),Float64(40.7128))) │
│                      float64                      │
╞═══════════════════════════════════════════════════╡
│                                           -74.006 │
└───────────────────────────────────────────────────┘