Extract X / Y from Geometry (ST_X, ST_Y)

Use this skill when you need to extract numeric longitude/latitude values from a PostGIS geometry.

This is common when:

• returning tabular data alongside geometry
• exporting points to CSV
• debugging coordinate issues
• integrating with non-GIS systems

Core rules

• ST_X and ST_Y only work on POINT geometries
• Units and meaning depend on the geometry’s SRID
• For web use, extract coordinates after transforming to EPSG:4326

Canonical patterns