openfarmcc / OpenFarm

A free and open database for farming and gardening knowledge. You can grow anything!
https://OpenFarm.cc
MIT License
1.55k stars 239 forks source link

hardiness zone data! #758

Open emplums opened 8 years ago

emplums commented 8 years ago

Just leaving this here - spreadsheet of all the hardiness zones for every zipcode hardiness_zones.csv.zip

cc @roryaronson @simonv3

roryaronson commented 8 years ago

BOOOM :boom:

roryaronson commented 8 years ago

Here's the CSV uploaded to a Google Spreadsheet for immediate viewing/manipulation: https://docs.google.com/spreadsheets/d/1JCi8GAY3G6jt0Fpl6xNFTbggLiPRHa2xQ3AggDn7_zA/edit?usp=sharing

simonv3 commented 7 years ago

Hey @emily-plummer, could you link to where you got this? It's my understanding that hardiness zones sometimes update (which I guess makes sense?) so we might want to re-run the process of getting that information occasionally.

simonv3 commented 7 years ago

So what makes sense to me is to on save of a user object to link a hardiness zone based on the CSV values?

emplums commented 7 years ago

@simonv3 unfortunately, this data used to be public (via a scraper that took 8 hours to run on your computer to pull the data) but some company decided that they "own" hardiness zone data and made the org that was hosting it pull it down.

simonv3 commented 7 years ago

Seriously? I'm just looking into the USDA website - is Climate Source, Inc the company in question?

http://planthardiness.ars.usda.gov/PHZMWeb/DownloadsPublic.aspx

Um. I need to vent some rage about this somewhere.

simonv3 commented 7 years ago

Looks like the company who owned the hardiness zone data went broke so now this data is brokered through Oregon State University. This data can now be combined to zipcodes through the frostline repo: https://github.com/waldoj/frostline. The issue of interest to us is probably https://github.com/waldoj/frostline/issues/13 (making it available as a public API)

waldoj commented 7 years ago

Per @simonv3's comment, I'm getting this set up at phzmapi.org right now. (I just registered the domain about 15 minutes ago.) It's an S3 bucket, with one JSON file per ZIP code that's included in OSU's CSV file, e.g. for 20001. There's lots more to be done, but it's useful as-is. I hope it can be useful to y'all.

simonv3 commented 7 years ago

Thanks a bunch for tracking this and moving forward with it @waldoj!