> ## 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_Translate

Returns the input geometry with its X, Y and Z coordinates (if present in the geometry) translated by deltaX, deltaY and deltaZ (if specified)

If the geometry is 2D, and a deltaZ parameter is specified, no change is done to the Z coordinate of the geometry and the resultant geometry is also 2D.

If the geometry is empty, no change is done to it.
If the given geometry contains sub-geometries (GEOMETRY COLLECTION, MULTI POLYGON/LINE/POINT), all underlying geometries are individually translated.

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

## Signatures

```sql theme={"system"}
ST_Translate(geometry: Geometry, deltaX: Double, deltaY: Double, deltaZ: Double)
```

## Parameters

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

<ParamField body="deltaX" type="Double" required>
  The delta x value.
</ParamField>

<ParamField body="deltaY" type="Double" required>
  The delta y value.
</ParamField>

<ParamField body="deltaZ" type="Double" required>
  The delta z value.
</ParamField>

## Return type

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

## Examples

```sql theme={"system"}
SELECT ST_Translate(ST_GeomFromText('GEOMETRYCOLLECTION(MULTIPOLYGON(((3 2,3 3,4 3,4 2,3 2)),((3 4,5 6,5 7,3 4))), POINT(1 1 1), LINESTRING EMPTY)'), 2, 2, 3)
```

```
GEOMETRYCOLLECTION (MULTIPOLYGON (((5 4, 5 5, 6 5, 6 4, 5 4)), ((5 6, 7 8, 7 9, 5 6))), POINT (3 3), LINESTRING EMPTY)
```

```sql theme={"system"}
SELECT ST_Translate(ST_GeomFromText('POINT(-71.01 42.37)'),1,2)
```

```
POINT (-70.01 44.37)
```