ST_SRID(INT) method

Changes the spatial reference system associated with the geometry without modifying any of the values.

Syntax

geometry-expression.ST_SRID(INT srid)

Parameters

srid – The SRID to use for the result.

Returns

ST_Geometry Returns a copy of the geometry value with the specified spatial reference system.

Examples

Example 1 – The following example returns the result SRID=1000004326;Point (-118 34).
```
SELECT NEW ST_Point( -118, 34, 4326 ).ST_SRID( 1000004326 ).ST_AsText( 'EWKT' )
```

Standards

SQL/MM (ISO/IEC 13249-3: 2006) 5.1.5

Parent topic: ST_Geometry type

Created December 19, 2013. Send feedback on this help topic to Technical Publications: pubs@sap.com