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

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

2011-09-23 Thread Filip Rembiałkowski
2011/9/22 Asli Akarsakarya > > 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 that table, that means for all the > roads that it has. > > Accordin

[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