ST_SRID

Signature

INT ST_SRID(GEOMETRY geom);

Description

Returns SRID value or 0 if input Geometry does not have one.

Note

Implements the OpenGIS Simple Features Implementation Specification for SQL version 1.2.1

Examples

SELECT ST_SRID(ST_GeomFromText('POINT(15 25)', 2154));
-- Answer: 2154

SELECT ST_SRID(ST_GeomFromText('LINESTRING(2 1, 1 3, 5 2, 2 1)', 4326));
-- Answer: 4326

See also

• ST_SetSRID, ST_Transform, UpdateGeometrySRID, ST_FindUTMSRID, ST_GeomFromText, ST_IsGeographicCRS

• Source code