« Return to Thread: Select Point or PolyGon Polyline in Box

RE: Select Point or PolyGon Polyline in Box

by anhtin :: Rate this Message:

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)

when u show me ex: with point is excatly
SELECT *
FROM province WHERE GeomFromText('POINT(472825.36726087 2140555.40234783)', 42102) && the_geom
AND distance(the_geom, GeomFromText('POINT(472825.36726087 2140555.40234783)', 42102)) = 0

but i try same with Box is error
can u show me???

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@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] On Behalf Of
anhtin
Sent: Tuesday, April 10, 2007 6:18 AM
To: postgis-users@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@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@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

« Return to Thread: Select Point or PolyGon Polyline in Box