Category Archives: GIS

Visualizing Immunization Rates in California Schools

Earlier this summer Governor Brown signed a law that will ban most vaccine exemptions in the State. Past time if you ask me. Vaccinations are a simple and safe way of keeping our kids, and society, safe from diseases that used to routinely kill and debilitate thousands each year.

I’d read the reports about vaccine rates being low in otherwise educated areas – take Marin for instance. But I was surprised when I looked at the data and found that rates in the small, liberal, educated town of Albany where I have two kids at elementary school are hovering right around 70 per cent. That’s far below the 90+ rate that we need if we are to protect those who cannot be vaccinated for valid medical reasons — my kids’ care giver is one. She’s deathly allergic to eggs.

The datasets I saw were all tabular — page after page of data. It had me thinking, with a little GIS could I make them more accessible? Turns out the answer was yes!

Check out the map below to see Kindergarten immunization rates in your community. You can search by school, or city. If you zoom out to a region, or the state, you can see the darker red spots where immunization rates are lower. Hit the full-screen button to see more of the data.  I found the data illuminating – it still doesn’t answer the question of why otherwise educated communities who trust in science fail to heed its advice in this case. It will be interesting to track rates over time and see what impact the new law has on the health of our communities and kids.

So how did I do this? I pulled the data from the Department of Education web-site and Department of Public Health.  School locations were located by their lat-long coordinates and then linked to the immunization rate data.  All that was done in ArcGIS Pro (thank you ESRI for introducing your $100 home license!). Unfortunately, their online mapping service appears to be limited to 1,000 records and there are many more Kindergarten schools in California! So I imported it all into CartoDB where it was straightforward (and free) to produce the map above.