<div dir="ltr">Another option is to build a model (or separate processing tools) and use the batch execute processing options. One issue here is that iterating through all gpkg layers efficiently will probably require loading them into the project for the autofill options to work on them, so you'd probably have to process one gpkg at a time. Also, conditionals and iterators in models etc are not optimal in the model builder, so this route pretty much expects the same operations to be performed on most of the layers.</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, 23 Sept 2021 at 22:53, Brent Wood <<a href="mailto:Brent.Wood@niwa.co.nz">Brent.Wood@niwa.co.nz</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<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="gmail-m_852415137969574782Signature">
<div>
<div></div>
<div></div>
<div name="divtagdefaultwrapper">
<div>
<div>Brent Wood<br>
<br>
Principal Technician, Fisheries<br>
NIWA<br>
DDI: +64 (4) 3860529</div>
</div>
</div>
</div>
</div>
</div>
<div>
<div id="gmail-m_852415137969574782appendonsend"></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<hr style="display:inline-block;width:98%">
<div id="gmail-m_852415137969574782divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> Qgis-user <<a href="mailto:qgis-user-bounces@lists.osgeo.org" target="_blank">qgis-user-bounces@lists.osgeo.org</a>> on behalf of Nicolas Cadieux <<a href="mailto:njacadieux.gitlab@gmail.com" target="_blank">njacadieux.gitlab@gmail.com</a>><br>
<b>Sent:</b> Friday, September 24, 2021 08:33<br>
<b>To:</b> Qgis Users List <<a href="mailto:qgis-user@lists.osgeo.org" target="_blank">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 cols="72">--
Nicolas Cadieux
<a 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" target="_blank">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" target="_blank"><img src="https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png">
</a></td>
<td>
<table style="width:500px">
<tbody>
<tr><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" target="_blank">niwa.co.nz</a> <a href="https://www.facebook.com/nzniwa" target="_blank">
Facebook</a> <a href="https://www.linkedin.com/company/niwa" target="_blank">LinkedIn</a> <a href="https://twitter.com/niwa_nz" target="_blank">
Twitter</a> <a href="https://www.instagram.com/niwa_science" target="_blank">Instagram</a> </span>
</td></tr></tbody>
</table>
</td>
</tr>
</tbody>
</table>
<font face="Arial" size="1">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>
</div>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</blockquote></div>