On Fri, Dec 14, 2012 at 3:02 PM, Martin Schafran <[email protected]>wrote:
> > > > Thanks a lot for the advice. The query as I previously mentioned it would > > be as simple as a "SELECT * FROM db WHERE X=X AND DISTANCE<5km". There > > wouldn't be more type of queries. > > > > > > what happens if X=X matches the half database? > a lot of comparisons. > > filter nodes by bbox > > WHERE ST_MakeBox2D(ST_GeomFromText(?, 4326), ST_GeomFromText(?, 4326)) && > n.geom > > statement.setString(1, lowerLeft.toString()); > statement.setString(2, upperRight.toString()); > > and then > DISTANCE<5km http://postgis.refractions.net/docs/ST_DWithin.html
_______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
