Olivier Leroy
About
Posts
Categories
All
(12)
CLI
(1)
DuckDB
(1)
Functional programming
(1)
GIS
(2)
OSM
(2)
PG
(2)
R
(4)
SQL
(1)
Sampling
(1)
Sensor
(1)
Smart environment
(1)
Spatstat
(1)
Time series
(1)
geojson
(1)
ggplot2
(1)
jq
(1)
learning
(1)
meme
(1)
plot
(1)
podcast
(1)
sf
(1)
survey
(1)
tree
(1)
urban forest
(1)
Function factories to improve Database read and write
R
PG
Functional programming
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…
Sep 15, 2024
Olivier Leroy
From elephant to duck!
DuckDB
R
SQL
PG
With John Hall we wrote a blog post about moving a table from postgres to a parquet file using duckdb.
Jul 14, 2024
Olivier Leroy
Awesome jq and GeoJSON
geojson
jq
CLI
GIS
I wrote a blog post about using
jq
for filtering geojson.
Mar 10, 2024
Olivier Leroy
Mapscaping: geospatial consulting – as a business and a career
podcast
GIS
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.
Jan 14, 2023
Olivier Leroy
R is (also) a graph calculator
R
plot
ggplot2
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…
Jan 10, 2023
Olivier Leroy
Using Go Map to contribute to OSM
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…
Jan 6, 2023
Olivier Leroy
Learning Data Science Meme
learning
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:
Jan 5, 2023
Olivier Leroy
Toying with DE-9IM
R
sf
exploring st_relate
Dec 23, 2021
Olivier Leroy
The Wonderfull World of Overpass Turbo
OSM
Some tips for Overpass Turbo
Oct 23, 2021
Olivier Leroy
Sampling Along a Line
Sampling
Spatstat
first part : Spatstat
Apr 8, 2021
Olivier Leroy
Sensor Observation Service: an Introduction
Sensor
Smart environment
Time series
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…
Feb 12, 2021
Olivier Leroy
Trees in Open Data Databases in France
urban forest
survey
tree
I collect tree data sets and here are some links to open data from France. I will update the list when I find more!
Jan 10, 2021
Olivier Leroy
No matching items