NC2TABLE: Difference between revisions
From BAWiki
imported>Lang Guenther (introductory text added) |
m (update version) |
||
| (9 intermediate revisions by 3 users not shown) | |||
| Line 2: | Line 2: | ||
|name_de=NC2TABLE | |name_de=NC2TABLE | ||
|name=NC2TABLE | |name=NC2TABLE | ||
|version= | |version=May 2024 | ||
|version_descr= | |version_descr=September 2022 | ||
|catchwords= | |catchwords= | ||
data conversion<br /> | data conversion<br /> | ||
| Line 12: | Line 12: | ||
tabular data<br /> | tabular data<br /> | ||
support of DMQS metadata and variables<br /> | support of DMQS metadata and variables<br /> | ||
automatic adjustment of number of data READ to chunk size of input data | |||
Acknowledgment: ''This project took advantage of netCDF software developed by UCAR/Unidata ([http://www.unidata.ucar.edu/software/netcdf/ www.unidata.ucar.edu/software/netcdf/]).'' | Acknowledgment: ''This project took advantage of netCDF software developed by UCAR/Unidata ([http://www.unidata.ucar.edu/software/netcdf/ www.unidata.ucar.edu/software/netcdf/]).'' | ||
| Line 42: | Line 43: | ||
# '''Table Type 2''' (comparison of functions): The dependence of several functions '''f_i''', with '''i=1,n_i''', in dependence on a single coordinate can be displayed. All other coordinate values remain frozen in. Example: time series of water level, current velocity and salinity for a specific location. | # '''Table Type 2''' (comparison of functions): The dependence of several functions '''f_i''', with '''i=1,n_i''', in dependence on a single coordinate can be displayed. All other coordinate values remain frozen in. Example: time series of water level, current velocity and salinity for a specific location. | ||
Program NC2TABLE supports both above mentioned types of tables. | Program NC2TABLE supports both above mentioned types of tables. For date and time data items the time zone used can be | ||
selected via file [[NC2TABLE.DAT|nc2table.dat]]. | |||
|inputfiles= | |inputfiles= | ||
| Line 60: | Line 61: | ||
Just in case '''HDF error''' is detected during read of a data record, the program tries to reconstruct the wanted data set from adjacent (in time) records for the same variable. This type of repair works for time dependent variables only. | Just in case '''HDF error''' is detected during read of a data record, the program tries to reconstruct the wanted data set from adjacent (in time) records for the same variable. This type of repair works for time dependent variables only. | ||
|preprocessor=[[DATACONVERT]], [[GRIDCONVERT]], [[NCAGGREGATE]], [[NCANALYSE]], [[NCDELTA]], [[UNTRIM2007]], [[UNTRIM2]] | |preprocessor=[[DATACONVERT]], [[GRIDCONVERT]], [[NCAGGREGATE]], [[NCANALYSE]], [[NCCHUNKIE]], [[NCCUTOUT]], [[NCDELTA]], [[NCDVAR]], [[NCMERGE]], [[UNTRIM2007]], [[UNTRIM2]] | ||
|postprocessor=spread sheet program, text editor | |postprocessor=spread sheet program, text editor | ||
|language=Fortran95 | |language=Fortran95 | ||
|add_software=--- | |add_software=--- | ||
|contact_original= | |contact_original=G. Lang | ||
|contact_maintenance=[mailto: | |contact_maintenance=[mailto:pos.proghome@baw.de Working group POS] | ||
|documentation= | |documentation= | ||
template files available in '''$PROGHOME/examples/nc2table''' | template files available in '''$PROGHOME/examples/nc2table''' | ||
}} | }} | ||
Latest revision as of 14:13, 21 May 2024
Basic Information
Name of Program
NC2TABLE
Version-Date
May 2024
Description-Date
September 2022
Catchwords
data conversion
postprocessor
synoptic data sets
CF NetCDF format
CSV format (comma separated values)
tabular data
support of DMQS metadata and variables
automatic adjustment of number of data READ to chunk size of input data
Acknowledgment: This project took advantage of netCDF software developed by UCAR/Unidata (www.unidata.ucar.edu/software/netcdf/).
Short Description of Functionality
Program NC2TABLE allows selective data extraction from CF NetCDF files to CSV files. Extracted data ares stored in tabular form and may be subsequently used in spread sheet programs like MS EXCEL.
General Introduction
Geophysical variables f_i stored in (netCDF) data files are typically dependent on different numbers of coordinates. According to the CF metadata standard, time and date as well as geographical location are the required minimum.
General form of a variable (function):
f = f_i(t,x[,z][,l][,c])
In the above definition, t means time, x stands for the (horizontal) location, z is either height or depth, l symbolizes a label (e. g. a sediment fraction) and c is typically representing (other) classes, e. g. for a probability distribution.
Expressions function and variable are synonymously used in the following.
Structure of Tables
Tables consist out of rows and columns. Tables are best suited for the following data presentations:
- Table Type 1 (functional profile): The dependence of f_i on two different coordinates is displayed. The values of (optionally) present other coordinates are frozen in. Example: water level in dependence on (discrete) space x_m and (discrete) time t_n.
- Typical combinations for axes are:
- Time series (Ts): f(t,x) Ts for several locations, f(t,z) Ts for several vertical layers, f(t,l) Ts for multiple sediment fractions and f(t,c) Ts for various classes (probability distribution) or frequencies (spectrum).
- Dependence on horizontal position: f(x,z) variation over height or depth, f(x,l) variation over sediment fractions and f(x,c) variation over classes (probability distribution) or frequencies (spectrum).
- Dependence on vertical position: f(z,l) variation over sediment fractions and f(z,c) variation over classes (probability distribution) or frequencies (spectrum).
- Other: f(l,c) probability distribution for various sediment fractions.
- Typical combinations for axes are:
- Table Type 2 (comparison of functions): The dependence of several functions f_i, with i=1,n_i, in dependence on a single coordinate can be displayed. All other coordinate values remain frozen in. Example: time series of water level, current velocity and salinity for a specific location.
Program NC2TABLE supports both above mentioned types of tables. For date and time data items the time zone used can be selected via file nc2table.dat.
Input-Files
- general input data (file type nc2table.dat);
- geophysical data (file type cf-netcdf.nc).
Output-Files
- ASCII tables (file type nc2table.csv) in CSV file format;
- Metadata (filetype nc2table.txt) in readable form (text file);
- (optional) informative printer file of program execution (file type nc2table.sdr)
- (optional) trace of program execution (file type nc2table.trc)
Methodology
Binary data are extracted an printed in tabular form according to the user requirements.
Just in case HDF error is detected during read of a data record, the program tries to reconstruct the wanted data set from adjacent (in time) records for the same variable. This type of repair works for time dependent variables only.
Program(s) to run before this Program
DATACONVERT, GRIDCONVERT, NCAGGREGATE, NCANALYSE, NCCHUNKIE, NCCUTOUT, NCDELTA, NCDVAR, NCMERGE, UNTRIM2007, UNTRIM2
Program(s) to run after this Program
spread sheet program, text editor
Additional Information
Language
Fortran95
Additional software
---
Original Version
G. Lang
Maintenance
Documentation/Literature
template files available in $PROGHOME/examples/nc2table
back to Program Descriptions