Layercake converts OpenStreetMap data into SQL-queryable tables using GeoParquet format, enabling efficient remote access via HTTP without requiring full downloads. Compatible with tools like DuckDB, GeoPandas, and QGIS, it preserves OpenStreetMap's native tag structure rather than imposing a new schema.
A technical guide on georeferencing the fictional Chernarus map from the game Arma II to a real location in northern Czechia near Ústí nad Labem, enabling use on GPS devices. The process involves downloading map tiles, stitching them together with shell scripts and ImageMagick, and then manually matching features to real coordinates using QGIS to create a Garmin-compatible KMZ file.