Re: [thredds] Dumping 1D data THREDDS data as tabular output?

ERDDAP - http://coastwatch.pfeg.noaa.gov/erddap. it can create a csv file, but even more, you can just paste the URL into the "Open File" dialog box in Excel, and it will read the data into Excel. I can send you a movie showing that.

-Roy

On Jun 10, 2008, at 8:53 AM, Rich Signell wrote:

THREDDS Community,

We have a lot of CF-compliant 1D time series data, and people often
ask us how to get the data into Excel.

It would be nice to have a client that could create tabular output in
ASCII form (e.g. CSV file) if the data were 1D or effectively 1D (2D,
3D or 4D, but with only one non-singleton dimension).

We want a table with time in column 1,  temp in column 2, salinity in
column 3, etc.   This could also be used for profile data, where you
would have depth or pressure in the first column, followed by the
dependent variables.

We explored various clients: NcBrowse, the OpenDAP Data Connector,
IDV, the new Environmental Data Connector, the THREDDS WCS and NetCDF
subsetter services, and none of them seemed to have the ability to do
this.

Does anyone have any ideas?

A sample of our CF compliant time series file in THREDDS is at:
http://coast-enviro.er.usgs.gov/thredds/tseries_catalog.html? dataset=DATAFILES/MYRTLEBEACH/7222sc-a.nc

Thanks,
Rich
--
Dr. Richard P. Signell (508) 457-2229
USGS, 384 Woods Hole Rd.
Woods Hole, MA 02543-1598
_______________________________________________
thredds mailing list
thredds@xxxxxxxxxxxxxxxx
For list information or to unsubscribe, visit: http:// www.unidata.ucar.edu/mailing_lists/

**********************
"The contents of this message do not reflect any position of the U.S. Government or NOAA."
**********************
Roy Mendelssohn
Supervisory Operations Research Analyst
NOAA/NMFS
Environmental Research Division
Southwest Fisheries Science Center
1352 Lighthouse Avenue
Pacific Grove, CA 93950-2097

e-mail: Roy.Mendelssohn@xxxxxxxx (Note new e-mail address)
voice: (831)-648-9029
fax: (831)-648-8440
www: http://www.pfeg.noaa.gov/

"Old age and treachery will overcome youth and skill."
"From those who have been given much, much will be expected"




  • 2008 messages navigation, sorted by:
    1. Thread
    2. Subject
    3. Author
    4. Date
    5. ↑ Table Of Contents
  • Search the thredds archives: