All Products
Search

This Product

    PolarDB:ST_ScaleY

    Document Center

    PolarDB:ST_ScaleY

    Last Updated:Mar 28, 2026

    Returns the pixel size of a raster object along the Y axis in the spatial reference system (SRS) units.

    Prerequisites

    The raster object must have a valid spatial reference system identifier (SRID).

    Syntax

    float8 ST_ScaleY(raster raster_obj)

    Parameters

    ParameterDescription
    raster_objThe name of the raster object.

    Examples

    Query the X and Y pixel sizes of rasters in raster_table:

    SELECT ST_ScaleX(rast), ST_ScaleY(rast)
FROM raster_table;

    Output:

     st_scalex | st_scaley
-----------+-----------
       1.3 |       0.3