Skip to content

Latest commit

 

History

History
92 lines (58 loc) · 2.08 KB

qgis_geopackage_extension.md

File metadata and controls

92 lines (58 loc) · 2.08 KB

GeoPackage 1.0 Extension

DRAFT

Extension follows template from Annex I of the OGC GeoPackage 1.0 Specification.

Extension Title

QGIS map styling information

Introduction

Store QGIS projects with their resources like images in print templates in a GeoPackage file.

Extension Author

Pirmin Kalberer, author_name pka.

Extension Name or Template

qgis

Extension Type

Extension of Existing Requirement in Clause 2.

Applicability

This extension applies to additional tables qgis_projects, qgis_resources and layer_styles.

Scope

Read-write

Requirements

Definition of extension and interdependencies with other extensions if any.

GeoPackage

Extension tables

An Extended GeoPackage with QGIS support MAY contain the following tables or views:

qgis_projects

Column type Desctiption
name text NOT NULL UNIQUE Project name (file name)
xml text NOT NULL Project file content (.qgs) in XML format

qgis_resources

Column type Desctiption
name text NOT NULL UNIQUE Name of resource (file name)
mime_type text NOT NULL Mime type of resource (image/png, image/svg+xml, ...)
content blob NOT NULL Binary content of resource

layer_styles

QGIS style library. Used styles are included in project XML.

Column type Desctiption
id INTEGER PRIMARY KEY
f_table_catalog varchar(256)
f_table_schema varchar(256)
f_table_name varchar(256)
f_geometry_column varchar(256)
styleName varchar(30)
styleQML text
styleSLD text
useAsDefault boolean
description text
owner varchar(30)
ui text
update_time timestamp

Additional metadata (authorship, licensing, ...) can be stored in the GeoPackage metadata tables.

GeoPackage SQLite Configuration

None

GeoPackage SQLite Extension

None