Paul,
I think it's a waste of time. Your best bet is to collect your geometries into groups an do a convex hull of each group and then the convexhull of the convexhulls Leo http://www.postgis.us <http://www.postgis.us/> _____ From: [email protected] [mailto:[email protected]] On Behalf Of Paul & Caroline Lewis Sent: Wednesday, July 27, 2011 5:32 AM To: PostGIS Users Subject: [postgis-users] Array Size Error Thanks for the responses. Have changed the original query from this: SELECT ST_ConvexHull(ST_Collect(ST_Force_2D(geom))) FROM table001 to this: SELECT ST_ConvexHull(ST_MemUnion(geom)) FROM table001 and its still running; over 12 hours now. Is this a waste of time. I'm trying it this way as I guessed it could be an aggregate approach issue after reading this post from Paul: http://blog.cleverelephant.ca/2009/01/must-faster-unions-in-postgis-14.html and was wondering if the union operation might work for my current requirements so set it running yesterday. The ST_Union gives the same array size error after a few seconds but as I said the ST_MemUnion is still running, but is it working or going to work!!! Anyway, thanks again for your feedback. Paul
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
