These parameters apply only to individual feature types.
Note: If there is both a writer-level parameter and a feature type parameter, the writer option will be ignored and the feature type parameter will be used.
Opening Feature Type Parameters
In Workbench, format parameters are visible in the Feature Type Properties dialog.
After you create a new workspace or add a writer, select a Writer Feature Type and click the properties button.
In the Feature Type Properties dialog, click the Format Parameters tab.
Drop Existing Table
This parameter determines whether or not a table will be deleted before writing to it. If no features are written to the corresponding feature type, the table will not be deleted.
Note: When the table is deleted, it cannot be recovered: all data is lost.
Mapping File Syntax
spatialite_overwrite_tables
Required/Optional: Required
Values: Yes | No (default)
Compress Geometry
The value for this parameterdetermines whether or not lines and polygons will be written SpatiaLite’s compressed geometry format. This only affects newly created tables.
Mapping File Syntax
spatialite_compress_geometry
Required/Optional: Required
Parameter Options: Yes(default) | No
Create Spatial Index
The value for this parameterdetermines whether or not a spatial index will be created for tables this writer creates.
Note: This only affects newly created or overwritten tables. Tables that are updated will not have spatial indexes created for them.
Mapping File Syntax
spatialite_create_spatial_index
Required/Optional: Required
Values: Yes | No (default)