ST_Transform

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

Geometry

required

The input geometry.

String

The source coordinate reference system (e.g., "EPSG:4326").

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))

⌘I

Wherobots Cloud REST API

WherobotsDB

Vector tiles (PMTiles)

Havasu (Iceberg) table management

GeoStats and Map Matching

Rasterflow

Signatures

Parameters

Return type

Example

​Signatures

​Parameters

​Return type

​Example

Signatures

Parameters

Return type

Example