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

2019-03-08 / Sébastien Rochette / dataviz, maps, tips

SatRday Paris: Build interactive waffle plots

Can mapping tools be diverted to other uses? Of course ! See how we play with leaflet and leafgl to quickly render a giant waffle made of millions of polygons. Spatial tools are not only for spatial data At SatRday in Paris, I presented a talk entitled “Everything but maps with spatial tools”. The aim is to show that there ...