ST_RotateZ

ST_RotateZ
Prev	7.16. Affine Transformations	Next

Name

ST_RotateZ — Rotates a geometry about the Z axis.

geometry ST_RotateZ(geometry geomA, float rotRadians);

Rotates a geometry geomA - rotRadians about the Z axis.


	This is a synonym for ST_Rotate


	`ST_RotateZ(geomA, rotRadians)` is short-hand for `SELECT ST_Affine(geomA, cos(rotRadians), -sin(rotRadians), 0, sin(rotRadians), cos(rotRadians), 0, 0, 0, 1, 0, 0, 0)`.

Mejorado: 2.0.0 se introdujo soporte para superficies poliédricas, Triangulos y TIN.

Availability: 1.1.2. Name changed from RotateZ to ST_RotateZ in 1.2.2


	Anterior a 1.3.4, esta función daba errores si se utilizaba con geometrias que contenían CURVES. Esto se corrigió en 1.3.4+

This function supports 3d and will not drop the z-index.

This method supports Circular Strings and Curves.

This function supports Polyhedral surfaces.

This function supports Triangles and Triangulated Irregular Network Surfaces (TIN).

This example rotates a line 90 degrees around the Z axis.

SELECT ST_AsEWKT(ST_RotateZ(ST_GeomFromEWKT('LINESTRING(1 2 3, 1 1 1)'), pi()/2));

LINESTRING(-2 1 3,-1 1 1)

This example rotates a curved circle around the Z axis.

SELECT ST_AsEWKT(ST_RotateZ(geom, pi()/2))
FROM (SELECT ST_LineToCurve(ST_Buffer(ST_GeomFromText('POINT(234 567)'), 3)) As geom) As foo;

CURVEPOLYGON(CIRCULARSTRING(-567 237.00000000000003,-567 231.00000000000003,-567 237.00000000000003))