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

[anhtin]

thanks reply 
but have some problem
i think the command doen't exact. because when i get box on the map have a
porvince but when i run in post have 2 result ???

SELECT gid, name, code, ma FROM province
 WHERE  the_geom && setsrid('BOX(472825.36726087 2140555.40234783,516561.185
2107753.53904348)'::box2d, 42102)



Obe, Regina     DND\MIS wrote:
> 
> 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.
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

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