geocode texas beverage tax receipts

gistfile1.txt

require 'rubygems'
require 'cgi'
require 'net/http'
require 'open-uri'
require 'json'



file = File.open('bev01-22.tsv').read
data = Array.new 
base_url = 'http://www.datasciencetoolkit.org/maps/api/geocode/json?sensor=false&address='

file.each_line do |line|
	row = line.split("\t").map(&:strip)
	address = CGI.escape([row[2],row[3],row[4],row[5]].join(','))
	uri = base_url + address
	response = JSON.parse(URI.parse(uri).read)
	row << response["results"][0]["geometry"]["location"]["lng"]
	row << response["results"][0]["geometry"]["location"]["lat"]
	data << row

end


out = File.new("bev01-22_out.tsv", 'w')
data.each do |d|
  out.puts(d.join("\t"))
end
out.close