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
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 àèìòù
-----------------
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
