OGC GeoPackage Reader/Writer

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

FME Platform

Operating System

Reader/Writer

FME Form

FME Flow

FME Flow Hosted

Windows 64-bit

Linux

Mac

Reader

Yes

Yes

Yes

Yes

Yes

Yes

Writer

Yes

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.