spatialite_osm_filter(1)

💖 spatialite_osm_filter 💖

okay bestie, gather round, because today we're talking about spatialite_osm_filter(1) — yes that's the whole manual-page name, she's a mouthful, but she's also iconic and she's here to help you get OSM-XML maps living happily inside a SpatiaLite DB. no cap. 🗺️✨

---

🌸 NAME 🌸

spatialite_osm_filter — loading OSM-XML maps into a SpatiaLite DB

like, that's the whole vibe. you bring the OSM-XML, she brings the SpatiaLite DB, and together you make magic. 🫶

---

✨ SYNOPSIS ✨

spatialite_osm_filter [-h] [-o pathname] [-w pathname] [-d pathname]
                      [-cs num] [-m] [-jo]

look at her. seven little knobs to twirl and you're off. so slay. 💅

---

🦋 DESCRIPTION 🦋

spatialite_osm_filter is a tool for loading OSM-XML maps into a SpatiaLite DB.

periodt. that's the job, that's the mission, that's what she does. simple, powerful, and lowkey carrying the entire workflow on her back. 👑

---

🎀 OPTIONS 🎀

• -h, --help — show help message

when you're lost (it happens to the best of us, bestie), this one just shows the help message. a little gentle hand on your shoulder. 💖

• -o pathname, --osm-path pathname — the OSM-XML (output) file path

this is where you tell her the OSM-XML (output) file path. the map source. the main character file. give her the path and let her cook. 🔥

• -w pathname, --wkt-mask-path pathname — path of text file [WKT mask]

the path of a text file holding a [WKT mask]. a lil filtering mask, if you will. fancy. 😌

• -d pathname, --db-path pathname — the SpatiaLite DB path

and here's the SpatiaLite DB path — where all the good stuff ends up. the destination. the VIP section. 🌈

• -cs num, --cache-size num — DB cache size (how many pages)

sets the DB cache size, which is measured in how many pages. more pages = more cozy room for the database to stretch out. ✨

• -m, --in-memory — using IN-MEMORY database

flips her into using an IN-MEMORY database. everything lives in RAM, nothing touches disk. snappy, chaotic, delicious. 🧚

• -jo, --journal-off — unsafe (but faster) mode

turning the journal off. she said "unsafe (but faster) mode" and honestly she means it — this is genuinely unsafe, so know what you're doing before you flip this switch. it's giving risky-but-quick. 😭💀

stay safe out there, bestie — -jo really is the "unsafe (but faster) mode" option, exactly like the page says. no take-backsies on a corrupted DB.

---

and that's the whole page, fr fr. this beauty comes to you from the SpatiaLite toolbox, dated 9 February 2026, and she's filed under spatialite_osm_filter(1) — remembering that date and that name is your lil homework for the day. go load some maps, you absolute legend. 💜🌸🦋✨