[Qgis-user] batch operation on gpkg with multiple layers

[Charles Dixon-Paver]

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.

On Thu, 23 Sept 2021 at 22:53, Brent Wood <Brent.Wood at niwa.co.nz> wrote:

> Umm,
>
> A bit left fieldish, but is that sort of thing something that Postgis is
> perhaps more suited to than QGIS?
>
> Could you not ogr the geopackage into Postgis & script up the work you
> want doing?
>
> It sounds like what you want to do is very much in the arena of data
> management.
>
>
> Brent Wood
>
> Principal Technician, Fisheries
> NIWA
> DDI:  +64 (4) 3860529
>
> ------------------------------
> *From:* Qgis-user <qgis-user-bounces at lists.osgeo.org> on behalf of
> Nicolas Cadieux <njacadieux.gitlab at gmail.com>
> *Sent:* Friday, September 24, 2021 08:33
> *To:* Qgis Users List <qgis-user at lists.osgeo.org>
> *Subject:* [Qgis-user] batch operation on gpkg with multiple layers
>
>
> Hi,
>
> 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:
>
>    - Perform field calculator operations on each layer within the
>    geopackage
>    - Split all geopackage layer with a field
>    - Merge multiple layers in a new geopackage
>
> 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.)
> Nicolas
>
> --
> Nicolas Cadieuxhttps://gitlab.com/njacadieux <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>
>
> <https://www.niwa.co.nz>
> Brent Wood
> Principal Technician - GIS and Spatial Data Management
> Programme Leader - Environmental Information Delivery
> +64-4-386-0529
>
> National Institute of Water & Atmospheric Research Ltd (NIWA)
> 301 Evans Bay Parade Hataitai Wellington New Zealand
> *Connect with NIWA:* niwa.co.nz <https://www.niwa.co.nz> Facebook
> <https://www.facebook.com/nzniwa> LinkedIn
> <https://www.linkedin.com/company/niwa> Twitter
> <https://twitter.com/niwa_nz> Instagram
> <https://www.instagram.com/niwa_science> 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
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210923/a20d5b4a/attachment.html>