Retrieve bounding envelope of geometries or rasters.

Retrieve bounding envelope (rectangle) of all geometries or rasters in a PostGIS table as a sfc object.

Usage

pgGetBoundary(conn, name, geom = "geom", clauses = NULL, returnclass = "sf")

conn: A connection object to a PostgreSQL database
name: A character string specifying a PostgreSQL schema and table/view name holding the geometry (e.g., name = c("schema","table"))
geom: A character string specifying the name of the geometry column in the table name (Default = "geom"). Note that for raster objects you will need to change the default value
clauses: character, additional SQL to append to modify select query from table. Must begin with an SQL clause (e.g., "WHERE ...", "ORDER BY ...", "LIMIT ..."); same usage as in pgGetGeom.
returnclass: 'sf' by default; 'terra' for SpatVector; or 'sp' for sp objects.

object of class sfc (list-column with geometries); SpatVector or sp object

if (FALSE) { # \dontrun{
pgGetBoundary(conn, c("schema", "polys"), geom = "geom")
pgGetBoundary(conn, c("schema", "rasters"), geom = "rast")
} # }