Re: [SQL] a spatial table's bounding box

2011-10-05 Thread Asli Akarsakarya
Thank you very much. >I would try >SELECT st_envelope( st_collect(geom) ) FROM roads; >HTH, Filip>> >I want to get the extensions of spatial table. Say that there is a spatial >table named 'roads', and a some road geometry inside. I want to fetch the >bounding box (envelope or extension) for t

[SQL] a spatial table's bounding box

2011-09-23 Thread Asli Akarsakarya
Hello,  My question is a basic one for postGIS, I believe. It should have a primitive answer somewhere, but I don't have it.  I want to get the extensions of  spatial table. Say that there is a spatial table named 'roads', and a some road geometry inside. I want to fetch the bounding box (envelo