<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
</head>
<body>
<p>Hi Brent,</p>
<p><br>
</p>
<p>I think you are correct. PostGis could be a way to go. I was
thinking more like using python and geopandas rather than PostGis.
I will look PostGis more carefully. I just posted this in case I
was missing some major innovation or plugin in QGIS. I normally
work with csv, shp or single layer Geopackages so I has wondering
if I was missing something obvious. Nothing more frustrating than
coding something that is already done.</p>
<p><br>
</p>
<p>Thanks for the input<br>
</p>
<p>Nicolas<br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 2021-09-23 4:52 p.m., Brent Wood
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:SY4PR01MB70766FE7B3655CA30AA5E9AEA1A39@SY4PR01MB7076.ausprd01.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<style type="text/css" style="display:none;">P {margin-top:0;margin-bottom:0;}</style>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
Umm, <br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
A bit left fieldish, but is that sort of thing something that
Postgis is perhaps more suited to than QGIS?</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
Could you not ogr the geopackage into Postgis & script up
the work you want doing?<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
It sounds like what you want to do is very much in the arena of
data management.<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div>
<div name="divtagdefaultwrapper"
style="font-family:Calibri,Arial,Helvetica,sans-serif;
font-size:; margin:0">
<div class="BodyFragment">
<div class="PlainText">Brent Wood<br>
<br>
Principal Technician, Fisheries<br>
NIWA<br>
DDI: +64 (4) 3860529</div>
</div>
</div>
</div>
</div>
</div>
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;
font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt"
face="Calibri, sans-serif" color="#000000"><b>From:</b>
Qgis-user <a class="moz-txt-link-rfc2396E" href="mailto:qgis-user-bounces@lists.osgeo.org"><qgis-user-bounces@lists.osgeo.org></a> on
behalf of Nicolas Cadieux
<a class="moz-txt-link-rfc2396E" href="mailto:njacadieux.gitlab@gmail.com"><njacadieux.gitlab@gmail.com></a><br>
<b>Sent:</b> Friday, September 24, 2021 08:33<br>
<b>To:</b> Qgis Users List <a class="moz-txt-link-rfc2396E" href="mailto:qgis-user@lists.osgeo.org"><qgis-user@lists.osgeo.org></a><br>
<b>Subject:</b> [Qgis-user] batch operation on gpkg with
multiple layers</font>
<div> </div>
</div>
<div>
<p>Hi,</p>
<p>Before I go to my default mode and python my way through
this, is there a plugin that would permit me to perform
batch operation on all the layers found in a single .gpkg
file? My geopackages contain hundreds of layers (from
autocad) (contain identical data structures) and I would
like to do things like:</p>
<ul>
<li>Perform field calculator operations on each layer within
the geopackage<br>
</li>
<li>Split all geopackage layer with a field<br>
</li>
<li>Merge multiple layers in a new geopackage</li>
</ul>
<p>I guess FME would be another way out? I there an OpenSource
equivilant to this? (I have a home version but I need to
respect the license for this one.)<br>
</p>
Nicolas<br>
<pre class="x_moz-signature" cols="72">--
Nicolas Cadieux
<a class="x_moz-txt-link-freetext" href="https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgitlab.com%2Fnjacadieux&data=04%7C01%7Cbrent.wood%40niwa.co.nz%7Ce4a84a1760b94c5753bf08d97ed16712%7C41caed736a0c468aba499ff6aafd1c77%7C0%7C1%7C637680260176856431%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=PxPRTfSCzkt4cJGC1hkQ%2FNCyxLi%2B6auZhjfB1NEdn4s%3D&reserved=0" originalsrc="https://gitlab.com/njacadieux" shash="Z1Go3XruRO9AdE1netw5ZKMTBqqsMztWmHz9xx8T6AnEfnTm+V/E4rR/h+kydfMN4e+uHMhlTehakmrKtrj691F9lSobOm87wKI5ciSC+jsSDmhCYEVWQ1bNGtCHf+L5+sZEfzTJYoHdoyc0VSrLTgsZsGuWZhSSvm3Wg2lRXaY=" moz-do-not-send="true">https://gitlab.com/njacadieux</a></pre>
</div>
</div>
<table style="width: 600px; font-size: 8pt; font-family: Arial"
cellspacing="20">
<tbody>
<tr>
<td><a href="https://www.niwa.co.nz" moz-do-not-send="true"><img
src="https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png"
moz-do-not-send="true">
</a></td>
<td>
<span>Brent Wood <br>
<font color="#1793d2">Principal Technician - GIS and
Spatial Data Management</font><br>
<font color="#1793d2">Programme Leader - Environmental
Information Delivery</font><br>
+64-4-386-0529<br>
<br>
National Institute of Water & Atmospheric Research
Ltd (NIWA)<br>
301 Evans Bay Parade Hataitai Wellington New Zealand<br>
<b>Connect with NIWA:</b> <a
href="https://www.niwa.co.nz" moz-do-not-send="true">niwa.co.nz</a>
<a href="https://www.facebook.com/nzniwa"
moz-do-not-send="true">
Facebook</a> <a
href="https://www.linkedin.com/company/niwa"
moz-do-not-send="true">LinkedIn</a> <a
href="https://twitter.com/niwa_nz"
moz-do-not-send="true">
Twitter</a> <a
href="https://www.instagram.com/niwa_science"
moz-do-not-send="true">Instagram</a> </span>
<table style="width: 500px">
<tbody>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<font size="1" face="Arial">To ensure compliance with legal
requirements and to maintain cyber security standards, NIWA's IT
systems are subject to ongoing monitoring, activity logging and
auditing. This monitoring and auditing service may be provided
by third parties. Such third parties can access information
transmitted to, processed by and stored on NIWA's IT systems</font>
</blockquote>
<pre class="moz-signature" cols="72">--
Nicolas Cadieux
<a class="moz-txt-link-freetext" href="https://gitlab.com/njacadieux">https://gitlab.com/njacadieux</a></pre>
</body>
</html>