[postgis-users] Re: Newbie questions on what geometry to use
snacktime
snacktime at gmail.com
Mon Jul 3 19:40:44 PDT 2006
I think I found the best solution to my problem. Set a bounding box
on the point I am searching from in conjunction with Distance. Like
so (I found this in another post):
SELECT AsText(geom) FROM point_table
WHERE
geom && Expand(GeometryFromText('POINT(10000 20000)',2769),900)
AND
Distance(geom,GeometryFromText('POINT(10000 20000)',2769) < 900
How efficient would something like that be against say 5000 rows?
Chris
More information about the postgis-users
mailing list