<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">Yay, it works... now time to make it output in sq kilometers with an area() and a transform()<BR><BR>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">----- Original Message ----<BR>From: Michael Fuhr <mike@fuhr.org><BR>To: Curtis W. Ruck <ruckc@yahoo.com>; PostGIS Users Discussion <postgis-users@postgis.refractions.net><BR>Sent: Thursday, September 21, 2006 9:04:25 PM<BR>Subject: Re: [postgis-users] ConvexHull Aggregate?<BR><BR>
<DIV>On Thu, Sep 21, 2006 at 06:26:37PM -0700, Curtis W. Ruck wrote:<BR>> SELECT convexhull(collect(the_geom)), category, count(*) FROM tblName GROUP BY category;<BR>> <BR>> convexhull isn't an aggregate function so it can't work in this context. <BR><BR>Works here, just as AsText(collect(the_geom)) would. What happened<BR>when you tried it?<BR><BR>-- <BR>Michael Fuhr</DIV></DIV><BR></DIV></div></body></html>