Reply #146: Yes, but the idea of a manual process for 1436 precincts

[jmknapp]

...is somewhat daunting. I did find something pretty good though: a web site that lets one enter a geographic coordinate (lat, lon) and a radius in miles and it outputs the estimated black % in that radius. The site is http://mcdc2.missouri.edu/websas/caps.html

I automated a little script that hit that web site with the lat,lon for each of the 1436 precincts, for a radius of 0.5 miles around the center of each precinct. This isn't perfect, since precincts can have some pretty odd shapes, but it's probably as good as any other option.

An updated spreadsheet with the estimated black % in each precinct is at http://copperas.com/cuyahoga/cuyahogaofficial.zip

Hope you can use!

Here's one chart of interst I made from that data:



Pretty interesting how that works out. I guess it goes along with the observation that there tend to be more precincts per polling place out in the suburbs?