R Interface to a 'PostGIS' Database
Return indexes for an exact number of blocks for a raster
Add key.
Converts to timestamp.
Builds CREATE TABLE query for a data frame object.
Add or remove a column.
Comment table/view/schema.
Check if a supported PostgreSQL connection
Drop table/view/schema.
Check if a PostgreSQL table/view exists
Get definitions for data frame mode reading
Create an index.
Check and create schema.
Get information about table columns.
Format input for database schema/table names.
Vacuum.
Returns major.minor version of PostgreSQL (for version checking)
Write/read in data frame mode to/from database table.
Check if geometry or geography column exists in a table, and return th...
Retrieve bounding envelope of geometries or rasters.
Load a PostGIS geometry from a PostgreSQL table/view/query into R.
Load geometries from a full query and return a Spatial* object
Load raster from PostGIS database into R.
Get SRID(s) from a geometry/geography column in a full table
Inserts data into a PostgreSQL table.
Format R data objects for insert into a PostgreSQL table.
List geometries/rasters
Add a POINT or LINESTRING geometry field.
Check and create PostGIS extension.
Find (or create) PostGIS SRID based on CRS object.
Inserts data into a PostgreSQL table.
Write raster to PostGIS database table.
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'.
Useful links