rpostgis: R Interface to a 'PostGIS' Database

Provides an interface between R and 'PostGIS'-enabled 'PostgreSQL' databases to transparently transfer spatial data. Both vector (points, lines, polygons) and raster data are supported in read and write modes. Also provides convenience functions to execute common procedures in 'PostgreSQL/PostGIS'.

AuthorMathieu Basille [aut], David Bucklin [aut, cre]
Date of publication2017-01-19 00:00:59
MaintainerDavid Bucklin <dbucklin@ufl.edu>
LicenseGPL (>= 3)

View on CRAN

Man pages

dbAddKey: Add key.

dbAsDate: Converts to timestamp.

dbBuildTableQuery: Builds CREATE TABLE query for a data frame object.

dbColumn: Add or remove a column.

dbComment: Comment table/view/schema.

dbConnCheck: Check if a supported PostgreSQL connection

dbDrop: Drop table/view/schema.

dbExistsTable: Check if a PostgreSQL table exists

dbIndex: Create an index.

dbSchema: Check and create schema.

dbTableInfo: Get information about table columns.

dbTableNameFix: Format input for database schema/table names.

dbVacuum: Vacuum.

dbVersion: Returns major.minor version of PostgreSQL (for version...

dbWriteDataFrame: Write/read in data frame mode to/from database table.

pgGetBoundary: Retrieve bounding envelope of geometries or rasters.

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

pgGetLines: Load a PostGIS linestring geometry from a PostgreSQL...

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

pgGetPts: Load a PostGIS point geometry from a PostgreSQL table/view...

pgGetRast: Load raster from PostGIS database.

pgInsert: Inserts data into a PostgreSQL table.

pgInsertizeGeom: Format R data objects for insert into a PostgreSQL table.

pgListGeom: List geometries.

pgMakePts: Add a POINT or LINESTRING geometry field.

pgPostGIS: Check and create PostGIS extension.

pgSRID: Find (or create) PostGIS SRID based on CRS object.

pgWriteRast: Write raster to PostGIS database table.

roe_gps_data: Example data from a GPS tracking project

rpostgis: R interface to a PostGIS database.

Files in this package

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

All documentation is copyright its authors; we didn't write any of that.