> 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 _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
