Skip to main content
Transform the Spatial Reference System / Coordinate Reference System of A, from SourceCRS to TargetCRS. If the SourceCRS is not specified, CRS will be fetched from the geometry using ST_SRID. Since v1.9.0, Sedona supports multiple CRS formats including EPSG codes, WKT1, WKT2, PROJ strings, and PROJJSON. Grid files for high-accuracy datum transformations are also supported.
For comprehensive details on supported CRS formats, grid file usage, and more examples, see CRS Transformation.

​
Signatures

ST_Transform (A: Geometry, SourceCRS: String, TargetCRS: String)

ST_Transform (A: Geometry, TargetCRS: String)

​
Parameters

​
A
Geometry
required
The input geometry.
​
SourceCRS
String
The source coordinate reference system (e.g., "EPSG:4326").
​
TargetCRS
String
required
The target coordinate reference system (e.g., "EPSG:3857").

​
Return type

The resulting geometry.

​
Example

SELECT ST_AsText(ST_Transform(ST_GeomFromText('POLYGON((170 50,170 72,-130 72,-130 50,170 50))'),'EPSG:4326', 'EPSG:32649'))

POLYGON ((8766047.980342899 17809098.336766362, 5122546.516721856 18580261.912528664, 3240775.0740796793 -13688660.50985159, 4556241.924514083 -12463044.21488129, 8766047.980342899 17809098.336766362))
ST_Transform