GeoPackage Tips - Revision history

Emilie Nielsen: /* Introduction */

2025-02-06T02:39:23Z

Introduction

← Older revision		Revision as of 12:39, 6 February 2025
Line 5:		Line 5:
	*Supports spatial indexing, greatly reducing loading and viewing times, making it much faster to work within GIS packages.		*Supports spatial indexing, greatly reducing loading and viewing times, making it much faster to work within GIS packages.
	*Faster to write from TUFLOW than the shapefile format.		*Faster to write from TUFLOW than the shapefile format.
	For more information ~~see~~ the <u>[https://~~www~~.tuflow.com/~~downloads/tuflow-classichpc~~-~~archive~~/~~#2023 2023~~ ~~Release~~ ~~Notes~~]</u>.		For more information, refer to Section 4.4.3 of the <u>[https://docs.tuflow.com/classic-hpc/manual/latest/ TUFLOW Manual]</u>.

	= Database Organisation =		= Database Organisation =

Emilie Nielsen: /* Database Organisation */

2023-11-12T23:07:30Z

Database Organisation

← Older revision		Revision as of 09:07, 13 November 2023
Line 9:		Line 9:
	= Database Organisation =		= Database Organisation =
	There are many ways to organise model inputs when using GPKG. This allows modellers to decide how they structure their inputs files, for example some options include:		There are many ways to organise model inputs when using GPKG. This allows modellers to decide how they structure their inputs files, for example some options include:
	*~~single~~ database for an entire project		*Single database for an entire project
	*~~separate~~ database for each control file (e.g. geometry, boundary control file)		*Separate database for each control file (e.g. geometry, boundary control file)
	*~~separate~~ database for an existing or developed case		*Separate database for an existing or developed case
	*~~separate~~ databases for each type of input (e.g. elevation, materials, culverts)		*Separate databases for each type of input (e.g. elevation, materials, culverts)

	== Referencing a GeoPackage Database ==		== Referencing a GeoPackage Database ==

Chris Huxley: /* Tutorials */

2023-10-08T23:40:16Z

Tutorials

← Older revision		Revision as of 09:40, 9 October 2023
Line 202:		Line 202:
	For more information, see the <u>[[QGIS_TUFLOW_Apply_GPKG_Layer_Names\| Updating a GPKG Layer Name]]</u>		For more information, see the <u>[[QGIS_TUFLOW_Apply_GPKG_Layer_Names\| Updating a GPKG Layer Name]]</u>
	=Tutorials=		=Tutorials=
	Free TUFLOW tutorials using the GeoPackage format are availble via: [[Tutorial Introduction\|TUFLOW HPC Tutorials]]		Free TUFLOW tutorials using the GeoPackage format are availble via: <u>[[Tutorial Introduction\|TUFLOW HPC Tutorials]]</u>

Chris Huxley at 23:40, 8 October 2023

2023-10-08T23:40:00Z

← Older revision		Revision as of 09:40, 9 October 2023
Line 201:		Line 201:
	<br>		<br>
	For more information, see the <u>[[QGIS_TUFLOW_Apply_GPKG_Layer_Names\| Updating a GPKG Layer Name]]</u>		For more information, see the <u>[[QGIS_TUFLOW_Apply_GPKG_Layer_Names\| Updating a GPKG Layer Name]]</u>
			=Tutorials=
			Free TUFLOW tutorials using the GeoPackage format are availble via: [[Tutorial Introduction\|TUFLOW HPC Tutorials]]

Emilie Nielsen: /* QGIS Browser Panel */

2023-10-02T00:30:28Z

QGIS Browser Panel

← Older revision		Revision as of 10:30, 2 October 2023
Line 108:		Line 108:
	<li>Move a layer from one GPKG to another.<br>		<li>Move a layer from one GPKG to another.<br>
	<br>		<br>
	{{Video\|name=~~browser_panel_move_layer_a~~.mp4\|width=1000}}		{{Video\|name=browser_panel_move_layer_b.mp4\|width=1000}}
	<br>		<br>
	<li>Move a shapefile into a GPKG. QGIS automatically converts it to a GPKG layer.<br>		<li>Move a shapefile into a GPKG. QGIS automatically converts it to a GPKG layer.<br>

Emilie Nielsen: /* Outputs */

2023-10-02T00:18:54Z

Outputs

← Older revision		Revision as of 10:18, 2 October 2023
Line 63:		Line 63:
	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 GPKG 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: <br>		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 GPKG 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: <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><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><br>
	This is a huge benefit in terms of file organisation. The below shows a TUFLOW 'Check' folder from a model using the GPKG (grouped). The same 'Check' folder for a model using Shapefile would have 44(!) items in it. ~~<br>~~<br>		This is a huge benefit in terms of file organisation. The below shows the TUFLOW 'Check' folder from a model using the GPKG grouped and a model using the GPKG separate. The same 'Check' folder for a model using Shapefile would have 44(!) items in it.<br>
			*Grouped:
	{{Video\|name=~~GPKG_Tips_CheckFiles_a~~.mp4\|width=1000}}<br>		{{Video\|name=Animation_Outputs_grouped.mp4\|width=1000}}<br>
			*Separate (grouped geometries):
			{{Video\|name=Animation_Outputs_separate.mp4\|width=1000}}<br>

	= QGIS Tips & Tricks =		= QGIS Tips & Tricks =

Pavlina Monhartova: /* Create a New Layer */

2023-09-28T23:08:41Z

Create a New Layer

← Older revision		Revision as of 09:08, 29 September 2023
Line 134:		Line 134:
	<li>In the 'Spatial Database Options' section, there are the following options:		<li>In the 'Spatial Database Options' section, there are the following options:
	<ol>		<ol>
	<li>'''Convert to GPKG'''. This ~~will convert~~ the imported format to a GPKG even if the empty file format is not a GPKG. The video below shows it being used for the '~~separate~~' option, however it can be toggled on for any of the export options. <br>		<li>'''Convert to GPKG'''. This converts the imported format to a GPKG even if the empty file format is not a GPKG. The video below shows it being used for the 'Separate' option, however it can be toggled on for any of the export options. <br>
	<br>		<br>
	{{Video\|name=Animation_import_layer_convert.mp4\|width=1000}}		{{Video\|name=Animation_import_layer_convert.mp4\|width=1000}}
Line 146:		Line 146:
	{{Video\|name=Animation_import_layer_group_geom.mp4\|width=1000}}		{{Video\|name=Animation_import_layer_group_geom.mp4\|width=1000}}
	<br>		<br>
	<li>'''All to one:''' Adds the new files to a ~~GPKG. It can be a preexisting~~ or ~~a new~~ GPKG.<br>		<li>'''All to one:''' Adds the new files to a new or existing GPKG.<br>
	<br>		<br>
	{{Video\|name=Animation_import_layer_alltoone_preexisting.mp4\|width=1000}}		{{Video\|name=Animation_import_layer_alltoone_preexisting.mp4\|width=1000}}

Pavlina Monhartova: /* Referencing a GeoPackage Layer */

2023-09-28T22:12:09Z

Referencing a GeoPackage Layer

← Older revision		Revision as of 08:12, 29 September 2023
Line 35:		Line 35:
	<li>To specify a table in a GPKG, use ">>":<br>		<li>To specify a table in a GPKG, use ">>":<br>
	<font color="blue"><tt>Read GIS Z Shape </tt></font> <font color="red"><tt>== </tt></font> <font color="black"><tt>gis\2d_zsh.gpkg >> 2d_zsh_L </tt><br>		<font color="blue"><tt>Read GIS Z Shape </tt></font> <font color="red"><tt>== </tt></font> <font color="black"><tt>gis\2d_zsh.gpkg >> 2d_zsh_L </tt><br>
	<li>To specify more than one table in a GPKG in the same command line, use "\|". The database has to be ~~reference~~ for all the tables. <br>		<li>To specify more than one table in a GPKG in the same command line, use "\|". The database has to be referenced for all the tables. <br>
	<font color="blue"><tt>Read GIS Z Shape </tt></font> <font color="red"><tt>== </tt></font> <font color="black"><tt>gis\2d_zsh.gpkg >> 2d_zsh_L \| gis\2d_zsh.gpkg >> 2d_zsh_P </tt><br>		<font color="blue"><tt>Read GIS Z Shape </tt></font> <font color="red"><tt>== </tt></font> <font color="black"><tt>gis\2d_zsh.gpkg >> 2d_zsh_L \| gis\2d_zsh.gpkg >> 2d_zsh_P </tt><br>
	<li>To specify more than one table in a GPKG in the same command line, use "&&". This is similar to "\|", however there is no need to reference the database again. <br>		<li>To specify more than one table in a GPKG in the same command line, use "&&". This is similar to "\|", however there is no need to reference the database again. <br>

Emilie Nielsen at 07:11, 25 September 2023

2023-09-25T07:11:24Z

@@ Line 94: / Line 94: @@
 {{Video|name=Animation_M01_GPKG_Browser_Panel_01c.mp4|width=1200}}
 <br></ol>
 <br>
@@ Line 132: / Line 157: @@
 For more information, see [[QGIS TUFLOW Import Empty|QGIS TUFLOW Import Empty]].
 <br>
 <br>

Emilie Nielsen: /* Create a New Layer */

2023-09-25T07:09:48Z

Create a New Layer

@@ Line 97: / Line 97: @@
 == Create a New Layer ==
-To create a new GPKG layer,
+Use the TUFLOW plugin to create a new layer.
 <br>
 <br>