{"id":2552,"date":"2009-09-15T18:18:01","date_gmt":"2009-09-16T01:18:01","guid":{"rendered":"http:\/\/cyrusfarivar.com\/blog\/?p=2552"},"modified":"2009-09-15T18:18:01","modified_gmt":"2009-09-16T01:18:01","slug":"creating-a-new-sf-bay-area-farmers-market-map","status":"publish","type":"post","link":"https:\/\/cyrusfarivar.com\/blog\/2009\/09\/15\/creating-a-new-sf-bay-area-farmers-market-map\/","title":{"rendered":"Creating a new SF Bay Area Farmer&#8217;s Market map"},"content":{"rendered":"<p><a href=\"fu\"><center><img decoding=\"async\" src=\"http:\/\/farm1.static.flickr.com\/88\/266751887_1221871511_d.jpg\"\/><\/center><\/a><\/p>\n<p>So I have a set of data in a <a href=\"https:\/\/spreadsheets.google.com\/ccc?key=0AhjHI1hkJ6DedDFLVlhYWHQ5UEVIQVc2YktIcUh1RGc&#038;hl=en\">Google Docs spreadsheet of SF Bay Area Farmer&#8217;s Markets<\/a>. 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. <\/p>\n<p>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&#8217;s markets and list them (and ideally plot them on a Google Map).<\/p>\n<p>Example:<\/p>\n<p>Today is: Tuesday<br \/>\nI&#8217;m in: Oakland<br \/>\nMy ZIP is: 94618<\/p>\n<p>Click here to show me the markets!<\/p>\n<p>I think this should be pretty easy. It doesn&#8217;t need to be fancy, just functional. Who can do this and\/or show me how to do it myself?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>So I have a set of data in a Google Docs spreadsheet of SF Bay Area Farmer&#8217;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&hellip;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"aside","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[64,80,121],"tags":[],"class_list":["post-2552","post","type-post","status-publish","format-aside","hentry","category-food","category-hackery","category-maps","post_format-post-format-aside"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4uks-Fa","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/cyrusfarivar.com\/blog\/wp-json\/wp\/v2\/posts\/2552","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cyrusfarivar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cyrusfarivar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cyrusfarivar.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/cyrusfarivar.com\/blog\/wp-json\/wp\/v2\/comments?post=2552"}],"version-history":[{"count":0,"href":"https:\/\/cyrusfarivar.com\/blog\/wp-json\/wp\/v2\/posts\/2552\/revisions"}],"wp:attachment":[{"href":"https:\/\/cyrusfarivar.com\/blog\/wp-json\/wp\/v2\/media?parent=2552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cyrusfarivar.com\/blog\/wp-json\/wp\/v2\/categories?post=2552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cyrusfarivar.com\/blog\/wp-json\/wp\/v2\/tags?post=2552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}