Clears the specified area of a raster object by filling it with a NoData value or zero.
Syntax
raster ST_EraseOverview(raster raster_obj, Box extent, BoxType type, boolean useNodata);Parameters
| Parameter | Description |
|---|---|
raster_obj | The raster object. |
extent | The area to clear, in the format '((minX,minY),(maxX,maxY))'. |
type | The coordinate system of the area. Valid values: Raster (pixel coordinates), World (world coordinates). |
useNodata | Specifies whether to fill the cleared area with the predefined NoData value. If set to false, or if no NoData value is defined, the area is filled with 0. |
Examples
SELECT ST_EraseOverview(raster_obj, '((0,0),(100,100))', 'Raster', false)
FROM raster_table
WHERE id = 100;