Difference between revisions of "GeoPackage Tips"

From Tuflow
Jump to navigation Jump to search
Line 3: Line 3:
 
</span>
 
</span>
 
= Introduction =
 
= Introduction =
This page includes tips and tricks for working with the GeoPackage 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). <br><br>
+
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). <br><br>
 
This database format has several benefits, including:
 
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.
 
*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.
Line 14: Line 14:
  
 
== Referencing a GeoPackage Layer ==
 
== Referencing a GeoPackage Layer ==
 +
 +
== Outputs ==
 +
Result and check file vector outputs can be written into separate databases or grouped, with 'grouped' being the default:<br>
 +
<font color="blue"><tt>Spatial Database Output</tt></font> <font color="red"><tt>== </tt></font> <font color="black"><tt>SEPARATE | {GROUPED} </tt></font> <br>
 +
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.
  
 
= QGIS Tips & Tricks =
 
= QGIS Tips & Tricks =

Revision as of 20:45, 6 July 2023

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

Referencing a GeoPackage Database

Referencing a GeoPackage Layer

Outputs

Result and check file vector outputs can be written into separate databases or grouped, with 'grouped' being the default:
Spatial Database Output == SEPARATE | {GROUPED}
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.

QGIS Tips & Tricks

TUFLOW Plugin Tools

QGIS Browser Panel

Setting a Brower Panel Favourite

File Management Plugin