[postgis-users] query question group by envelope

strk at refractions.net strk at refractions.net
Sun Feb 6 01:52:21 PST 2005

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;


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

More information about the postgis-users mailing list