GeoPackage Tips

Page Under Construction

Introduction

This page includes tips and tricks for working with the GeoPackage Vector format (supported since the TUFLOW 2023-03-AA Release). GeoPackage is a widely supported, open GIS database format, built upon an SQLite database (data is stored as a single file with the extension .gpkg).

This database format has several benefits, including:

• Multiple GIS layer can be stored in the single file database. For example, all GIS input layers can be stored in a single GeoPackage file.
• Supports spatial indexing, greatly reducing loading and viewing times making it much faster to work with in GIS packages.
• Faster to write from TUFLOW than the shapefile format.

For more information see the 2023 Release Notes.

Command Files

There are many ways to use GeoPackages, for example, one database for an entire project or one database for a developed case. To define the database the following command is used: Spatial Database == /path/to/database

If a database is

Since a GeoPackage database can have more than one layer, when reading data into TUFLOW a GeoPackage database

and layermay need to be specified. The following options are possible: One difference between previous formats and the GeoPackage format is that the spatial database must be referenced in the control files.

Outputs

Result and check file vector outputs can be written into separate databases or grouped, with 'grouped' being the default. Grouped databases will group by output folder location, for example, the check file folder will contain one GeoPackage Database that contains all check file layers within it. Separate databases will group geometries together, for example, PLOT_P, PLOT_L, PLOT_R will be written to one database. The following command can be used to set the output to either separate or grouped: Spatial Database Output == SEPARATE | {GROUPED}

This is a huge benefit in terms of file organisation. The below shows a TUFLOW 'Check' folder from a model using the GeoPackage (grouped). The same 'Check' folder for a model using Shapefile would have 44(!) items in it.

QGIS Tips & Tricks

Convert TUFLOW Model GIS Format

The Convert TUFLOW Model GIS Format tool has been developed to convert the GIS formats for an entire models (input files and control files). For example, if you have a model currently set up using the SHP vector format and FLT raster format, you can automatically convert it to GPKG and TIF. This tool works both ways for any TUFLOW supported format and will automatically show in the 'Processing Toolbox' if you have the TUFLOW Plugin installed.

Updating Layer Names

Updating a GPKG Layer Name

QGIS Browser Panel

The QGIS Browser Panel is the recommended location to view, access, open and edit layers with a GeoPackage Database. It is possible to:

• View layers inside a Geopackage Database.
• Move a layer from one GeoPackage Database to another.
• Move a shapefile into a GeoPackage Database. QGIS will automatically convert it to a Geopackage layer.
• Rename a layer or database (using the File Management Tool)
• Delete a layer or database (using the File Management Tool)

Setting a Brower Panel Favourite

For quick access, a project folder can be set as a favourite in the QGIS Browser Panel.

1. Right click in the Toolbar panel and tick on 'Browser Panel' from the 'Panels' options.
2. Within the QGIS Browser Panel, right click on 'Favorites' and select 'Add a Directory...'.
3. Navigate to the project folder and select it.