Advanced Search

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