[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