[postgis-users] RE : Bounding Box intersection

[Francois Hugues]

Coordinates of a rectangle, you mean of thé points at the corners ?

You should try st_makepolygon(st_makeline()) or st_makeenvelope.

Postgis manual is very useful, you should also try it to learn how these function work and which one is tthe better one for you

Hugues


----- Message d'origine--------
De: postgis-users-bounces at postgis.refractions.net de la part de Ed Linde
Date:7/2012 14
À: PostGIS Users Discussion
Objet : [postgis-users] Bounding Box intersection
 
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?

Cheers,o
Ed

-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 3031 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120713/ac73af96/attachment.bin>