X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/d45db3acc42f2f19ac7df25e7c7af70559cfba3d..042388418411da6facdfe6ae590df6c17f85e88c:/lib/osm.rb diff --git a/lib/osm.rb b/lib/osm.rb index aab3e1335..e5d3c7fbb 100644 --- a/lib/osm.rb +++ b/lib/osm.rb @@ -410,4 +410,15 @@ module OSM return Digest::MD5.hexdigest(password) if salt.nil? return Digest::MD5.hexdigest(salt + password) end + + # Return an SQL fragment to select a given area of the globe + def self.sql_for_area(minlat, minlon, maxlat, maxlon) + tilesql = QuadTile.sql_for_area(minlat, minlon, maxlat, maxlon) + minlat = (minlat * 1000000).round + minlon = (minlon * 1000000).round + maxlat = (maxlat * 1000000).round + maxlon = (maxlon * 1000000).round + + return "#{tilesql} AND latitude BETWEEN #{minlat} AND #{maxlat} AND longitude BETWEEN #{minlon} AND #{maxlon}" + end end