All Products
Search
Document Center

PolarDB:ST_ConvexHull

Last Updated:Mar 28, 2026

Returns the minimum convex geometry that encloses all geometries within a raster.

Syntax

geometry ST_ConvexHull(raster source);
geometry ST_ConvexHull(raster source, integer pyramid);

Parameters

ParameterDescription
sourceThe raster to compute the convex hull for.
pyramidThe pyramid level of the raster. Valid values start from 0. Default value: 0.

Description

ST_ConvexHull returns the smallest convex geometry that wraps the full extent of the raster data. Think of it as stretching a rubber band around all pixel positions in the raster.

Minimum convex geometry

Examples

Get the convex hull of a raster at the default pyramid level (0):

SELECT st_astext(st_convexhull(rast_object))
FROM raster_table;

----------------------------------------------------
 POLYGON((-180 90,180 90,180 -90,-180 -90,-180 90))

Get the convex hull at a specific pyramid level:

--Specify the pyramid level at which the raster resides.
SELECT st_astext(st_convexhull(rast_object,  1))
FROM raster_table;

----------------------------------------------------
 POLYGON((-180 90,180 90,180 -90,-180 -90,-180 90))