[postgis-users] Problem cleaning invalid geometries

[L Bogert-OBrien]

I am not sure what you are trying to say with this, but the geometry
that I am trying to clean is a multipolygon, not a collection.  Yes, it
is very big and has many points in the multipolygon, since it is the
Baffin region, but it is not a collection.  ST_geometrytype returns
multipolygon for it.

Regards,

Loretta
-------------- next part --------------
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/4e72bc6c/attachment.html>
-------------- next part --------------
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users