ST_PixelOfValue
Name
ST_PixelOfValue — Get the columnx, rowy coordinates of the pixel whose value equals the search value.
Synopsis
setof record
ST_PixelOfValue
(
raster
rast
,
integer
nband
,
double precision[]
search
,
boolean
exclude_nodata_value=true
)
;
setof record
ST_PixelOfValue
(
raster
rast
,
double precision[]
search
,
boolean
exclude_nodata_value=true
)
;
setof record
ST_PixelOfValue
(
raster
rast
,
integer
nband
,
double precision
search
,
boolean
exclude_nodata_value=true
)
;
setof record
ST_PixelOfValue
(
raster
rast
,
double precision
search
,
boolean
exclude_nodata_value=true
)
;
Description
Get the columnx, rowy coordinates of the pixel whose value equals the search value. If no band is specified, then band 1 is assumed.
Availability: 2.1.0
Examples
SELECT (pixels).* FROM ( SELECT ST_PixelOfValue( ST_SetValue( ST_SetValue( ST_SetValue( ST_SetValue( ST_SetValue( ST_AddBand( ST_MakeEmptyRaster(5, 5, -2, 2, 1, -1, 0, 0, 0), '8BUI'::text, 1, 0 ), 1, 1, 0 ), 2, 3, 0 ), 3, 5, 0 ), 4, 2, 0 ), 5, 4, 255 ) , 1, ARRAY[1, 255]) AS pixels ) AS foo val | x | y -----+---+--- 1 | 1 | 2 1 | 1 | 3 1 | 1 | 4 1 | 1 | 5 1 | 2 | 1 1 | 2 | 2 1 | 2 | 4 1 | 2 | 5 1 | 3 | 1 1 | 3 | 2 1 | 3 | 3 1 | 3 | 4 1 | 4 | 1 1 | 4 | 3 1 | 4 | 4 1 | 4 | 5 1 | 5 | 1 1 | 5 | 2 1 | 5 | 3 255 | 5 | 4 1 | 5 | 5