GeoPackage Feature Representation

In addition to the generic FME feature attributes that FME Workbench adds to all features (see Feature Attributes and Supported Geometries), this format adds a format-specific attribute described in this section and the format-specific attributes described in the Text File Reader documentation.

Features read from a database consist of geometry and a series of attribute values. The feature type of each GeoPackage feature is as defined in its Feature Type parameters. Features written to the database have the destination table as their feature type, and attributes as defined in Feature Type attributes.

The GeoPackage attribute type mapping is as follows:

GeoPackage Attribute Type FME Attribute Type
text fme_buffer
text(width) fme_varchar(width)
text(width) fme_char(width)
blob fme_buffer
blob(width) fme_varchar(width)
tinyint fme_char
text(1) fme_char
date fme_date
datetime fme_datetime
datetime fme_time
float fme_real32
double fme_real64
double fme_decimal(width, decimal)
boolean fme_boolean
smallint fme_int16
smallint fme_uint8
mediumint fme_int32
mediumint fme_uint16
int fme_int64
int fme_uint32
text(20) fme_uint64

Geometry

The geometry of GeoPackage features may be identified by the geopackage_type attribute. The valid values for this attribute are:

geopackage_type Description

wkb_none

FME Feature with no geometry

wkb_point

2D Point feature

wkb_point_xyz

2.5D Point feature

wkb_line

2D Linear feature

wkb_line_xyz

2.5D Linear feature

wkb_polygon

2D Simple polygon or donut feature

wkb_polygon

2.5D Simple polygon or donut feature

wkb_geometry_collection

2D Feature with multiple geometries

wkb_geometry_collection_xyz

2.5D Feature with multiple heterogeneous geometries

wkb_multi_point

2D Feature with multiple heterogeneous point geometries

wkb_multi_point_xyz

2.5D Feature with multiple heterogeneous point geometries

wkb_multi_line

2D Feature with multiple line geometries

wkb_multi_line_xyz

2.5D Feature with multiple line geometries

wkb_multi_polygon

2D Feature with multiple polygon geometries

wkb_multi_polygon_xyz

2.5D Feature with multiple polygon geometries

wkb_geometry

All geometries allowed

wkb_unknown

All geometries allowed