Return to Snippet

Revision: 33935
at March 5, 2012 00:44 by wildpeaks


Updated Code
-- If `polygons` is a column containing multipolygons, this returns one row per polygon.

SELECT id AS id, ST_Box2D((ST_Dump(polygons)).geom) AS bbox FROM mytable WHERE polygons IS NOT NULL;

Revision: 33934
at October 15, 2010 01:52 by wildpeaks


Initial Code
SELECT id AS id, ST_Box2D((ST_Dump(polygons)).geom) AS bbox FROM mytable WHERE polygons IS NOT NULL;

Initial URL


Initial Description
**Important: this snipplet has moved to Github.**

 - [Bounding box of a MULTIPOLYGON column in PostGIS](https://gist.github.com/1973043)

Initial Title
PostGIS: Bounding box of a MultiPolygon column

Initial Tags


Initial Language
SQL