ODV Spreadsheet Format
| Cruise | Station | Type | mon/day/yr | hh:mm | Lon (°E) | Lat (°N) | Bot. Depth [m] | InstType | QF | Depth [m] | QF | Temperature [°C] | QF | Salinity [PSU] | QF |
| JCOD___199501 | 001 | B | 07/16/1995 | 09:00 | 134.6000 | 30.0000 | 0 | SD | 0 | 0.0 | 0 | 28.400 | 0 | 34.418 | 0 |
| JCOD___199501 | 001 | B | 07/16/1995 | 09:00 | 134.6000 | 30.0000 | 0 | SD | 0 | 51.0 | 0 | 21.101 | 0 | 34.849 | 0 |
| JCOD___199501 | 001 | B | 07/16/1995 | 09:00 | 134.6000 | 30.0000 | 0 | SD | 0 | 101.0 | 0 | 19.863 | 0 | 34.904 | 0 |
| JCOD___199501 | 002 | B | 07/16/1995 | 17:48 | 133.6717 | 29.0033 | 0 | SD | 0 | 0.0 | 0 | 28.100 | 0 | 34.364 | 0 |
| JCOD___199501 | 002 | B | 07/16/1995 | 17:48 | 133.6717 | 29.0033 | 0 | SD | 0 | 29.0 | 0 | 24.610 | 0 | 34.306 | 0 |
| JCOD___199502 | 001 | B | 07/31/1995 | 15:42 | 133.6633 | 21.0000 | 0 | SD | 0 | 0.0 | 0 | 29.200 | 0 | 34.849 | 0 |
| JCOD___199502 | 001 | B | 07/31/1995 | 15:42 | 133.6633 | 21.0000 | 0 | SD | 0 | 101.0 | 0 | 25.504 | 0 | 34.945 | 0 |
- General
- file extension
- Column separation character
- First line: Column Labels
- Standard header labels are : Cruise, Station, Type, mon/day/yr, hh:mm,
Lon(E), Lat(N), Bot. Depth[m]
- Each column for a data variable has an optional quality-flag QF
- The instrument code is attached to 'Data Type'.
- 2nd unit last line: Data Lines
- Each line contains metadata and data for one observed level.
- The cruises are arranged for each vessel and each observation period
of extracted data. The cruise number is attached for each cruise.
- The Station Type is a siｎgle charaｃter string. It is B for stations
of about 250 levels or less and C for stations of 250 or more.
- If Bot. Depth is not available, use 0 (zero) in this field.
- Quality flag columns
- Quality flags are single digit integers : 0 = good, 1 = unknown,
4 = questionable, 8 = bad.
- Error flag for observation
information in FETI format are translated into Quality flag for Data
Type in ODV spreadsheet as follows.
| FETI | 0 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| ODV | 0 | 0 | 0 | 0 | 4 | 4 | 8 | 8 | 8 |
- Data precision flag in
FETI format are translated into Quality flag or data in ODV spreadsheet as follows.
Notices and problems
- JODC provides observation data together with some metadata, e.g. data originators,
research vessels, etc. in JODC standard format (FETI format), but such metadata are
omitted from ODV spreadsheet. We recommend that you will download JODC standard format
data as well.
- As a general rule, units of variables used in JODC standard format are the same as
those used by data originators. However, in ODV spreadsheet, unit of each variable is
unified so that data can be used as they are. In addition, pressure 'dbar' is converted
depth 'm' by the simple formula according to 'Unesco Technical Papers in Marine Science
44 (1983)'.
- The extracted data arranged by each vessel and each observation period. Then,
the cruise number is attached to the serial data of each vessel. If the interval of
observation of a vessel is 5 days or more, each observation is considered to take
part in the respective cruise. The station numbers are also attached for convenience.
Therefore, the data of one cruise may be divided into one or more cruises, and sometimes
it may be the other way around.
![[Home]](/jodc-image/home.gif)
For any questions and comments, please contact us to the mail address to
jodc@jodc.gp.jp
Updated : September 10, 2003