ST_Rotate

Rotates a geometry by a specified angle in radians counter-clockwise around a given origin point. The origin for rotation can be specified as either a POINT geometry or x and y coordinates. If the origin is not specified, the geometry is rotated around POINT(0 0).

Signatures

ST_Rotate (geometry: Geometry, angle: Double)

ST_Rotate (geometry: Geometry, angle: Double, originX: Double, originY: Double)

ST_Rotate (geometry: Geometry, angle: Double, pointOrigin: Geometry)

Parameters

geometry

Geometry

required

The input geometry.

angle

Double

required

The angle value.

originX

Double

The origin x value.

originY

Double

The origin y value.

pointOrigin

Geometry

The point origin value.

Return type

The resulting geometry.

Example

SELECT ST_Rotate(ST_GeomFromEWKT('SRID=4326;POLYGON ((0 0, 1 0, 1 1, 0 0))'), 10, 0, 0)

SRID=4326;POLYGON ((0 0, -0.8390715290764524 -0.5440211108893698, -0.2950504181870827 -1.383092639965822, 0 0))

ST_Affine

ST_RotateX

⌘I

Wherobots Cloud REST API

WherobotsDB

Vector tiles (PMTiles)

Havasu (Iceberg) table management

GeoStats and Map Matching

Rasterflow

Signatures

Parameters

Return type

Example

​Signatures

​Parameters

​Return type

​Example

Signatures

Parameters

Return type

Example