Name

ST_PixelAsPoint — Returns a point geometry of the pixel's upper-left corner.

Synopsis

geometry ST_PixelAsPoint(raster rast, integer columnx, integer rowy);

Description

Returns a point geometry of the pixel's upper-left corner.

Availability: 2.1.0

Examples

Code
SELECT ST_PixelAsPoint(rast, 1, 1) FROM dummy_rast WHERE rid = 1;
Output
POINT(0.5 0.5)
Figure
Geometry figure for visual-rt-st-pixelaspoint-01