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 |