[postgis-devel] polygonize

[strk at refractions.net]

On Sun, Dec 19, 2004 at 11:22:09AM -0500, Carl Anderson wrote:
> 
> Since polygonize() seems to able to act as a general polygon cleaning 
> function
> how about adding a direct function to call it, in addition to the 
> aggregate form.
> 
> update shapes set the_geom = polygonize(the_geom);
> 
> so we don't have to
> 
> update shapes set the_geom = f.new_geom
>     from ( select polygonize(the_geom) as new_geom, gid
>                     from shapes
>                     group by gid ) as f
>   where
>          f.gid = shapes.gid;

If you find it useful I don't see why not.
The point is I didn't much exploit capabilities of polygonize().

> btw
> 
> select polygonize_garray(array_append('{}',the_geom) from shapes;
> Causes a backend ABEND;

Does collect_garray(array_append('{}',the_geom) from shapes work ?

--strk;

> 
> 
>   C.                
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel