Re: ASCII TO NETCDF CONVERSION

[1]
NCL does not support (understand) Excel files.

[2]
Perhaps there are tools you can use ... search the WWW.

[3]
Given the structure of your file:

" ... containing temperature and salinity data of all stations
   not like a one after another datafile file."

and your sequence of questions ....

> 1. How can I create netcdf for this type of file whether its
> possible to create netcdf file of 4 dimension
> 2. How to fill the missing value
> 3. How to make grid for this type of data
> 4. How station 2 data can be accessed and filled in grid.
> 5. How to calculate julian day here..

*You* will need to do programming to split each file by ID
and possibly merge multiple files.

Regridding ??? Think about the distribution of the original data
points and the desired characteristics of the gridded data.

Did you try to do any programming? Are you requesting ncl-talk to
do it for you? If so, that is a bit much! I have attached a script
that will give you a start.

Somehow, you will have to convert the Excel file(s) to ascii.
I copied and pasted to create "AkshayHegde.txt_excel".
If you have thousands of files, this is not an acceptable strategy.
I have never used Excel so do not send me or ncl-talk any
questions about this conversion.

=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+
*I will answer no more questions on this thread.*
  I do not have the time!*
=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+

netcdf AkshayHegde {
dimensions:
         id = 3 ;
         depth = 21 ;
         nchar = 2 ;
variables:
         int INODC_ST_N(id) ;
                 INODC_ST_N:long_name = "??????" ;
         int ORG_CR_NO(id) ;
                 ORG_CR_NO:long_name = "??????" ;
         int ORG_ST_NO(id) ;
                 ORG_ST_NO:long_name = "??????" ;
         double TIME(id) ;
                 TIME:calendar = "standard" ;
                 TIME:units = "hours since 1980-1-1 00:00:0.0" ;
         int DATE(id) ;
                 DATE:units = "yyyymmdd" ;
                 DATE:long_name = "current Gregorian Date" ;
         int DATESEC(id) ;
                 DATESEC:units = "seconds" ;
                 DATESEC:long_name = "current seconds of current DATE" ;
         int YYYYDDD(id) ;
                 YYYYDDD:units = "yyyyddd" ;
                 YYYYDDD:long_name = "year and day of current year (ddd
is julian)" ;
         double JULDAY(id) ;
                 JULDAY:units = "days since January 1, 4713 B.C." ;
                 JULDAY:long_name = "Julian day" ;
         int depth(depth) ;
                 depth:positive = "down" ;
                 depth:units = "m" ;
                 depth:long_name = "depth" ;
         float LAT(id) ;
                 LAT:units = "degrees_north" ;
                 LAT:long_name = "latitude" ;
         float LON(id) ;
                 LON:units = "degrees_east" ;
                 LON:long_name = "longitude" ;
         char EEZ(id, nchar) ;
                 EEZ:units = "???" ;
                 EEZ:long_name = "???" ;
         float TEMP(id, depth) ;
                 TEMP:units = "degC" ;
                 TEMP:long_name = "temperature" ;
                 TEMP:_FillValue = -9999.f ;
         float SAL(id, depth) ;
                 SAL:units = "psu" ;
                 SAL:long_name = "salinity" ;
                 SAL:_FillValue = -9999.f ;
}

On 11/21/12 9:09 PM, Akshay Hegde wrote:
>
>
> ---------- Forwarded message ----------
> From: *Akshay Hegde* <akshay.k.hegde@gmail.com
> <mailto:akshay.k.hegde@gmail.com>>
> Date: Tue, Nov 20, 2012 at 6:13 PM
> Subject: ASCII TO NETCDF CONVERSION
> To: ncl-install-owner@ucar.edu <mailto:ncl-install-owner@ucar.edu>
>
>
>
>
> Dear Sir,
>
> Kindly observe the data file properly, here latitude, longitude, date
> and time are changing after some station number, please do one simple
> program for me. I still have confusion about ascii to netcdf, I didn't
> understand it, here program has to read a file which is containing
> temperature and salinity data of all stations not like a one after
> another datafile file.
>
> Kindly help, in our database we have huge number of files of same
> format, we would like convert them to netcdf format so that whenever
> data request comes to us, we would like to provide in netcdf format.
>
> I have a requirement of netcdf file in following way
>
> suppose say I use FERRET program it should display in following way
> with some global attributes defining name of the institution
>
> show data
>
> M N i j
> k l
>
> temp Temperature 1 : xyz 1 : xyz 1:xyz 1:xyz
>
>
>
>
> 1. How can I create netcdf for this type of file whether its possible to
> create netcdf file of 4 dimension
> 2. How to fill the missing value
> 3. How to make grid for this type of data
> 4. How station 2 data can be accessed and filled in grid.
> 5. How to calculate julian day here..
>
>
>
> Kindly prepare one sample program for my data file and send me .
>
> Looking forward for your positive reply,
>
>
>
>
> With Best Regards,
>
> Akshay Hegde,
> Data and Information Center,
> National Institute of Oceanography,
> Dona Paula, Panjim,
> Goa - 403004, India
>
>
>
>
>
>
>
>

_______________________________________________
ncl-talk mailing list
List instructions, subscriber options, unsubscribe:
http://mailman.ucar.edu/mailman/listinfo/ncl-talk