Durham health inspection data with coordinates as geoJSON https://github.com/codefordurham/Durham-Data/tree/master/Restaurants

convert_to_json.rb

require 'pp'
require 'active_support/all'
# require 'colored'
require 'json'

results = JSON.parse(File.read("../json/raw/dump-data-science.json"))

geo_json = {
    :type => "FeatureCollection",
    :features => []
  }

results.each_with_index do |location, index|
  puts location['premise_name_titlecase']
  unless location['premise_name_titlecase'] == "Oh! Brian's"

    venue = {
      :type => "Feature",
      :id => location['est_id'],
      :geometry => {
        :type => "Point",
        :coordinates => [location['geo_results']['results'][0]['geometry']['location']['lng'], location['geo_results']['results'][0]['geometry']['location']['lat']]
      },
      :properties => location.except!("geo_results")
    }
    # venue = {
    #     :type => "Point",
    #     :coordinates => [location['geo_results']['geometry']['location']['lng'], location['geo_results']['geometry']['location']['lat']]
    #   }
    geo_json[:features] << venue
  end
end

pp geo_json.to_json

File.open("../json/formatted/dump-data-science.json","w") do |f|
  f.write(geo_json.to_json)
end

durham-health-data.json

geoencode.rb