Returns the SRID of the geometry.
geometry-expression.ST_SRID()
INT Returns the SRID of the geometry.
Returns the SRID of the geometry. Every geometry is associated with a spatial reference system.
By default, ST_SRID uses the original format for a geometry, if it is available. Otherwise, the internal format is used. For more information about internal and original formats, see STORAGE FORMAT clause, CREATE SPATIAL REFERENCE SYSTEM statement.
SQL/MM (ISO/IEC 13249-3: 2006) 5.1.5
The following returns the result 0, indicating all Shapes in the table have the SRID 0, corresponding to the 'Default' spatial reference system.
0
SELECT DISTINCT Shape.ST_SRID() FROM SpatialShapes
Syntax