<html><head></head><body><div class="ydp633d480cyahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div></div>
<div dir="ltr" data-setdir="false">Hi Dennis,</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">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.</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">-Thayer<br></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false"><br></div><div><br></div>
</div><div id="ydpe97944yahoo_quoted_7975024075" class="ydpe97944yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Friday, March 3, 2023 at 03:00:50 PM EST, qgis-user-request@lists.osgeo.org <qgis-user-request@lists.osgeo.org> wrote:<br><div dir="ltr">Date: Fri, 3 Mar 2023 19:22:54 +0000<br></div><div dir="ltr">From: Dennis Burgess <<a href="mailto:dmburgess@linktechs.net" rel="nofollow" target="_blank">dmburgess@linktechs.net</a>><br></div><div dir="ltr">To: "<a href="mailto:qgis-user@lists.osgeo.org" rel="nofollow" target="_blank">qgis-user@lists.osgeo.org</a>" <<a href="mailto:qgis-user@lists.osgeo.org" rel="nofollow" target="_blank">qgis-user@lists.osgeo.org</a>><br></div><div dir="ltr">Subject: [Qgis-user] GPKG Multi-Layer to one flat<br></div><div dir="ltr">Message-ID: <<a href="mailto:cc1d4c6d496b48a4a59fe7f2301e0886@linktechs.net" rel="nofollow" target="_blank">cc1d4c6d496b48a4a59fe7f2301e0886@linktechs.net</a>><br></div><div dir="ltr">Content-Type: text/plain; charset="us-ascii"<br></div><div dir="ltr"><br></div><div dir="ltr">Ok, has to be a simple solution.<br></div><div dir="ltr"><br></div><div dir="ltr">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<br></div><div dir="ltr"><br></div><div dir="ltr">What I want is to flatten these, to where ONLY the exact area that is show is displayed in the smallest file possible.<br></div><div dir="ltr"><br></div><div dir="ltr">Union is the way to do this but its SLOW SLOW.. any other options... ?<br></div><div dir="ltr"><br></div><div dir="ltr">*****************************************<br></div></div>
</div>
</div></body></html>