We are interested in the weather data published by NOAA via Data.gov The site offers the 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?

  • 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.
    – user3856
    Jun 25 '18 at 17:16
  • @BarryCarter I was trying to avoid having to write code and create this DB myself.
    – rams
    Jun 27 '18 at 12:36
  • 1
    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).
    – user3856
    Jun 27 '18 at 16:40
  • 1
    My github.com/barrycarter/bcapps/blob/master/WEATHER/… may or may not be helpful, but it's GHCND data, not ISD.
    – user3856
    Jul 2 '18 at 16:38
  • cloud.google.com/bigquery/public-data/noaa-gsod may be helpful-- it appears Google BigQuery is really into taking public data sets and converting them to SQL. It also appears one of their sample queries, cloud.google.com/bigquery/public-data/… claims it was nearly 130F in Alaska in 2015.
    – user3856
    Jul 13 '18 at 1:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.