[postgis-users] polygons inside polygon

[paul.malm at lfv.se]

Hi,
I have a polygon layer where polygons are inside other polygons (could be polygons in polygons in polygons...).
I would like to separate them in 2 different layers, one layer with the outer most polygon and one layer with all polygons that has a surrounding polygon.
Is there a smart way to do this in SQL?

Thanks,
Paul
    [1_LFV_svensk_96]
  Paul Malm

  Operations / AIM Flyginfo SE



  Direkt  08-797 70 23  Mobil 070-860 11 15
  paul.malm at lfv.se
   Besöks- och postadress
   LFV Flyginfo SE
   Af Pontins väg 6
   115 21 STOCKHOLM







   Tänk på miljön innan du skriver ut detta e-postmeddelande.





-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20211130/6a4b8fbf/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 3211 bytes
Desc: image001.jpg
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20211130/6a4b8fbf/attachment.jpg>