spatialite_tool(1)

💖 spatialite_tool — bestie edition 💖

okay so like, this is the manual page for spatialite_tool(1), and if you're reading this you're probably about to move a whole Shapefile situation in or out of a SpatiaLite database. don't panic, I got you 🫶

---

✨ NAME ✨

spatialite_tool — the CLI tool for Shapefile import / export. it's giving "small utility, big job" fr fr 💅

---

🌈 SYNOPSIS 🌈

spatialite_tool [-h | -i | -e] [-dbf pathname] [-shp pathname] [-d
                pathname] [-t table_name] [-g col_name] [-c
                charset_name] [-s SRID] [--type [POINT | LINESTRING |
                POLYGON | MULTIPOINT] ] [-2] [-k]

---

🦋 DESCRIPTION 🦋

spatialite_tool is a utility CLI tool for Shapefile import / export. that's it, that's the whole vibe — it takes your files and it puts them places, or takes them from places and gives them back as files. iconic 👑

---

🎀 OPTIONS 🎀

• -h, --help — shows you the help message. the "bestie pls explain" flag 🌸
• -i, --import — import mode! (CSV/TXT, DBF or SHP) — yes bestie it eats all three 💖
• -e, --export-shp — export mode, for exporting some shapefile ✨
• -dbf pathname, --dbf-path pathname — the full DBF path 📁
• -shp pathname, --shapefile pathname — the shapefile path — and IMPORTANT: NO SUFFIX, okay? don't add .shp, she doesn't want it 😭
• -d pathname, --db-path pathname — the SpatiaLite DB path 🗄️
• -t table_name, --table table_name — the db geotable (the one you're reading from or dumping into) 🌺
• -g col_name, --geometry-column col_name — the Geometry column 🧚
• -c charset_name, --charset charset_name — a charset name 💜
• -s SRID, --srid SRID — the SRID 🔥
• --type [POINT | LINESTRING | POLYGON | MULTIPOINT] — the geometry type ⭐
• -2, --coerce-2d — coerce to 2D geoms (x,y). bye bye Z, no cap 💀
• -k, --compressed — apply geometry compression 🎀

---

🌸 EXAMPLE 🌸

spatialite_tool -i -dbf abc.dbf -d db.sqlite -t tbl -c CP1252

spatialite_tool -i -shp abc -d db.sqlite -t tbl -c CP1252 [-s 4326] [-g geom]

spatialite_tool -i -shp abc -d db.sqlite -t tbl -c CP1252 [-s 4326] [-2] [-k]

spatialite_tool -e -shp abc -d db.sqlite -t tbl -g geom -c CP1252 [--type POINT]

like, look at her go 🥹 the square brackets are optional extras — plug them in when you need them, leave them out when you don't.

---

okay and for the little sign-off moment: this page lives in the spatialite_tool(1) manual, and it's dated 9 February 2026. that's the whole thing, bestie — go import something slay 💖✨🦋🌸💅🫶👑