The R Journal: article published in 2018, volume 10:1

rpostgis: Linking R with a PostGIS Spatial Database PDF download
David Bucklin and Mathieu Basille , The R Journal (2018) 10:1, pages 251-268.

Abstract With the proliferation of sensors and the ease of data collection from online sources, large datasets have become the norm in many scientific disciplines, and efficient data storage, management, and retrival is imperative for large research projects. Relational databases provide a solution, but in order to be useful, must be able to be linked to analysis and visualization tools, such as R. Here, we present a package intended to facilitate integration of R with the open-source database software PostgreSQL, with a focus on its spatial extension, PostGIS. The package rpostgis (version 1.4.1) provides methods for spatial data handling (vector and raster) between PostGIS-enabled databases and R, methods for R "data.frame"s storage in PostgreSQL, and a set of convenient wrappers for common database procedures. We thus expect rpostgis to be useful for both (1) existing users of spatial data in R and/or PostGIS, and (2) R users who have yet to adopt relational databases for their projects.

Received: 2017-07-07; online 2018-05-21, supplementary material, (1.7 KiB)
CRAN packages: rgdal, maptools, raster, RPostgreSQL, DBI, rpostgis, sp, rgeos, wkb, sf, rpostgisLT, adehabitatLT
CRAN Task Views cited directly: Spatial
CRAN Task Views implied by cited CRAN packages: Spatial, SpatioTemporal

CC BY 4.0
This article and supplementary materials are licensed under a Creative Commons Attribution 4.0 International license.

  author = {David Bucklin and Mathieu Basille},
  title = {{rpostgis: Linking R with a PostGIS Spatial Database}},
  year = {2018},
  journal = {{The R Journal}},
  doi = {10.32614/RJ-2018-025},
  url = {},
  pages = {251--268},
  volume = {10},
  number = {1}