ST_TransScale

ST_TransScale
Prev	4. Geometry Editors	Next

Name

ST_TransScale — Translates a geometry, and then scales it.

geometry ST_TransScale(bytea Geometry, double Tx, double Ty, double Tz, double Xscale, double Yscale, double Zscale);

geometry ST_TransScale(bytea Geometry, double Tx, double Ty, double Xscale, double Yscale);

TransScale

Translates a geometry, and then scales it.

Transformation matrix

Equations to transform the vertices


ST_TransScale (geomA, Tx, Ty, Tz, Xscale,Yscale,Zscale) is an abreviation for the method: ST_Affine(geomA, Xscale, 0, 0, 0, Yscale, 0, 0, 0, Zscale, TxXscale, TyYscale, Tz*Zscale)

ST_TransScale (geomA, Tx, Ty, Tz, Xscale,Yscale,Zscale) is an abreviation for the method:

ST_Affine(geomA, Xscale, 0, 0, 0, Yscale, 0, 0, 0, Zscale, Tx*Xscale, Ty*Yscale, Tz*Zscale)

2D	3D	M

OGC SFS for SQL. 1.1 (1999)	OGC SFS for SQL. 1.1.0 (2005)	OGC SFS for SQL. 1.2.0 (2006)	SQL-MM Part 3
-	-	-	-

SELECT ST_AsEWKT(ST_TransScale(ST_GeomFromEWKT('POINT (1 1 1 4)'),2,3,4,100,200,300));
--Result
POINT (300 800 1500 4)