Paper on our rpostgis package in the R journal

The paper on our rpostgis package is out in the R journal! This package provides an interface between R and PostGIS databases, with bidirectional transfer of both vector (points, lines, polygons) and raster data!

The paper provides a detailed overview of the package capabilities, with functions dedicated to spatial data, as well as general PostgreSQL management:

• PostGIS management:
  • Check and create PostGIS extension: pgPostGIS
  • List geometries/rasters: pgListGeom and pgListRast
  • Find (or create) PostGIS SRID based on CRS object: pgSRID
  • Spatial data transfer (vector data): pgInsert and pgGetGeom
  • Spatial data transfer (raster data): pgWriteRast and pgGetRast
  • Bounding box retrieval: pgGetBoundary
  • Add a POINT or LINESTRING geometry field: pgMakePts and pgMakeStp
• PostgreSQL functions and wrappers:
  • Storing R data.frames in PostgreSQL: dbWriteDataFrame and dbReadDataFrame
  • Check and create schema: dbSchema
  • Comment on table/view/schema: dbComment
  • Add or remove a column: dbColumn
  • Add a primary or foreign key: dbAddKey
  • Create an index: dbIndex
  • Convert to timestamp: dbAsDate
  • Garbage-collect and analyze a database (VACUUM): dbVacuum
  • Drop table/view/schema: dbDrop
  • Get information about table columns: dbTableInfo

See all the details of our paper here, with a link to the PDF and additional resources.

Mathieu