"United States Farmers Market API"I'm always on the lookout for innovative data sets and examples of APIs that provide value in ever-day life. APIs are often a very geeky thing, and I'm always trying to find examples of APIs that make sense to my mainstream audience, and help me explain what APIs are, and the value they can deliver.
I found a story from John Mertens of Code for America, about building a Famers Market API, which I think tells a great story about how anyone with a need, can take a valuable dataset and make it available using an API.
Like many of us Mertens loves getting his fruit and vegetables from a local Farmers Market. He was new to the San Francisco area and was unsure how to find the local Farmers Market. After Googling he found the USDA web site which has a great web application to search for Farmers Markets in the United States. It is a great tool, and they also allow you todownload a spreadsheet of the data, but there is no API to build an application on.
So being a data geek (I totally understand), Merts felt compelled to liberate this data using an API, which he build using a couple of freely available technologies:
- Exported the Famers Market dataset using the USDA export to excel
- Normalized the data using Google Refine
- Uploaded it to a free couchdb instance
- Added a map using the open-source geocouch-utils CouchApp
Now anyone can build an application around Farmers Market data using his Farmers Market API.