[postgis-users] query question group by envelope

[strk at refractions.net]

On Sat, Feb 05, 2005 at 11:14:01AM -0800, Jon Saints wrote:
> hi list
> 
> I am learning postgis sql sytax. I have a set of
> polygons representing the islands of indonesia loaded
> into a postgis table.  Each of the polygons has an
> attribute which is the name of the province that the
> island belongs.  
> 
> How can write a query to find the max envelope extent
> of all islands for a given province?

SELECT extent(the_geom), province FROM mytable GROUP BY province;

--strk;

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