Retrieve bounding envelope (rectangle) of all geometries or
rasters in a PostGIS table as a sfc
object.
pgGetBoundary(conn, name, geom = "geom", clauses = NULL, returnclass = "sf")
A connection object to a PostgreSQL database
A character string specifying a PostgreSQL schema and
table/view name holding the geometry (e.g., name =
c("schema","table")
)
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
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
.
'sf' by default; 'terra' for SpatVector
;
or 'sp' for sp
objects.
object of class sfc (list-column with geometries); SpatVector or sp object