SQLite 3 Spatial (FDO) Writer Feature Type Parameters
To access feature type parameters, click the gear icon on a feature type in the workspace to open the Feature Type Parameter Editor. To always display the editor in Workbench, you can select View > Windows > Parameter Editor.
General
All feature types share similar General parameters, which may include the Feature Type Name, Reader or Writer Name, and Geometry.
In most Writer Feature Type parameter dialogs, you can also control Dynamic Schema Definitions. Some database formats accept a Table Qualifier prefix on the output table feature type.
See Editing Writer Feature Types for more information.
These parameters apply only to a selected feature type, not to the entire writer.
Tip: If a feature type parameter listed here conflicts with a writer-level parameter, then the writer parameter will be ignored and this feature type parameter will be used.
Table
Specifies how features will be written into the destination table. Supported feature operations are:
- Inherit from Writer: Take the value from the writer level (do not override the value at the feature type level).
- Insert: Append rows onto the destination table using attributes on features.
- Update: Update existing table columns using attributes on features. A selection method must be specified in the Row Selection group.
- Delete: Delete existing table rows. A selection method must be specified in the Row Selection group.
More information about Writer Mode.
Specifies the name of the default index attribute that is added to the feature type if no user attribute is specified with an IDENTITY index type. This parameter defaults to PRIMARYINDEX.
A comma-separated list of the geometry column names for writing.
Location columns will be created for each of the supplied geometry column names when creating a new table or matched against the existing geometry columns when writing to an existing table.
Note: If the column names listed here conflict with any user attributes, the columns listed here take precedence.
This parameter has no effect when the Writer Mode is Delete.
- No: The table will be created if it does not exist.
- Yes: The table will be dropped if it exists, then created.
- Truncate: If the table does not exist, it will be created. If the table does exist, then all its rows will be deleted.