Skip to main content

Database Schema

QRiS projects are stored as a single GeoPackage file. All vector feature classes are stored inside this file, while rasters are stored on disk in the same folder as the project GeoPackage.

A GeoPackage is an open standard for storing geospatial data published by the Open Geospatial Consortium (OGC) with numerous benefits compared to the ShapeFile format. It consists of a single file that can store multiple vector feature classes and raster datasets. The file is actually a SQLite database with a specific schema.

Working with GeoPackages

Since a GeoPackage is a SQLite database, you can use any SQLite client to view the data. We discourage editing data outside of QGIS, but using one of the following database user interface tools you can perform custom queries should you want to analyse or report your QRiS data in unanticipated ways:

If you plan on using DataGrip then you can filter out the non-QRiS tables by using the following schema configuration string:

table:-rtree.*||table:-sqlite.*||table:-gpkg_tile.*||table:-gpkg_spatial_ref_sys||table:-gpkg_ogr_contents||vtable:-rtree.* co:

QRiS GeoPackage Schema

The object entity diagram below illustrates the main QRiS GeoPackage database tables. Note that GeoPackages contain several additional database tables that are part of the GeoPackage schema and not shown here.

schema