Are there any food establishments in residentially zoned areas in Ann Arbor.
- Submit a public records request to the the Washtenaw County Health Department for licensed food establishments.
- They responded with a PDF. I used the Gemini 2.5 Pro model to extract the data into a spreasheet.
- Spotchecked 30 row at random for accurate extraction
- Geocoded the addresses with the Google MAPS Geocoder
- Download the zoning districts
- Do a spatial join to find the zoning of geocoded Ann Arbor establishments
Use only as a preliminary indicator. The PDF extraction and geocoding can go awry.