title: Extract data from grib weather model
body: <p>I have downloaded <code>grib1</code> model data from <a href="http://en.wikipedia.org/wiki/Global_Forecast_System" rel="nofollow">GFS</a>, I am using a Mac OS X and was able to build the <code>wgrib2</code> file from <a href="http://en.wikipedia.org/wiki/National_Oceanic_and_Atmospheric_Administration" rel="nofollow">NOAA</a> but was unable to extract the data. I have not found a <code>grib1</code> utility for MAC.</p>
  
  <p>Then I run to this program <a href="http://www.giss.nasa.gov/tools/panoply/" rel="nofollow">http://www.giss.nasa.gov/tools/panoply/</a> that was able to read the file and can see the data but I have some issues with it.</p>
  
  <ol>
  <li>the values comes in other units  (like K for temp and other different from mm in rainfall)</li>
  <li>I am able to export <code>CSV</code> but only the values not the coordinates</li>
  </ol>
  
  <p>What I want to do is :</p>
  
  <ol>
  <li>extract data from <a href="http://en.wikipedia.org/wiki/GRIB" rel="nofollow">grib</a> file via the command line via latitude longitude </li>
  <li>extract data an move to a <code>MySQL</code> database to be able to do some data aggregation (sum, max, min) etc</li>
  <li>be able to plot / map data (I would probably use <a href="http://en.wikipedia.org/wiki/CartoDB" rel="nofollow">CartoDB</a> service) </li>
  </ol>
  
  <p>I already can extract <code>grib</code> or can download from certain region, I would like that data to be able to see on a spreadsheet for example latitude, longitude, temperature, rainfall, wind etc... then from there I can take it to a database, or sum /avg etc or manipulate data.</p>
  
  <p>Sample <code>grib</code> data file: <a href="https://dl.dropboxusercontent.com/u/104462/neavilag_rain_wind_pressure.grb" rel="nofollow">https://dl.dropboxusercontent.com/u/104462/neavilag_rain_wind_pressure.grb</a></p>
  
  <p>Based on my scenario what is the best approach to handle my needs? Can you suggest me what to do?</p>