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

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

This is gonna be a short post about a little trick I’ve been using while developing Shiny Apps. (Spoiler: nothing revolutionary) A browser anywhere, anytime The first thing to do is to insert an action button, and a browser() in the observeEvent() watching this button. This is a standard approach: at any time, you just press this button, and you’re ...

Once upon a time, there was a team of fearless R knights who started a new quest: they were missioned to bring the almighty Google Auth into the wonderful world of ShinyProxy. Here is their story, told from the inside.   In the beginning, there was a container For those amongst our readers who do not know ShinyProxy, this open ...

Because I was tired of typing the same thing over and over. I finally took the time to make myself a little Rstudio snippet. To do this just go to Tools > global Option > code > edit snippet and to add in the list these few lines : snippet aa ${1:dataset} <- ${1:dataset} %>% ${0} This is the Result ...