So I have a set of data in a Google Docs spreadsheet of SF Bay Area Farmer's Markets. Each market has data for the following columns: Day, County, Location, Hours, Months, Intersection, City, State, ZIP, Phone, URL. There are entries for over 100 markets.
What I want is a simple web page (ideally iPhone-friendly) that will have a few text input fields: ZIP, City, Day (or even a pull-down menu for each one). Then based on those inputs, the program would pull the five nearest farmer's markets and list them (and ideally plot them on a Google Map).
Example:
Today is: Tuesday
I'm in: Oakland
My ZIP is: 94618
Click here to show me the markets!
I think this should be pretty easy. It doesn't need to be fancy, just functional.
Hi. I have several ideas on the design and implementation of this website. I have extensive experience working with Google Data and geocoding, in fact I have done a similar application that would identify cellular towers based on a users location. Thank you for your consideration.