I’d like to play with data visualizations of schools in San Francisco. So, let’s start with high schools, and narrow it down to non-charter public high schools. I spent some time finding data on the 18* public high schools in SF and learning how to use fusion tables (woohoo!).
So here it is, my first attempt, Part 1! A map of all the public high schools in San Francisco. Color coded markers based on # of students with free/reduced lunch. Click on the map below and you’ll be able to click on the markers and see more info about the schools. Check it out and let me know what you think!
And here is Part 2! Same map, now with color coded markers based on most recent API score (CA’s Academic Performance Index, which is currently suspended). Click on the map below and you’ll be able to click on the markers and see more info about the schools. Check it out and let me know what you think!
One of the first things we notice is the overlap between the two maps. Sad to see that the percentage of low income students persists as an indicator of school performance in San Francisco. I’m curious what else you see here and what questions this raises for you. What other ways would you like to see SF education info presented– exact correlations? a map of all the school mascots? Photos of the cafeterias? I’d love your input! Also curious how this is perceived by people who are or are not familiar with the city.
Suggestions on other mapping tools I should use are also welcome.
*According to SFUSD, there are 18 high schools in the district. According to GreatSchools, there are 23 (it seems to include 5 additional special education programs in the list). Wikipedia includes 17 of these (it doesn’t include the Academy of Arts and Sciences), listing 9 of them as “comprehensive” and 8 as “alternative.” Wiki also includes charter schools on its list. The 18 public schools in SF I mapped are:
- Academy of Arts and Sciences
- Balboa High School
- Burton High School
- Downtown High School
- Galileo Academy of Science and Technology
- Independence High School
- International Studies Academy
- Jordan High School
- Lincoln High School
- Lowell High School
- Marshall High School
- Mission High School
- O’Connell High School
- School of the Arts
- SF International High School
- Wallenberg High School
- Washington High School
- Wells High School