I love getting my fruit and veggies from my local Farmer’ Market. Unfortunately, as a recent SF transplant I wasn’t sure how to find my local Farmers’ Market. A quick search led me to a USDA website which seemed to contain most of the markets in the country.
Being an open data geek, I looked for an API. Finding none, I decided to make one. To do this, I:
- Used the “Export to Excel” function to download the whole dataset.
- Cleaned it up in Google Refine; normalized some fields, geocoded some records, added a geojson fields.
- Uploaded it to a free couchdb instance.
- Added the open source geocouch-utils CouchApp (which gives you a nice map out of the box).
All of this was done in about an hour and at a cost of $0.