Portland School Data

portland_school_data.csv

portland_school_data.rb

require 'json'
require 'net/http'
require 'csv'

module PortlandSchoolData
  HOST = URI("http://api.civicapps.org/schools/")
  @@school_data = [%w[ID Name OverallRating NumberOfStudents
                      DropoutsCurr DropoutsLast
                      AttendancePctCurr AttendancePctPrev
                      MathPctCurr MathPctPrev SchoolType]]

  def self.fetch
    schools = JSON.parse(Net::HTTP.get(HOST))
    school_ids = schools["results"].map { |school| school["SchoolID"] }

    school_ids.each do |id|
      curr_school = JSON.parse(Net::HTTP.get(HOST + id))

      if curr_school.class == Hash
        curr_school = curr_school["results"]
        @@school_data << [id,
                          standardize_name_spacing(curr_school["SchoolName"]),
                          curr_school["OverallRating"],
                          curr_school["SchoolInformation"]["StudentPopulation"]["NumberOfStudents"].to_i,
                          curr_school["SchoolInformation"]["Dropouts"]["DropoutStudentsCurrYear"].to_i,
                          curr_school["SchoolInformation"]["Dropouts"]["DropoutStudentsPrevYear"].to_i,
                          curr_school["SchoolInformation"]["Attendance"]["AttendancePctCurrYear"].to_f,
                          curr_school["SchoolInformation"]["Attendance"]["AttendancePctPrevYear"].to_f,
                          curr_school["Performance"]["AchievementData"]["MathStudExceedMeetAllGradePctCurrYear"].to_f,
                          curr_school["Performance"]["AchievementData"]["MathStudExceedMeetAllGradePctPrevYear"].to_f,
                          curr_school["SchoolType"]]
      end
      CSV.open("portland_school_data.csv", "wb") do |csv|
        @@school_data.each do |row|
          csv << row
        end
      end
    end
  end

  private

  def self.standardize_name_spacing(name)
    name.to_s.squeeze(" ")
  end
end

PortlandSchoolData.fetch