RS_BandNoDataValue¶
Introduction: Returns the no data value of the given band of the given raster. If no band is given, band 1 is assumed. The band parameter is 1-indexed. If there is no data value associated with the given band, RS_BandNoDataValue returns null.
Note
If the given band does not lie in the raster, RS_BandNoDataValue throws an IllegalArgumentException
Format: RS_BandNoDataValue (raster: Raster, band: Integer = 1)
Since: v1.5.0
SQL Example
SELECT RS_BandNoDataValue(raster, 1) from rasters;
Output:
0.0
SQL Example
SELECT RS_BandNoDataValue(raster) from rasters_without_nodata;
Output:
null
SQL Example
SELECT RS_BandNoDataValue(raster, 3) from rasters;
Output:
IllegalArgumentException: Provided band index 3 is not present in the raster.