Skip to content

ST_Translate

Returns a geometry with coordinates translated by deltaX and deltaY.

Usage

geometry ST_Translate(geom: geometry, deltaX: double, deltaY: double)
geometry ST_Translate(geom: geometry, deltaX: double, deltaY: double, deltaZ: double)

Arguments

  • geom (geometry): Input geometry
  • deltaX (double)
  • deltaY (double)
  • deltaZ (double)

Description

Translates (shifts) a geometry by the given deltaX and deltaY offsets. A 3D variant accepts deltaZ.

Examples

SELECT ST_Translate(ST_GeomFromText('POINT(1 3)'), 1, 2);

┌─────────────────────────────────────────────────────────────────────┐
│ st_translate(st_geomfromtext(Utf8("POINT(1 3)")),Int64(1),Int64(2)) │
│                               geometry                              │
╞═════════════════════════════════════════════════════════════════════╡
│ POINT(2 5)                                                          │
└─────────────────────────────────────────────────────────────────────┘