This is interesting. Can we have an SQL to produce report on the status of polygon? Namely, can we write a script to tell us whether a geometry is a valid single geometry, or polygons inside polygon, whether there be any issues such as self-intersect in a polygon?
SQL reporting on geometry is of interest. Is it possible to send me a small file of polygons inside polygon in a format of CSV or Well Known Text, so that I can test out and confirm the robustness of SQL scripts? Regards, David On Tue, 30 Nov 2021 at 06:30, <[email protected]> wrote: > > > > > 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 > > [image: 1_LFV_svensk_96] > > Paul Malm > > > > Operations / AIM Flyginfo SE > > > > Direkt 08-797 70 23 Mobil 070-860 11 15 > [email protected] > > 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. > > > > > > > _______________________________________________ > postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
