<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi,</p>
<p>That's a great idea. I can already load all the layers at once so
this could be my way out.</p>
<p>Nicolas<br>
</p>
<div class="moz-cite-prefix">On 2021-09-23 5:47 p.m., Charles
Dixon-Paver wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAK2Kqie8qKAEa7Y79gTmQfN2+Gh63EOMriq1NLOhhz-=K2UxjA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<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"
moz-do-not-send="true">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 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
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" moz-do-not-send="true">qgis-user-bounces@lists.osgeo.org</a>>
on behalf of Nicolas Cadieux <<a
href="mailto:njacadieux.gitlab@gmail.com"
target="_blank" moz-do-not-send="true">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" moz-do-not-send="true">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" 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" target="_blank"
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>
<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" moz-do-not-send="true">niwa.co.nz</a>
<a href="https://www.facebook.com/nzniwa"
target="_blank" moz-do-not-send="true">
Facebook</a> <a
href="https://www.linkedin.com/company/niwa"
target="_blank" moz-do-not-send="true">LinkedIn</a>
<a href="https://twitter.com/niwa_nz"
target="_blank" moz-do-not-send="true">
Twitter</a> <a
href="https://www.instagram.com/niwa_science"
target="_blank" moz-do-not-send="true">Instagram</a>
</span>
</td>
</tr>
</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>
</div>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank"
moz-do-not-send="true">Qgis-user@lists.osgeo.org</a><br>
List info: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
rel="noreferrer" target="_blank" moz-do-not-send="true">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" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</blockquote>
</div>
</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>