[Qgis-user] GPKG Multi-Layer to one flat

[Thayer Young]

 Hi Dennis,
Chris gave some good suggestions. If you are only concerned with the geometry, you can try these suggestions. First, make sure that you have a spatial index on the layer. Second I think you want to dissolve the polygons, not union them. You can also try using the Subdivide processing algorithm first, which will make your spatial index more efficient. Then do a dissolve, and if you want distinct polygons use the Multipart to Singleparts algorithm.
-Thayer



    On Friday, March 3, 2023 at 03:00:50 PM EST, qgis-user-request at lists.osgeo.org <qgis-user-request at lists.osgeo.org> wrote:
Date: Fri, 3 Mar 2023 19:22:54 +0000
From: Dennis Burgess <dmburgess at linktechs.net>
To: "qgis-user at lists.osgeo.org" <qgis-user at lists.osgeo.org>
Subject: [Qgis-user] GPKG Multi-Layer to one flat
Message-ID: <cc1d4c6d496b48a4a59fe7f2301e0886 at linktechs.net>
Content-Type: text/plain; charset="us-ascii"

Ok, has to be a simple solution.

I have a GPKG file that is around 50 meg.  This has multiple layers or at least I can see multiple layers.  I.e. I have one polygon on top of another

What I want is to flatten these, to where ONLY the exact area that is show is displayed in the smallest file possible.

Union is the way to do this but its SLOW SLOW..  any other options... ?

*****************************************
  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20230304/122982c0/attachment.htm>