[postgis-users] Select Point or PolyGon Polyline in Box

[Obe, Regina]

Assuming your box is in the same srid as your points.  It would be
something like

SELECT *
FROM pointdemo
WHERE  the_point && setsrid('BOX(295149 2315499, 465992
2163790)'::box2d, -1)


Note - above I am assuming your point geometry is called the_point and
your SRID is -1
If the srid of your point geometry is not -1 then change  -1 to what it
should be.


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
anhtin
Sent: Tuesday, April 10, 2007 6:18 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Select Point or PolyGon Polyline in Box


hi all
i have question to postgis
i have table Pointdemo
I want select all point in my Box("Rectangle") on PostGis
my box is corrdinate 
ex: full extend is:Box(110638 2587481, 903350 1972446) ---> xmin ymin,
xmax
ymax
i want select point in Box(295149 2315499, 465992 2163790)  ---> xmin
ymin,
xmax ymax
How will i do that ?????


-- 
View this message in context:
http://www.nabble.com/Select-Point-or-PolyGon-Polyline-in-Box-tf3552167.
html#a9916986
Sent from the PostGIS - User mailing list archive at Nabble.com.

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.