RS_PixelAsPoint - Wherobots

Returns a point geometry of the specified pixel’s upper-left corner. The pixel coordinates specified are 1-indexed.

If colX or rowY is outside the raster grid, the coordinate is extrapolated using the raster’s scale, skew, and translation.

Signatures

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

Parameters

Raster

required

The input raster.

Integer

required

The col x value.

Integer

required

The row y value.

Return type

The resulting geometry.

Examples

SELECT ST_AsText(RS_PixelAsPoint(raster, 2, 1)) from rasters

POINT (123.19, -12)

The raster below is five pixels wide. Column 6 is immediately past the right edge; its upper-left corner lies on that edge at x = 123 + 5 × 8 = 163.

SELECT ST_AsText(RS_PixelAsPoint(RS_MakeEmptyRaster(1, 5, 10, 123, -230, 8), 6, 2))

POINT (163 -238)

​Signatures

​Parameters

​Return type

​Examples

Signatures

Parameters

Return type

Examples