Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have downloaded "High Resolution Initial Conditions" climate forecast data for one day. The file had an .tar.gz extension so I extracted it in my local directory and I get the files listed here:

screenshot of my file list

I think the files without any extension are GRIB data, because the first word in them is "GRIB". I want to import the data from the big files (GRIB and NetCDF formats containing climate data like temperature & pressure in grid) into my database, but they are binary.

Can you recommend some easy way for importing the data from these files? I can't get any information about handling their datasets on their website.

Converting these files to .csv format would be nice, however I can't find any working program to convert the GRIB files.

share|improve this question

closed as off topic by jcolebrand Sep 7 '12 at 19:37

Questions on Database Administrators Stack Exchange are expected to relate to database administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

You could get the documentation for the file format and write something to do the conversion. It's probably not that hard. – ConcernedOfTunbridgeWells May 29 '12 at 12:47
Closing this question as it has had no volume, no interest, no followups and the question is already too narrow in scope. If the question were how to efficiently use SQL (or some vendor language) to move the data into tables, maybe. This is just flat out OT, however. – jcolebrand Sep 7 '12 at 19:38

Browse other questions tagged or ask your own question.