RSSAmplifier

Blog

Olivier Leroy

Message in a bottle for me

branchtwigleaf.comRSS feed ↗18 posts

Latest posts

US Census Frames

Kasia Ozga, Spiderwebs, 2018. I was watching fedgeoday 2026 when a speaker from one of my favorite and trusted data source in the US, the “US Census Bureau”, introduced a change in their data infrastructure called “Frames”. Everyone seems to be aware of it but not me! To bridge my lack of understanding I went to the US Census website and searched for Frames. On the section “What is a Frame” 1 I…

“Forest Management Becomes a Desk Job”

Since I’ve noticed that I mostly blog about data and computer topics, I thought it was time to balance things out a bit. Today, I want to highlight a passage from a book we’re reading at home: Blue Ridge Commons by Kathryn Newfont . It offers an interesting perspective on forests and data. Quick overview: This won’t be a full-length book review, no time or plan for that but a bit of context: Blue…

QGIS Ricing!

Thanks to Atanas and Keith Jenkins I learned recently that older versions of QGIS have dogs on their splash screens (the screen when QGIS is loading). You can see them well archived by Thomas Gratier here I liked version 0.3, which gives off strong GEOINT vibes! What if I could replace the current splash screen 1 with this old one? @QGIS Development Team On Ubuntu, QGIS stores user profiles in:…

Improving my default bash prompt

Even though I am not a system admin, I work frequently in remote or virtual computers other than my desktop, and Ubuntu default terminal requires me to have my username, hostname, and full directory path in my prompt … whiiich tends to be a bit lengthy! Most of the time, I use zsh and oh-my-zsh. In 5 minutes, you can set up a nice config and call it a day (and I recommend doing that!). For some…

Codeberg links and icons!

I like GitHub (GH) but it seems like a good idea to learn about what other software forges are out there… ! You can find a great post about it here: https://mastodon.social/ @gvwilson/113945550159389620 Post by @gvwilson @mastodon.social View on Mastodon I will add to that: a bit of competition 1 is good discovering other implementations is always worth it. 1 GitLab is another option. While this…

Little Schemer

I have been reading and enjoying The Little Schemer ! It’s time to write a bit about it and structure what I learned so far (up to chapter 5). If you do not know about it I might start by giving a quick introduction. This book about recursion has a very specific and original way of teaching. Important I do not think it is a beginner’s book as it focuses a lot on building abstractions and relies on…

Function factories to improve Database read and write

Like a lot of organizations, my team uses databases (DB) to organize and centralize data. To simplify the team’s life and make our code less redundant, we use functions, in an internal R package, that manage connecting to the DB, writing and reading to it (see Emily Riederer’s website for a great post about that idea 1 ). I think those functions are great and remove a lot of “boilerplate code”…

From elephant to duck!

With John Hall we wrote a blog post about moving a table from postgres to a parquet file using duckdb. There are a lot of conversations — understandably — on the use of Apache Parquet, Apache Arrow and DuckDB. […] Let’s see an example of how they can be used to convert a table in a PostgresSQL database to a parquet file: You can find the post on CORI’s Map and data analytics team blog .

Awesome jq and GeoJSON

I wrote a blog post about using jq for filtering geojson. If you are manipulating a lot of GeoJSON features/objects and want a quick CLI tool to filter and slice them, you should give jq a try! Since there are not many tutorials that exist on using jq to manage objects in the GeoJSON family, we hope that these few tricks will help you on your learning journey. You can find the post on CORI’s Map…

Mapscaping: geospatial consulting – as a business and a career

The Mapscaping Podcast is a great podcast in the “geospatial” space. It covers a broad diversity of topics and the production value is always top notch. I was quite interested in the last episode geospatial consulting – as a business and a career and wanted to share some of the little gems this episode has to offer. The episode was an interview with Todd Slind (VP of Technology) at Locana.co about…

R is (also) a graph calculator

I am doing some basic maths. I was to frustrate of Roger Bivand explaining stuff that I could not understand with my maths background (science background but loooong time ago!). I find a nice free book and practice with it. A lot can be done with pen + paper but sometimes you need to represent an equation in a Cartesian plane. R is perfect for that (even if it is not a Computer algebra system )…

Using Go Map to contribute to OSM

I was a bit intimidated to contribute to OSM and it took me time to do it. I needed to move to another country, get a correct smartphone (I was for a long time a Nokia 3310 user) and have some baby to move around in a stroller to decide myself! If you were like me, hesitating, you should not and I will try to explain why and how you can contribute. A very quick introduction to OpenStreetMap! OSM…

Learning Data Science Meme

I know that I should not bother too much about some meme and just enjoy them like some cheap beer (yes, I enjoy cheap beer) but I would like to react to this one: /rant on Where am I? As a R user I guess I am probably in one of the slopes :). I do not know Rust, Scala, C++, C#, SAS, etc so I guess I am on the left side of it. Like every meme you can find plenty of interpretations (and I like…

Toying with DE-9IM

This little text below is from a reply I posted to issue . I tried to help a bit and I learned a lot at the same time! The discussion topic was the st_relate function in the sf great package. this function implements the Dimensionally Extended 9-Intersection Model (DE-9IM) 1 or intersection matrix. The intersection matrix is a 3 x 3 matrix that defines all possible pair-wise combinations of…

The Wonderfull World of Overpass Turbo

I use Overpass Turbo a lot and every time, I rediscover new amazing stuff to do with it. This is one of the many gems in the OpenStreetMap ecosystem! In this post, I will assume a basic understanding of OpenStreetMap (OSM) data structure, but if you want a quick quality refresher, I really like the one in Overpass API’s User Manual . What is Overpass Turbo? Overpass Turbo is a frontend for…

Sampling Along a Line

Recently, someone posted a question on Linkedin about sampling along some lines. It may not be obvious for everyone why anyone would like to do that so let’s provide some examples: sampling in a river every N meters, sampling species diversity along transects. The lines or segments can be used as a way to measure some kind of gradient or to follow something that can be represented as a line. A…

Sensor Observation Service: an Introduction

Thanks to SIST and the financial support of my lab, I was able to attend a training course on Sensor Observation Services (SOS) with one of my coworkers. It’s time to reflect a bit on what we learned! Why do Sensors matter for a geographer/social scientist? My previous experience with sensors was limited to academic contexts; I remember using them in forests to collect information (temperature,…

Trees in Open Data Databases in France

I collect tree data sets and here are some links to open data from France. I will update the list when I find more! You can find out more about my work on my github . To extract the trees from the files I needed to do a bit of data wrangling. Guingamp Typical lat/long in field. guingamp <- sf :: st_read ( "sources/Arbres de la Ville de Guingamp.csv" ) guingamp <- sf :: st_as_sf (guingamp, coords =…