ST_Scale¶

Introduction: This function scales the geometry to a new size by multiplying the ordinates with the corresponding scaling factors provided as parameters scaleX and scaleY.

Note

This function is designed for scaling 2D geometries. While it currently doesn't support scaling the Z and M coordinates, it preserves these values during the scaling operation.

ST_Scale

Format: ST_Scale(geometry: Geometry, scaleX: Double, scaleY: Double)

Return type: Geometry

SQL Example:

SELECT ST_Scale(
        ST_GeomFromWKT('POLYGON ((0 0, 0 1.5, 1.5 1.5, 1.5 0, 0 0))'),
       3, 2
)

Output:

POLYGON ((0 0, 0 3, 4.5 3, 4.5 0, 0 0))