---
name: "spatialite_tool"
section: "1"
platform: "linux"
package: "spatialite-bin"
version: "5.1.0a-2"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/spatialite_tool"
---

# spatialite\_tool(1)

CLI tool for Shapefile import/export

## NAME

spatialite\_tool - CLI tool for Shapefile import/export

## SYNOPSIS

FC**spatialite\_tool**F\[0\]  \[FC**-h**F\[0\] \| FC**-i**F\[0\] \| FC**-e**F\[0\]\] \[FC**-dbf**F\[0\] *pathname*\] \[FC**-shp**F\[0\] *pathname*\] \[FC**-d**F\[0\] *pathname*\] \[FC**-t**F\[0\] *table\_name*\] \[FC**-g**F\[0\] *col\_name*\] \[FC**-c**F\[0\] *charset\_name*\] \[FC**-s**F\[0\] *SRID*\] \[FC**--type**F\[0\] \[POINT \| LINESTRING \| POLYGON \| MULTIPOINT\] \] \[FC**-2**F\[0\]\] \[FC**-k**F\[0\]\]

## DESCRIPTION

**spatialite\_tool** is an utility CLI tool for Shapefile import / export.

## OPTIONS

- FC**-h**F\[0\], FC**--help**F\[0\]

  show help message

- FC**-i**F\[0\], FC**--import**F\[0\]

  import (CSV/TXT, DBF or SHP)

- FC**-e**F\[0\], FC**--export-shp**F\[0\]

  exporting some shapefile

- FC**-dbf**F\[0\] *pathname*, FC**--dbf-path**F\[0\] *pathname*

  the full DBF path

- FC**-shp**F\[0\] *pathname*, FC**--shapefile**F\[0\] *pathname*

  the shapefile path (NO SUFFIX)

- FC**-d**F\[0\] *pathname*, FC**--db-path**F\[0\] *pathname*

  the SpatiaLite DB path

- FC**-t**F\[0\] *table\_name*, FC**--table**F\[0\] *table\_name*

  the db geotable

- FC**-g**F\[0\] *col\_name*, FC**--geometry-column**F\[0\] *col\_name*

  the Geometry column

- FC**-c**F\[0\] *charset\_name*, FC**--charset**F\[0\] *charset\_name*

  a charset name

- FC**-s**F\[0\] *SRID*, FC**--srid**F\[0\] *SRID*

  the SRID

- FC**--type**F\[0\] \[POINT \| LINESTRING \| POLYGON \| MULTIPOINT\]

  the geometry type

- FC**-2**F\[0\], FC**--coerce-2d**F\[0\]

  coerce to 2D geoms (x,y)

- FC**-k**F\[0\], FC**--compressed**F\[0\]

  apply geometry compression

## EXAMPLE

```
FC
spatialite_tool -i -dbf abc.dbf -d db.sqlite -t tbl -c CP1252
      F[0]
```

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

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

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