Skip to content
🎉 Apache Sedona 1.8.1 is now available! Check out the new features and improvements.

RS_PixelAsCentroid

Introduction: 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.

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

Since: v1.5.0

SQL Example

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

Output:

POINT (156.5 -75.5)