RS_PixelAsCentroid

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.

Signatures

RS_PixelAsCentroid(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.

Example

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

POINT (156.5 -75.5)

⌘I

Wherobots Cloud REST API

WherobotsDB

Vector tiles (PMTiles)

Havasu (Iceberg) table management

GeoStats and Map Matching

Rasterflow

RS_PixelAsCentroid

Signatures

Parameters

Return type

Example

​Signatures

​Parameters

​Return type

​Example

Signatures

Parameters

Return type

Example