rpostgis (version 1.4.3)

pgGetPolys: Load a PostGIS polygon geometry from a PostgreSQL table/view into R.

Description

Load a PostGIS polygon geometry from a PostgreSQL table/view into R.

Usage

pgGetPolys(
  conn,
  name,
  geom = "geom",
  gid = NULL,
  other.cols = "*",
  clauses = NULL
)

Value

SpatialPolygonsDataFrame or SpatialPolygons

Author

David Bucklin

Mathieu Basille

Examples

if (FALSE) {
pgGetPolys(conn, c("schema", "tablename"))
pgGetPolys(conn, c("schema", "states"), geom = "statesgeom",
    gid = "state_ID", other.cols = "area,population",
    clauses  = "WHERE area > 1000000 ORDER BY population LIMIT 10")
}