[postgis-users] ¿obtain the bounding box from grup of poligon?

William Furnass will at thearete.co.uk
Wed Aug 18 09:21:22 PDT 2010


On 18 August 2010 20:05, salas <fsalas at geocuba.cu> wrote:
> Hi, i have the parcels table , and select various polygon
>
> ¿ how i can obtain the boundary of this group?

Try:

SELECT St_Envelope(St_Union(my_geometry_column)) FROM parcels;

Omit the 'St_Envelope(...)' bit if you want a multipolygon comprised
of all polygons rather than a bounding box.

Will



More information about the postgis-users mailing list