Scrape store info from schnucks website

schnucks_location_scraper.rb

require 'mechanize'
require 'CSV'
require 'byebug'

robot = Mechanize.new

schnucks = robot.get 'http://www.schnucks.com/stores/'

CSV.open('./schnucks_data.csv', 'wb') do |csv|
  csv << %w(Name Street City State Zip Phone ID)
  schnucks.links_with(href: /stores\/store\.asp/).each do |link|
    begin
      name = link.text.strip.match(/(.*)/)[1]
      page = link.click
      address= page.at("span[itemprop='address']").children
      street = address[0].text.strip
      city, state, zip = *address[2].text.strip.split(' ')
      id = page.uri.query.split('=')[1]
      phone = page.at("span[itemprop='telephone']").children.text

      csv << [name, street, city, state, zip, phone, id]
    rescue Exception => e
      debugger
    end
  end
end