Database Reference
In-Depth Information
5. Now,inthe
invalid_geometries
table,youhavetheinvalidandvalidver-
sionofthepolygon.Itiseasytofigureoutthattheself-intersectionringwas
removedby
ST_MakeValid
byaddingonesupplementaryringtotheorigin-
alpolygon,whichresultedinavalidgeometry,accordingtotheOGCstand-
ard:
postgis_cookbook=# SELECT status,
ST_NRings(the_geom) FROM
chp03.invalid_geometries;
status | st_nrings
----------+----------
broken | 1
repaired | 2
(2 rows)
6. Nowthat youhaveidentified theproblemanditssolution, don't forget tofix
alloftheotherinvalidgeometriesinthe
countries
tablebyexecutingthe
following code: