ST_SRID - Amazon Redshift
SyntaxArgumentsReturn typeExamples

ST_SRID

ST_SRID returns the spatial reference system identifier (SRID) of an input geometry. For more information about an SRID, see Querying spatial data in Amazon Redshift.

Syntax

ST_SRID(geom)

Arguments

geom

A value of data type GEOMETRY or an expression that evaluates to a GEOMETRY type.

Return type

INTEGER representing the SRID value of geom.

If geom is null, then null is returned.

Examples

The following SQL returns an SRID value of a linestring that is set to SRID 4326.

SELECT ST_SRID(ST_GeomFromText('LINESTRING(77.29 29.07,77.42 29.26,77.27 29.31,77.29 29.07)',4326));

st_srid
-------------
 4326

The following SQL returns an SRID value of a linestring that is not set when constructed. This results in 0 for the SRID value.

SELECT ST_SRID(ST_GeomFromText('LINESTRING(77.29 29.07,77.42 29.26,77.27 29.31,77.29 29.07)'));

st_srid
-------------
 0