You will often find invalid geometries in your PostGIS database. These invalid geometries could compromise the functioning of PostGIS itself and any external tool using it, such as QGIS and MapServer. PostGIS, being compliant with the OGC Simple Features Specification, must manage and work with valid geometries.
Luckily, PostGIS 2.0 offers you the
ST_MakeValid function that, together with the
ST_IsValidDetails functions, is the ideal toolkit for inspecting and fixing geometries within the database. In this recipe, you will learn how to fix a common case of invalid geometry.
data/TM_WORLD_BORDERS-0.3.zip file into your working directory—
working/chp3. Import the shapefile ...