pgisGetBbox: Get bbox of a table

In MiloMonnier/postgisr: R interface to PostGIS

Description

Get the extent of the geometry of a PostGIS table, in the same EPSG than table.

Usage

pgisGetBbox(conn, tbl, geom.col = "geometry")

Arguments

conn	a PostgreSQLConnection object.
tbl	character; table name.
geom.col	character; name of the geometry column (default: 'geometry).

Value

a bbox class object.

Examples

library(spData)
library(sf)
library(RPostgreSQL)
data(seine)
conn = dbConnect(drv=dbDriver("PostgreSQL"), host="localhost", port=5432,
                dbname="foodflows", user="milo", password="postgres")
dbWriteTable(conn, name="seine", seine, overwrite=TRUE)
bb = pgisGetBbox(conn, "seine")
(class(bb)=="bbox")
dbDisconnect(conn)

MiloMonnier/postgisr documentation built on Feb. 16, 2021, 8:03 p.m.