We are interested in the weather data published by NOAA via Data.gov The site offers ability to download data as PDF or CSV files. Has anyone created a real RDBMS (MySQL, SQLite) database out of the data? Is that available as an open source resource?

Thanks in Advance.

  • If you're referring to the ISD data (ncdc.noaa.gov/isd), it wouldn't be hard to create such a db, but it would be very large, I've gotten SQLite to handle 6M rows in geonames (geonames.db.94y.info), but I think ISD would be too much. I'd offer to create a db for you, but, if you already have the data, it's a lot more efficient to do it yourself. – Barry Carter 2 days ago
  • @BarryCarter I was trying to avoid having to write code and create this DB myself. – rams 12 hours ago
  • fair enough, but since the data is already in machine-readable form, and is really large, I don't see anyone releasing an SQL version of it (CSV is sort of the default way of releasing things). – Barry Carter 8 hours ago

Your Answer

 
discard

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.