[postgis-users] st_union

[paul.malm at lfv.se]

Thanks, I'll try it to see if it is faster than:
CREATE TABLE public." Areas_union " AS select  (ST_dump(ST_Buffer(St_Collect(the_geom), 0))).geom as "the_geom"  from " Areas";
/Paul

-----Ursprungligt meddelande-----
Från: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] För Sandro Santilli
Skickat: den 3 mars 2020 10:18
Till: PostGIS Users Discussion
Ämne: Re: [postgis-users] st_union

On Mon, Mar 02, 2020 at 02:25:52PM +0000, paul.malm at lfv.se wrote:
> Hi list,
> I would like to do this:
> CREATE TABLE public."Areas_union" AS select  (st_dump(st_union("the_geom"))).geom from "Areas";
> 
> But it takes such a long time to execute, is there a smarter way to do it?

Try this:

  CREATE TABLE public."Areas_union" AS select
  (st_dump(st_unaryunion(st_collect("the_geom")))).geom from "Areas";

--strk;
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users