ST_Affine(DOUBLE, DOUBLE, DOUBLE, DOUBLE, DOUBLE, DOUBLE, DOUBLE, DOUBLE, DOUBLE, DOUBLE, DOUBLE, DOUBLE) method

Returns a new geometry that is the result of applying the specified 3-D affine transformation.

Syntax

geometry-expression.ST_Affine(DOUBLE a00, DOUBLE a01, DOUBLE a02, DOUBLE a10, DOUBLE a11, DOUBLE a12, DOUBLE a20, DOUBLE a21, DOUBLE a22, DOUBLE xoff, DOUBLE yoff, DOUBLE zoff)

Parameters

a00 – The affine matrix element in row 0, column 0
a01 – The affine matrix element in row 0, column 1
a02 – The affine matrix element in row 0, column 2
a10 – The affine matrix element in row 1, column 0
a11 – The affine matrix element in row 1, column 1
a12 – The affine matrix element in row 1, column 2
a20 – The affine matrix element in row 2, column 0
a21 – The affine matrix element in row 2, column 1
a22 – The affine matrix element in row 2, column 2
xoff – The x offset for translation
yoff – The y offset for translation
zoff – The z offset for translation

Returns

ST_Geometry Returns a new geometry that is the result of the specified transformation.

Examples

Example 1 – The following returns the result LineString (5 6, 5 3, 9 3). The X values are translated by 5 and the Y values are translated by -1.
```
SELECT Shape.ST_Affine( 1,0,0, 0,1,0, 0,0,1, 5,-1,0 )
FROM SpatialShapes WHERE ShapeID = 5
```
The following returns the result LineString (.698833 6.965029, .399334 3.980017, 4.379351 3.580683). The Shape is rotated around the Z axis by 0.1 radians (about 5.7 degrees).
```
SELECT Shape.ST_Affine( cos(0.1),sin(0.1),0, -sin(0.1),cos(0.1),0, 0,0,1, 0,0,0 )
FROM SpatialShapes WHERE ShapeID = 5
```

Standards

SQL/MM (ISO/IEC 13249-3: 2006) Vendor extension