ST_SRID(INT) method for type ST

geometry-expression.ST_SRID(srid)

Name	Type	Description
srid	INT	The SRID to use for the result.

ST_Geometry Returns a copy of the geometry value with the specified spatial reference system.
The spatial reference system identifier of the result is the given by parameter srid.

The ST_SRID method creates a copy of a geometry-expression with the SRID specified by srid parameter. ST_SRID can be used when both the source and destination spatial reference systems have the same coordinate system.

If you are transforming a geometry between two spatial reference systems that have different coordinate systems, you should use the ST_Transform method.

Note

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.

ST_Transform method for type ST_Geometry

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

The following example returns the result SRID=1000004326;Point (-118 34).

SELECT NEW ST_Point( -118, 34, 4326 ).ST_SRID( 1000004326 ).ST_AsText( 'EWKT' )

ST_SRID(INT) method for type ST_Geometry

Syntax

Parameters

Returns

Remarks

Note

See also

Standards and compatibility

Example