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 ...

2018-07-09 / Marion / data, database, tidyverse

The Ten Commandments for a well-formatted database

Our diligent readers already know how important having well formatted data is for efficient statistical analyses. Here we gathered some advice on how to make a well structured database, in order to perform accurate analyses, and avoid driving your fellow analysts crazy. We are very grateful to Marion Louveaux, bio-image analyst for this translation of french version “Une base de ...