Descrizione

Rotates geometry rotRadians counter-clockwise about the origin point. The rotation origin can be specified either as a POINT geometry, or as x and y coordinates. If the origin is not specified, the geometry is rotated about POINT(0 0).

Migliorato: Nella 2.0.0 è stato introdotto il supporto per le superfici poliedriche, i triangoli e i TIN.

Enhanced: 2.0.0 additional parameters for specifying the origin of rotation were added.

Availability: 1.1.2. Name changed from Rotate to ST_Rotate in 1.2.2

Questa funzione supporta il 3d e non distrugge gli z-index.

Questo metodo supporta le Curve e le Circular String.

Questa funzione supporta le Polyhedral Surface.

Questa funzione supporta i Triangoli e le Triangulated Irregular Network Surfaces (TIN).

Esempi

This example rotates a geometry by 180 degrees.

SELECT ST_Rotate('LINESTRING (50 160,50 50,100 50)'::geometry, pi());

LINESTRING(-50 -160,-50 -50,-100 -50)

01020000000300000003000000000049C000000000000064C001000000000049C0FFFFFFFFFFFF48C000000000000059C0FEFFFFFFFFFF48C0

Figure

This example rotates a geometry 30 degrees counter-clockwise around x=50, y=160.

SELECT ST_Rotate('LINESTRING (50 160,50 50,100 50)'::geometry, pi()/6, 50, 160);

LINESTRING(50 160,105 64.737206,148.30127 89.737206)

01020000000300000000000000000049400000000000006440FFFFFFFFFF3F5A401D1E54602E2F5040F93E6101A48962401C1E54602E6F5640

Figure

This example rotates a geometry 60 degrees clockwise around its centroid.

SELECT ST_Rotate(geom, -pi()/3, ST_Centroid(geom))
FROM (SELECT 'LINESTRING (50 160,50 50,100 50)'::geometry AS geom) AS foo;

LINESTRING(116.4225 130.6721,21.1597 75.6721,46.1597 32.3708)

0102000000030000003CCCC890091B5D40D73137A0815560406AA973C4DF283540AE636E4003EB5240B7D439E26F14474077CB577B762F4040

Figure

Si veda anche

ST_Affine, ST_RotateX, ST_RotateY, ST_RotateZ