Download all valid addresses for Boulder, CO

fetch_boulder_addresses.rb

#!/usr/bin/env ruby

require 'csv'
require 'active_support/all'

OUTPUT_FILENAME = 'boulder_addresses.txt'

if !FileTest.exist?("Owner_Address.csv")
  puts 'downloading address data...'
  `wget http://assessor.boco.solutions/ASR_PublicDataFiles/Owner_Address.csv`
else
  puts 'address data already downloaded...'
end

puts 'formatting addresses...'
addresses = CSV.open("Owner_Address.csv", headers: true).map do |r|
  street_address = [
    r["str_num"],
    r["str_pfx"],
    r["str"].try(:titleize),
    r["str_sfx"].try(:titleize)
  ].compact.reject(&:empty?).join(' ')

  [street_address, r["city"].try(:titleize), "CO"].compact.reject(&:empty?).join(', ')
end

puts 'filtering addresses...'
filtered_addresses = addresses.
  uniq.
  select{ |l| l.include?("Boulder, CO") }.
  sort_by{ |l| l.gsub(/\d+ /, '') }

puts 'writing to file...'
File.open(OUTPUT_FILENAME, "w") do |f|
  filtered_addresses.each do |l|
    f.puts(l)
  end
end