[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
  geom && Expand(GeometryFromText('POINT(10000 20000)',2769),900)
  Distance(geom,GeometryFromText('POINT(10000 20000)',2769) < 900

How efficient would something like that be against say 5000 rows?


More information about the postgis-users mailing list