> ## Documentation Index
> Fetch the complete documentation index at: https://docs.wherobots.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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](/reference/wherobots-db/geometry-data/spatial-reference/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.

<Tip>
  For comprehensive details on supported CRS formats, grid file usage, and more examples, see [CRS Transformation](/reference/wherobots-db/geometry-data/crs-transformation).
</Tip>

## Signatures

```sql theme={"system"}
ST_Transform (A: Geometry, SourceCRS: String, TargetCRS: String)
```

```sql theme={"system"}
ST_Transform (A: Geometry, TargetCRS: String)
```

## Parameters

<ParamField body="A" type="Geometry" required>
  The input geometry.
</ParamField>

<ParamField body="SourceCRS" type="String">
  The source coordinate reference system (e.g., `"EPSG:4326"`).
</ParamField>

<ParamField body="TargetCRS" type="String" required>
  The target coordinate reference system (e.g., `"EPSG:3857"`).
</ParamField>

## Return type

<ResponseField type="Geometry">
  The resulting geometry.
</ResponseField>

## Example

```sql theme={"system"}
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))
```

<img src="https://mintcdn.com/wherobots/wLm_IRUSNlHZTHJP/images/sql-functions/ST_Transform/ST_Transform.svg?fit=max&auto=format&n=wLm_IRUSNlHZTHJP&q=85&s=c509f615a8bdedab09454f1faa2b1661" alt="ST_Transform" width="400" height="250" data-path="images/sql-functions/ST_Transform/ST_Transform.svg" />
