Spatialite Writer Parameters

Database Connection

ClosedSpatiaLite Database

The path to the SpatiaLite database.

ClosedOverwrite Existing Database
  • If this option is unchecked (default) and a database already exists, then tables and features are written to the existing database.
  • If this option is checked, any existing database is deleted before writing begins.

If no database exists when writing begins, a new database is created.

Note: After a database is deleted, it cannot be recovered – all data is lost.

ClosedTemplate File

If a template file is specified, the destination file is replaced with a copy of the template before writing begins.

Table Creation

ClosedCreate Generic Spatial Columns

Specifies whether to create generic geometry columns in newly-created tables. If No is specified, the geometry column dimensions must be specified (below).

ClosedSpatial Column Dimension

Specifies which geometry columns to create for newly-created tables. Columns can be created to support either 2D (XY) or 2.5D (XYZ) geometries.

This parameter is valid when Create Generic Spatial Columns is set to No.

ClosedCompress Geometry

If Yes is specified, lines and polygons are written to newly-created tables in SpatiaLite’s compressed geometry format.

ClosedCreate Spatial Index

Creates a spatial index for the tables produced by the writer.

Advanced

ClosedFeatures Per Transaction

This parameter specifies the number of features to be placed in each transaction before a transaction is committed to the database.

If not specified, the default value is 1000.