OGC GeoPackage Writer Feature Type Parameters

General

Table Name

The name of the table to be written. If a table with the specified name exists, it will be overwritten if the Table Handling parameter is set to Drop and Create. Otherwise the table will be appended.

Valid values for table names include any character string devoid of SQL-offensive characters and less than 255 characters in length.

Dynamic Schema Definition

See About Dynamic Workspaces.

Table: General

Table Handling

This parameter controls how the feature type handles destination tables. These options are available:

  • Create If Needed: Create destination table if it does not exist. The GeoPackage writer uses the information within the FME workspace to automatically create Vector Feature tables as required. All tables will be created when the first input feature is processed. If no features are sent to a feature type, then the corresponding table will not be created.
  • Use Existing: Write to an existing table or list. If the destination table/list does not exist, the translation will fail.
  • Drop and Create: Drop destination table if it exists, then create it. The writer will drop and re-create the table before writing any features to it. Tables will be overwritten when the first input feature is processed. If no features are sent to a feature type, then the corresponding table will not be overwritten.

Table Creation

The parameters in this section take effect only when FME creates a table.

Spatial

The parameters in this section take effect only when FME creates a spatial table (a GeoPackage features table).

If the geometry type of the feature type is geopackage_none, FME will create an aspatial table (a GeoPackage attributes table), and the parameters in this group will be ignored.

Spatial Column

If a table is being created, this parameter allows you to specify the name of the geometry column.

The default name is geom.

Create Spatial Index

Indicates whether or not a spatial index is to be created as part of the data writing.

Valid choices: Yes (default), or No.

Z

Indicates whether geometries written to the table can have a third dimension.

  • Not allowed (default) – The writer will drop Z values from geometries before writing.
  • Required – The writer will add a Z value of 0 to geometries if they do not already have a Z value.
  • Optional – The writer will write Z values if they exist.

M

Indicates whether geometries written to the table can have measures.

  • Not allowed (default) – The writer will drop default measure values from geometries before writing.
  • Required – The writer will fail to write geometries if they do not already have a default measure value.
  • Optional – The writer will write default measure values if they exist.