This data feed would serve both parents with children in school and those are looking for schools for their children. Poorly maintained schools need to be identified to help with the improvement of conditions for their current and future students.
Identify Data:
Complaint Type
Descriptor
School Maintenance
Broken Water Fountain
School Maintenance
Other School Condition
School Maintenance
Plumbing Problem
School Maintenance
Asbestos
School Maintenance
Poison Ivy
School Maintenance
Unclean Condition
School Maintenance
Broken Fence
School Maintenance
Air Conditioning Problem
School Maintenance
Graffiti
School Maintenance
Lack of Supplies
School Maintenance
Broken Lock
School Maintenance
Broken Windows
School Maintenance
Rodents/Mice
School Maintenance
Heating Problem
School Maintenance
Leaky Roof
School Maintenance
Snow/Ice
Ruby / SQL
query = {
'$limit' => 1000,
'$order' => 'created_date DESC',
'$where' => <<-WHERE.oneline
created_date >= '#{28.days.ago.iso8601}' AND
longitude IS NOT NULL AND
latitude IS NOT NULL AND
complaint_type = "School Maintenance" AND
unique_key IS NOT NULL
}
User Story:
This data feed would serve both parents with children in school and those are looking for schools for their children. Poorly maintained schools need to be identified to help with the improvement of conditions for their current and future students.
Identify Data:
Ruby / SQL
Issue Icon: