Returns an array of rasters resulting from the split of the input raster based upon the desired dimensions of the output rasters.
Signatures
RS_Tile(raster: Raster, width: Int, height: Int, padWithNoData: Boolean = false, noDataVal: Double = null)
Parameters
padWithNoData
Boolean
default:"false"
required
The pad with no data value.
noDataVal
Double
default:"null"
required
The no data val value.
Return type
Examples
WITH raster_table AS (SELECT RS_MakeEmptyRaster(1, 6, 6, 300, 400, 10) rast)
SELECT RS_Tile(rast, 2, 2) AS tiles FROM raster_table
+--------------------+
| tiles|
+--------------------+
|[GridCoverage2D["...|
+--------------------+
User can use EXPLODE function to expand the array of tiles into a table of tiles.
WITH raster_table AS (SELECT RS_MakeEmptyRaster(1, 6, 6, 300, 400, 10) rast)
SELECT EXPLODE(RS_Tile(rast, 2, 2)) AS tile FROM raster_table
+--------------------+
| tile|
+--------------------+
|GridCoverage2D["g...|
|GridCoverage2D["g...|
|GridCoverage2D["g...|
|GridCoverage2D["g...|
|GridCoverage2D["g...|
|GridCoverage2D["g...|
|GridCoverage2D["g...|
|GridCoverage2D["g...|
|GridCoverage2D["g...|
+--------------------+