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

# spatialite\_xml\_collapse(1)

simplify any DB-file created by spatialite\_xml\_load(1)

## NAME

spatialite\_xml\_collapse - simplify any DB-file created by [spatialite\_xml\_load(1)](/spatialite_xml_load/1.md)

## SYNOPSIS

FC**spatialite\_xml\_collapse**F\[0\]  \[FC**-h**F\[0\]\] \[FC**-d**F\[0\] *pathname*\] \[FC**-dd**F\[0\]\] \[FC**-nl**F\[0\] *num*\] \[FC**-jo**F\[0\]\] \[FC**-cs**F\[0\] *num*\] \[FC**-m**F\[0\]\]

## DESCRIPTION

**spatialite\_xml\_collapse** is intended to simplify (by collapsing any not strictly required ramification) any DB-file created by [**spatialite\_xml\_load**(1)](/spatialite_xml_load/1.md).

Collapsing a DB-file is a final irreversible operation.

## OPTIONS

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

  show help message

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

  the SpatiaLite DB path

- FC**-dd**F\[0\], FC**--delete-duplicates**F\[0\]

  remove all duplicate rows except one

- FC**-nl**F\[0\] *num*, FC**--nl-level**F\[0\] *num*

  tree-level for table-names (default: 0)

- FC**-jo**F\[0\], FC**--journal-off**F\[0\]

  unsafe \[but faster\] mode

- FC**-cs**F\[0\] *num*, FC**--cache-size**F\[0\] *num*

  DB cache size (how many pages)

- FC**-m**F\[0\], FC**--in-memory**F\[0\]

  using IN-MEMORY database