Skip to main content
Returns the centroid (point geometry) of the specified pixel’s area. The pixel coordinates specified are 1-indexed. If colX and rowY are out of bounds for the raster, they are interpolated assuming the same skew and translate values. RS_PixelAsCentroid

Signatures

RS_PixelAsCentroid(raster: Raster, colX: Integer, rowY: Integer)

Parameters

raster
Raster
required
The input raster.
colX
Integer
required
The col x value.
rowY
Integer
required
The row y value.

Return type

The resulting geometry.

Example

SELECT ST_AsText(RS_PixelAsCentroid(RS_MakeEmptyRaster(1, 12, 13, 134, -53, 9), 3, 3))
POINT (156.5 -75.5)