List of Supported Formats

Search the Online Transformer Gallery

Spatialite Writer Parameters

Database Connections

Connections store authentication information. For general information about sharing database connections, please see Using Database Connections.

Note that different subsets of Database Connection parameters are made available in different contexts.

ClosedConnection

Select an existing connection, or Add Database Connection to define a new connection.

The new connection can be made visible only to the current user, or can be shared among multiple users.

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

ClosedDrop Existing Tables

If Yes is specified, tables are deleted before being written to. If Yes is specified and no features are written to a feature type, then the corresponding table is not deleted.

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.

ClosedCompress Geometry

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

ClosedCreate Spatial Index

If Yes is specified, a spatial index is created for the tables produced by the writer.

Encoding

ClosedCharacter Encoding

Determines the encoding mechanism FME will use to interpret string data stored in the SpatiaLite database.

By default, the writer interprests strings using the encoding setting of the local operating system (SYSTEM).

Note: See the topic Feature Type Parameters.