[postgis-users] Problem cleaning invalid geometries

[Andrea Peri]

In trunk version (2.0.0) of postgis there is a new function
ST_MakeValid(..) that try to resolve invalidity.
It work pretty well.

ps:

Because its goal is not lost no-one vertex, sometimes return a
GeometryCollection.
so is necessary extract from the output the polygon part of collection.

sometimes like:

...
(
CASE
            WHEN
                ST_GeometryType("geom")='ST_GeometryCollection'
            THEN
                ST_CollectionExtract("geom", 2)
            ELSE
                "geom"
) as geom
-- 

-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100819/7a72e81d/attachment.html>