[postgis-users] Dissolve obsolete polygon borders

[strk]

Try this:

CREATE AGGREGATE unite (
        sfunc = GeomUnion,
        basetype = geometry,
        stype = geometry
); -- this creates an aggregate out of GEOS's geomunion()

-- and this is your query 
SELECT your_attribute, unite(the_geom)
	FROM your_table
	GROUP BY your_attribute;

Note that GEOS cvs version is pretty memory absorbing (actually leaking)
and probably also buggy. Please let me know whether it worked for you.

--strk;

Horst.Duester wrote:
> Is there a way to dissolve obsolete borders between polygons with equal
> attributes??
>  
> I will appreciate your hints.
>  
> Horst
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users