DuckDB - A game changer for analyzing OpenStreetMap

OpenStreetMap (OSM) is an invaluable resource for all kinds of geographic applications and research. This collection of voluntary geographic information provides highly detailed and semantically diverse data. For a recent paper, for example, I used OSM to derive local-scale public green availability in a nationwide analysis. At the start of the analysis, the question arose whether it was feasible at all to perform millions of spatial queries within an acceptable timeframe. After some testing, it became clear that the analyses I had in mind was feasible using a PostgreSQL/PostGIS database. This, however, came with the need for some tedious setup – at least for this use-case. ...

September 26, 2024

Beautify RMarkdown tables with beautifyR

RMarkdown Tables are nice, but kinda suck… RMarkdown is a nice tool for creating automated reports. Heck, it is even suited for creating beautiful slides which I haved used in the past for my introductory R course. However, one thing I always hated when working with Markdown, and even further in LaTeX, is working with tables. More specifically, maintaining a neat layout and not descending into table chaos. Everybody who has worked with Markdown tables at least once, probably has encounterd this issue. ...

February 4, 2021