Returns the pixel coordinate box of a clipped area within a raster object's raster space.
Syntax
box ST_ClipDimension(raster raster_obj, integer pyramidLevel, box extent);Parameters
| Parameter | Type | Description |
|---|---|---|
| raster_obj | raster | The raster object. |
| pyramidLevel | integer | The pyramid level. |
| extent | box | The world space extent of the clipped area. |
Usage notes
The raster object must have a valid spatial reference system identifier (SRID).
Example
SELECT ST_ClipDimension(raster_obj, 2, '((128.0, 30.0),(128.5, 30.5))') FROM raster_table WHERE id = 10;Output:
'((200, 300),(600, 720))'该文章对您有帮助吗？