geocode_member_addresses

geocode-xxx

#!/usr/bin/env ruby

require 'json'
require 'net/http'
require 'pp'

member_data = JSON.parse(File.read('members.json'))
member_data.each do |leg_data|
  need_geo = leg_data["offices"].select { |o| o["latitude"] == "xxx" }
  next if need_geo == []

  need_geo.each do |a|
    pp address = "#{a["line1"]}, #{a["line2"]} #{a["city"]} #{a["state_code"]} #{a["zip"]}"
    parsed_url = URI.encode("https://maps.googleapis.com/maps/api/geocode/json?address=#{address}&key=XXX")
    uri = URI(parsed_url)
    pp resp = JSON.parse(Net::HTTP.get(uri))
    if resp["status"] == "ZERO_RESULTS"
      a["latitude"] = "ZERO_RESULTS"
      a["longitude"] = "ZERO_RESULTS"
    else
      location = resp["results"][0]["geometry"]["location"]
      pp a["latitude"] = location["lat"]
      pp a["longitude"] = location["lng"]
    end
  end
end

File.write("members2.json", JSON.dump(member_data))