X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/af68e07272f2f42a581b435dc0563fe8a862a562..22bef89d1a97bf8206a951cc777061792a868b02:/lib/osm.rb diff --git a/lib/osm.rb b/lib/osm.rb index 78d32e739..9ee36e0c7 100644 --- a/lib/osm.rb +++ b/lib/osm.rb @@ -498,23 +498,14 @@ module OSM # Return an SQL fragment to select a given area of the globe def self.sql_for_area(minlat, minlon, maxlat, maxlon, prefix = nil) - tilesql = QuadTile.sql_for_area(minlat, minlon, maxlat, maxlon, prefix) - minlat = (minlat * 10000000).round - minlon = (minlon * 10000000).round - maxlat = (maxlat * 10000000).round - maxlon = (maxlon * 10000000).round + tilesql = QuadTile.sql_for_area(minlat, minlon, maxlat, maxlon, prefix) - return "#{tilesql} AND #{prefix}latitude BETWEEN #{minlat} AND #{maxlat} AND #{prefix}longitude BETWEEN #{minlon} AND #{maxlon}" - end - - # Return an SQL fragment to select a given area of the globe without using the quadtile index - def self.sql_for_area_no_quadtile(minlat, minlon, maxlat, maxlon, prefix = nil, without_quadtile = :false) minlat = (minlat * 10000000).round minlon = (minlon * 10000000).round maxlat = (maxlat * 10000000).round maxlon = (maxlon * 10000000).round - return "#{prefix}latitude BETWEEN #{minlat} AND #{maxlat} AND #{prefix}longitude BETWEEN #{minlon} AND #{maxlon}" + return "#{tilesql} AND #{prefix}latitude BETWEEN #{minlat} AND #{maxlat} AND #{prefix}longitude BETWEEN #{minlon} AND #{maxlon}" end # Return a spam score for a chunk of text