[postgis-users] ConvexHull Aggregate?
Curtis W. Ruck
ruckc at yahoo.com
Fri Sep 22 09:55:13 PDT 2006
Yay, it works... now time to make it output in sq kilometers with an area() and a transform()
----- Original Message ----
From: Michael Fuhr <mike at fuhr.org>
To: Curtis W. Ruck <ruckc at yahoo.com>; PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Sent: Thursday, September 21, 2006 9:04:25 PM
Subject: Re: [postgis-users] ConvexHull Aggregate?
On Thu, Sep 21, 2006 at 06:26:37PM -0700, Curtis W. Ruck wrote:
> SELECT convexhull(collect(the_geom)), category, count(*) FROM tblName GROUP BY category;
> convexhull isn't an aggregate function so it can't work in this context.
Works here, just as AsText(collect(the_geom)) would. What happened
when you tried it?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users