Read CitySDK schools data, export to CSV

schools.rb

require 'json'

schools = JSON.parse(File.open('schools.json').read, {symbolize_names: true})

schools[:results].each do |school|
  data = school[:layers][:"duo.schools.secondary"][:data]

  lat, lon = school[:geom][:coordinates]  

  csv_row = {
    :professional => data[:niveau_pro],
    :vbo => data[:niveau_vbo],
    :vwo => data[:niveau_vwo],
    :havo => data[:niveau_havo],
    :mavo => data[:niveau_mavo],
    :vestigingsnaam => data[:vestigingsnaam],
    :lat => lat,
    :lon => lon
  }
  
  puts csv_row.inspect

end