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. Whether it was set as an authority code (e.g. 'EPSG:3857'), PROJJSON, or WKT, the CRS is returned in the same form it was set.

Examples¶

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

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