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

[Nicolas Cadieux]

Hi,

That's a great idea. I can already load all the layers at once so this 
could be my way out.

Nicolas

On 2021-09-23 5:47 p.m., Charles Dixon-Paver wrote:
> 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 
> <mailto: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
>     <mailto:qgis-user-bounces at lists.osgeo.org>> on behalf of Nicolas
>     Cadieux <njacadieux.gitlab at gmail.com
>     <mailto:njacadieux.gitlab at gmail.com>>
>     *Sent:* Friday, September 24, 2021 08:33
>     *To:* Qgis Users List <qgis-user at lists.osgeo.org
>     <mailto: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 Cadieux
>     https://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 <mailto:Qgis-user at lists.osgeo.org>
>     List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>     <https://lists.osgeo.org/mailman/listinfo/qgis-user>
>     Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>     <https://lists.osgeo.org/mailman/listinfo/qgis-user>
>
-- 
Nicolas Cadieux
https://gitlab.com/njacadieux

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210923/8d8bec0f/attachment-0001.html>