The suffixes shown are prefixed by the current <WriterKeyword> in a mapping file. By default, the <WriterKeyword> for the SpatiaLite writer is SPATIALITE.
DATASET
The value for this directive is the path to the SpatiaLite database as specified by the writer overview.
Required/Optional
Required
Mapping File Syntax
SPATIALITE_DATASET “C:\dbs\polygons.sl3”
Workbench Parameter
Destination SpatiaLite Database File
ENCODING
Required/Optional: Optional
The value for this directive determines how FME will interpret string data stored in the SpatiaLite database.
Workbench Parameter: Character Encoding
Example:
SPATIALITE_ENCODING utf-8
OVERWRITE_TABLES
Required/Optional
Required
The value for this directive determines whether or not a table will be deleted before writing to it. If no features are written to the corresponding feature type then the table will not be deleted.
When the table is deleted it cannot be recovered, all data is lost.
Values
Yes | No (default)
Workbench Parameter
Overwrite Existing Database
CREATE_SPATIAL_INDEX
The value for this directive determines whether or not a spatial index will be created for tables this writer creates.
This only affects newly created or overwritten tables; tables that are updated will not have spatial indexes created for them.
Required/Optional
Required
Values
Yes | No (default)
Workbench Parameter
Create Spatial Index
COMPRESS_GEOMETRY
The value for this directive determines whether or not lines and polygons will be written SpatiaLite’s compressed geometry format. This only affects newly created tables.
Required/Optional
Required
Values
Yes (default) | No
Workbench Parameter
Compress Geometry
GENERIC_GEOMETRY
The value for this directive determines whether created tables will allow any geometry or whether a specific geometry type must be chosen for each table. If choosing not to write generic geometry then each writer feature type will have an option to select the specific geometry and a default may be provided based on the reader feature type geometry and the coordinate dimension at generation time. This only affects newly created tables.
Required/Optional
Required
Values
Yes (default) | No
Workbench Parameter
Generic Geometry
COORDINATE_DIMENSION
The value for this directive determines the default dimension of any created tables. Incoming feature geometries will we forced to comply with the dimension in the table. This only affects newly created tables.
Required/Optional
Required
Values
XY | XYZ (default)
Workbench Parameter
Spatial Coordinate Dimension
TRANSACTION_SIZE
This directive determines the number of features that FME will place in each transaction before a transaction is committed to the database.
If not specified, then a value of 1000 is used as the transaction interval.
Required/Optional
Required
Mapping File Syntax
SPATIALITE_TRANSACTION_SIZE 2500
Default Value:
1000
Workbench Parameter
Transaction Interval