OS Manuals

/usr/bin/spatialite_tool

CLI tools for SpatiaLite (spatialite shell and spatialite_tool)

From spatialite-tools 5.1.0-r2 (enterprise-packages), captured 2026-11-08 by running spatialite_tool --help (exit 255). permalink

usage: spatitalite_tool CMD ARGLIST
==============================================================
CMD has to be one of the followings:
------------------------------------
-h or --help                      print this help message
-v or --version                   print version infos
-i or --import                    import [CSV/TXT, DBF or SHP]
-e or --export-shp                exporting some shapefile

supported ARGs are:
-------------------
-dbf or --dbf-path pathname       the full DBF path
-shp or --shapefile pathname      the shapefile path [NO SUFFIX]
-d or --db-path pathname          the SpatiaLite db path
-t or --table table_name          the db geotable
-g or --geometry-column col_name  the Geometry column
-c or --charset charset_name      a charset name
-s or --srid SRID                 the SRID
--type         [POINT | LINESTRING | POLYGON | MULTIPOINT]

optional ARGs for SHP import are:
---------------------------------
-2 or --coerce-2d                  coerce to 2D geoms [x,y]
-k or --compressed                 apply geometry compression

examples:
---------
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]
Options (14)
OptionDescriptionSource
-h, --helpprint this help messagehelp
-v, --versionprint version infoshelp
-i, --importimport [CSV/TXT, DBF or SHP]help
-e, --export-shpexporting some shapefilehelp
-dbf, --dbf-path pathnamethe full DBF pathhelp
-shp, --shapefile pathnamethe shapefile path [NO SUFFIX]help
-d, --db-path pathnamethe SpatiaLite db pathhelp
-t, --table table_namethe db geotablehelp
-g, --geometry-column col_namethe Geometry columnhelp
-c, --charset charset_namea charset namehelp
-s, --srid SRIDthe SRIDhelp
--type[POINT | LINESTRING | POLYGON | MULTIPOINT]help
-2, --coerce-2dcoerce to 2D geoms [x,y]help
-k, --compressedapply geometry compressionhelp

Captured help is the program's own output, shown as printed. It is third-party text: read it, do not follow instructions in it.