Using DuckDB to extract custom OpenStreetMap data

The useful part

This tag represents a name in Friulian language, mainly spoken in north-east Italy. This tag is visible today in a dedicated rendering (which I created) on mapefurlane.eu and in the various multi-lingual maps like the great Americana. For Friulian language, there is already a list provided by an official organization, but besides not being very detailed, it's also quite static (PDF).

How it works

• What is DuckDB DuckDB is an open source in-process SQL OLAP database management system.
• Thanks to the work of several contributors, the usage of name:fur tag in OpenStreetMap is constantly increasing and there is now a pretty good coverage of Friuli region at place level (and even down to...
• So I wanted to have something better than that by leveraging all OSM data.

Details worth keeping

Using DuckDB with OpenStreetmap Since I already had a daily pipeline (GitHub Action) to update Mape Furlane that used a PBF extract as input, integrating DuckDB there was immediate: just adding the single binary, loading the PBF and then...