The directives processed by the SQLite3 reader are listed below. The suffixes shown are prefixed by the reader keyword in a mapping file. By default, the <ReaderKeyword> for the SQLite3 reader is SQLITE3FDO.
DATASET
Required/Optional: Required
The value for this keyword is the path of the SQLite3 file to be read. A typical mapping file fragment specifying an input SQLite3 dataset looks like:
SQLITE3FDO_DATASET /usr/data/sqlite/data.db
Workbench Parameter: Source SQLite3 Spatial (FDO) Dataset
DEF
Required/Optional: Optional
This optional specification is used to limit the available and defined feature classes that will be read. If no IDs are specified, then all defined and available feature classes are read. The syntax of the IDs keyword is:
SDF3_IDs <featureType1> \ <featureType2> \ <featureTypeN>
The feature types must match those used in DEF lines.
The example below selects only the ROADS feature class for input during a translation:
SQLITE3FDO_IDs ROADS
REMOVE_SCHEMA_QUALIFIER
Required/Optional: Optional
The value for this keyword is either yes or no. A value of yes indicates that the feature type name in FME should not contain the schema name prefix before the table name. The default value of no indicates the table name will contain the schema prefix separated by a period.
SQLITE3FDO_REMOVE_SCHEMA_QUALIFIER NO
SQLITE3FDO_DEF default.mytable
or
SQLITE3FDO_REMOVE_SCHEMA_QUALIFIER YES
SQLITE3FDO_DEF mytable
SEARCH_ENVELOPE
Using the minimum and maximum x and y parameters, define a bounding box that will be used to filter the input features. Only features that interact with the bounding box are returned.
If all four coordinates of the search envelope are specified as 0, the search envelope will be disabled.
Mapping File Syntax
<ReaderKeyword>_SEARCH_ENVELOPE <minX> <minY> <maxX> <maxY>
Note: If all four coordinates of the search envelope are specified as zero, the search envelope will be disabled.
Required/Optional
Optional
Workbench Parameter
Minimum X, Minimum Y, Maximum X, Maximum Y
SEARCH_ENVELOPE_COORDINATE_SYSTEM
This directive specifies the coordinate system of the search envelope if it is different than the coordinate system of the data.
The COORDINATE_SYSTEM directive, which specifies the coordinate system associated with the data to be read, must always be set if the SEARCH_ENVELOPE_COORDINATE_SYSTEM directive is set.
If this directive is set, the minimum and maximum points of the search envelope are reprojected from the SEARCH_ENVELOPE_COORDINATE_SYSTEM to the reader COORDINATE_SYSTEM prior to applying the envelope.
Required/Optional
Optional
Mapping File Syntax
<ReaderKeyword>_SEARCH_ENVELOPE_COORDINATE_SYSTEM <coordinate system>
Workbench Parameter
Search Envelope Coordinate System
CLIP_TO_ENVELOPE
This directive specifies whether or not FME should clip features to the envelope specified in the SEARCH_ENVELOPE directive.
Values
YES | NO (default)
Mapping File Syntax
<ReaderKeyword>_CLIP_TO_ENVELOPE [yes | no]
Workbench Parameter
Clip To Envelope