X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/33a65a90c9d0e2ab121e1da9c3efedaf9e6a9789..22bef89d1a97bf8206a951cc777061792a868b02:/lib/quad_tile.rb diff --git a/lib/quad_tile.rb b/lib/quad_tile.rb index cb1b5a06e..1f7e6e501 100644 --- a/lib/quad_tile.rb +++ b/lib/quad_tile.rb @@ -39,9 +39,28 @@ module QuadTile return t end + + def self.iterate_tiles_for_area(minlat, minlon, maxlat, maxlon) + tiles = tiles_for_area(minlat, minlon, maxlat, maxlon) + first = last = nil + + tiles.sort.each do |tile| + if last.nil? + first = last = tile + elsif tile == last + 1 + last = tile + else + yield first, last + + first = last = tile + end + end + + yield first, last unless last.nil? + end end - def self.sql_for_area(minlat, minlon, maxlat, maxlon) + def self.sql_for_area(minlat, minlon, maxlat, maxlon, prefix) sql = Array.new single = Array.new @@ -49,33 +68,14 @@ module QuadTile if first == last single.push(first) else - sql.push("tile BETWEEN #{first} AND #{last}") + sql.push("#{prefix}tile BETWEEN #{first} AND #{last}") end end - sql.push("tile IN (#{single.join(',')})") if single.size > 0 + sql.push("#{prefix}tile IN (#{single.join(',')})") if single.size > 0 return "( " + sql.join(" OR ") + " )" end - def self.iterate_tiles_for_area(minlat, minlon, maxlat, maxlon) - tiles = tiles_for_area(minlat, minlon, maxlat, maxlon) - first = last = nil - - tiles.sort.each do |tile| - if last.nil? - first = last = tile - elsif tile == last + 1 - last = tile - else - yield first, last - - first = last = tile - end - end - - yield first, last unless last.nil? - end - private_class_method :tile_for_xy, :iterate_tiles_for_area end