Categories:: Geospatial Functions

ST_SETSRID¶

Returns a GEOMETRY object that has its SRID (spatial reference system identifier) set to the specified value.

Syntax¶

ST_SETSRID( <geometry_expression> , <srid> )

Copy

Arguments¶

geometry_expression: The argument must be an expression of type GEOMETRY.
srid: The SRID to set in the returned GEOMETRY object.

Returns¶

The function returns a value of type GEOMETRY.

Usage Notes¶

Examples¶

The following example creates and returns a GEOMETRY object that uses the SRID 4326:

ALTER SESSION SET GEOMETRY_OUTPUT_FORMAT='EWKT';

SELECT ST_SETSRID(TO_GEOMETRY('POINT(13 51)'), 4326);

+-----------------------------------------------+
| ST_SETSRID(TO_GEOMETRY('POINT(13 51)'), 4326) |
|-----------------------------------------------|
| SRID=4326;POINT(13 51)                        |
+-----------------------------------------------+

Copy