Re: [postgis-users] Bounding Box intersection

2012-07-14 Thread Mike Toews
On 14 July 2012 00:35, Ed Linde wrote: > Hi All, > I have a table with linestring geometries, and I have the co-ordinates of a > rectangle/ bounding box. > I want to get only a restricted set of geometries that lie within or > intersect with this box. Is there a > way to construct this box on the

[postgis-users] Bounding Box intersection

2012-07-13 Thread Ed Linde
Hi All, I have a table with linestring geometries, and I have the co-ordinates of a rectangle/ bounding box. I want to get only a restricted set of geometries that lie within or intersect with this box. Is there a way to construct this box on the fly and get only the relevant set of geometries? Ch