[postgis-users] good way to collect

[strk at refractions.net]

On Mon, May 16, 2005 at 09:38:26AM -0400, Purvis, Charlton wrote:
> Hi, folks:
> 
> I thought doing a collect(the_geom) on a group of counties would produce a
> state-wide view of all the counties in one row.  The collect goes through
> fine, but it turns out to be a not isvalid(the_geom) result set.  The
> counties are each MULTIPOLYGON's from a shp2pgsql, and their the_geom's are
> all valid.

A collect of MULTIPOLYGONS should return a GEOMETRYCOLLECTION.
If all components are valid I think result should also be.
Try running isvalid on all rows and on result.
A false return should also raise a NOTICE about the specific
invalidity

--strk;

> 
> Thanks for the help.
> 
> Charlton

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