PostGIS

ST_PixelAsCentroid
Prev	12.6. Raster Pixel Accessors and Setters	Next

ST_PixelAsCentroid

12.6. Raster Pixel Accessors and Setters

Name

ST_PixelAsCentroid — Returns the centroid (point geometry) of the area represented by a pixel.

geometry +`*`+ST_PixelAsCentroid*(`raster `rast, integer x, integer y`)`;

Returns the centroid (point geometry) of the area represented by a pixel.

Enhanced: 3.2.0 Faster now implemented in C.

Availability: 2.1.0

SELECT ST_AsText(ST_PixelAsCentroid(rast, 1, 1)) FROM dummy_rast WHERE rid = 1;

  st_astext
--------------
 POINT(1.5 2)