Skip to content

ST_Affine

Applies an affine transformation to a geometry.

Usage

geometry ST_Affine(geom: geometry, a: double, b: double, d: double, e: double, xOff: double, yOff: double)
geometry ST_Affine(geom: geometry, a: double, b: double, c: double, d: double, e: double, f: double, g: double, h: double, i: double, xOff: double, yOff: double, zOff: double)

Arguments

  • geom (geometry)
  • a (double)
  • b (double)
  • c (double)
  • d (double)
  • e (double)
  • f (double)
  • g (double)
  • h (double)
  • i (double)
  • xOff (double)
  • yOff (double)
  • zOff (double)

Examples

SELECT ST_AsText(ST_Affine(ST_GeomFromText('POINT (1 2)'), 1, 0, 0, 1, 10, 20));

┌──────────────────────────────────────────────────────────────────────────────┐
│ st_astext(st_affine(st_geomfromtext(Utf8("POINT (1 2)")),Int64(1),Int64(0),I │
│                    nt64(0),Int64(1),Int64(10),Int64(20)))…                   │
╞══════════════════════════════════════════════════════════════════════════════╡
│ POINT(11 22)                                                                 │
└──────────────────────────────────────────────────────────────────────────────┘