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

[Nicolas Cadieux]

Hi Brent,


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.


Thanks for the input

Nicolas


On 2021-09-23 4:52 p.m., Brent Wood 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 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 

-- 
Nicolas Cadieux
https://gitlab.com/njacadieux

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