H2GIS

Fork me on GitHub

ST_SRID

Signature

INT ST_SRID(GEOMETRY geom);

Description

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

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