All Products
Search

This Product

    PolarDB:ST_UpperLeftY

    Document Center

    PolarDB:ST_UpperLeftY

    Last Updated:Mar 28, 2026

    Queries the upper-left Y coordinate of a raster object in the spatial reference system.

    Prerequisites

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

    Syntax

    float8 ST_UpperLeftY(raster raster_obj)

    Parameters

    ParameterDescription
    raster_objThe name of the raster object.

    Examples

    The following example queries the upper-left X and Y coordinates of all raster objects in raster_table.

    SELECT st_upperleftx(rast), st_upperlefty(rast)
FROM raster_table;

    Output:

     st_upperleftx | st_upperlefty
---------------+---------------
        440720 |       3751320