Spatialite Writer Parameters
Database Connection
The path to the SpatiaLite 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.
If a template file is specified, the destination file is replaced with a copy of the template before writing begins.
Table Creation
Specifies whether to create generic geometry columns in newly-created tables. If No is specified, the geometry column dimensions must be specified (below).
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.
If Yes is specified, lines and polygons are written to newly-created tables in SpatiaLite’s compressed geometry format.
Creates a spatial index for the tables produced by the writer.
Advanced
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.