Is there is a way in QGIS (or SQL, ArcMap) to split multi-geometries in polygons automatically. I could do this manually (split features, split multi-part to single-part etc...), but this would just be so time consuming. Here's a visual of what I'm wanting the polygons to look like:
As you can see polygon 2 has been broken up into 5 polygons instead of being a single polygon in polygon 1. I tried what this person has done in SQL HERE, but then that would only break polygon 1 into three polygons still having a multi-geometry polygon.
Is there a way to automate this process?