2019-04-28 / Sébastien Rochette / database, docker, maps, tips

Interact with PostGIS from R

PostGIS extends capabilities of PostgreSQL database to deal with spatial data. Using PostGIS, your database supports geographic queries to be run directly in SQL. In this blog post, we will connect and interact with a PostGIS database from R, using {DBI} and {sf}. Package {sf} and PostGIS are friends Package {sf} is similar to PostGIS database in multiple ways: R ...