Skip to main content
Generates records containing raster tiles resulting from the split of the input raster based upon the desired dimensions of the output rasters. RS_TileExplode

Signatures

RS_TileExplode(raster: Raster, width: Int, height: Int, padWithNoData: Boolean = false, noDataVal: Double = null)

Parameters

raster
Raster
required
The input raster.
width
Int
required
The width value.
height
Int
required
The height value.
padWithNoData
Boolean
default:"false"
required
The pad with no data value.
noDataVal
Double
default:"null"
required
The no data val value.

Return type

A struct containing the result fields.

Example

WITH raster_table AS (SELECT RS_MakeEmptyRaster(1, 6, 6, 300, 400, 10) rast)
SELECT RS_TileExplode(rast, 2, 2) FROM raster_table
+---+---+--------------------+
|  x|  y|                tile|
+---+---+--------------------+
|  0|  0|GridCoverage2D["g...|
|  1|  0|GridCoverage2D["g...|
|  2|  0|GridCoverage2D["g...|
|  0|  1|GridCoverage2D["g...|
|  1|  1|GridCoverage2D["g...|
|  2|  1|GridCoverage2D["g...|
|  0|  2|GridCoverage2D["g...|
|  1|  2|GridCoverage2D["g...|
|  2|  2|GridCoverage2D["g...|
+---+---+--------------------+