ST_CRS¶

Returns the Coordinate Reference System (CRS) metadata associated with a geometry or geography object.

Usage¶

string ST_CRS(geom: geometry)

Arguments¶

geom (geometry): Input geometry

Description¶

Returns the CRS (Coordinate Reference System) string associated with a geometry or geography. This is abbreviated as an authority/code if possible (e.g., 'EPSG:3857').

Examples¶

SELECT ST_CRS(ST_Point(0.25, 0.25, 4326)) AS crs_info;

┌───────────┐
│  crs_info │
│    utf8   │
╞═══════════╡
│ OGC:CRS84 │
└───────────┘