FME provides read and write access to GeoPackage files.
GeoPackage is an open standard from OGC that has been designed for use with mobile devices. GeoPackage is based on SQLite as an underlying data container, which makes it platform-independent and easy to copy or move, as well as giving it all the power of a fully-featured relational database management system.
More information about the GeoPackage standard can be found at www.geopackage.org. See the guide Getting Started With GeoPackage.
OGC GeoPackage Product and System Requirements
|
Format |
Platform |
Operating System |
||||
|---|---|---|---|---|---|---|
|
Reader/Writer |
FME Desktop License |
FME Server |
FME Cloud |
Windows 64-bit |
Linux |
Mac |
|
Reader |
Available in FME Professional Edition and higher |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Writer |
Available in FME Professional Edition and higher |
Yes |
Yes |
Yes |
Yes |
Yes |
Format Usage Notes
- GeoPackage files may contain multiple Vector Feature User Data Tables. FME treats these tables as feature types, and can read features from them, as well as write features to them. FME treats each column in a table as an attribute, and each row as a feature.
Primary Key Column
- The GeoPackage reader exposes the primary key column as an attribute with type int and index type PrimaryKey.
- The GeoPackage writer can write one attribute with type int and index type PrimaryKey. If a feature operation is insert, then the value of this attribute is used as the row ID and the value must be unique. If a feature operation is update, upsert, or delete, then the value of this attribute is used to determine which row to update, upsert, or delete (see Feature Operation).
For more information, see Feature Operation and PrimaryKey.
Reader Overview
The GeoPackage reader supports reading multiple Vector Feature Tables from the same GeoPackage file. FME treats each table as a feature type, each row as a feature, and each column as an attribute.
The tables must be defined in the workspace before they can be read.
Writer Overview
The GeoPackage writer stores feature records into a Vector Feature Table within a GeoPackage file. The GeoPackage writer provides the following capabilities:
- Table Creation
- Table Overwrite
These are described in OGC GeoPackage Writer Feature Type Parameters. See also How to create a non-spatial table.