AW: [postgis-users] Dissolve obsolete polygon borders
Düster Horst
Horst.Duester at bd.so.ch
Wed Oct 15 08:08:16 PDT 2003
strk
Thank you for your response. I doesn't work, PostgreSQL responses with
"GEOS union() threw an error!".
Horst
-----Ursprüngliche Nachricht-----
Von: strk [mailto:strk at keybit.net]
Gesendet am: Mittwoch, 15. Oktober 2003 14:58
An: PostGIS Users Discussion
Betreff: Re: [postgis-users] Dissolve obsolete polygon borders
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
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
More information about the postgis-users
mailing list