Формат файла данных для ODV
|
ODV spreadsheet
|
Компьютерное приложение ODV (Ocean Data View) разработано в Германии (Alfred Wegener Institute) Райнером Шлицером. Для научных работников и студентов оно бесплатное. http://odv.awi-bremerhaven.de/
Приложение предназначено для исследования и визуализации океанографических данных. Таблица – один из форматов, поддерживаемых ODV.
Инструкция: http://odv.awi-bremerhaven.de/documentation.html
|
ODV (Ocean Data View) is developed by Alfred Wegener Institute in Germany. It is a free software package for the interactive exploration, analysis and visualization of oceanographic data. ODV spreadsheet is one of supported data formats of ODV software.
Link to ODV Home Page: http://odv.awi-bremerhaven.de/
ODV User's Guide: http://odv.awi-bremerhaven.de/documentation.html
|
Пример структуры таблицы данных
ODV Spreadsheet Format
Cruise
|
Station
|
Type
|
mon/day/yr
|
hh:mm
|
Lon (°E)
|
Lat (°N)
|
Bot. Depth [m]
|
Depth [m]
|
QF
|
Temperature [°C]
|
QF
|
Salinity [PSU]
|
QF
|
T.txt
|
41651
|
B
|
7/14/1967
|
00:00
|
119.817
|
17
|
0
|
0
|
1
|
29.2
|
1
|
|
|
T.txt
|
41651
|
B
|
7/14/1967
|
00:00
|
119.817
|
17
|
0
|
5
|
1
|
29.2
|
1
|
|
|
T.txt
|
41651
|
B
|
7/14/1967
|
00:00
|
119.817
|
17
|
0
|
10
|
1
|
29.2
|
1
|
|
|
T.txt
|
41651
|
B
|
7/14/1967
|
00:00
|
119.817
|
17
|
0
|
15
|
1
|
29.1
|
1
|
|
|
T.txt
|
41651
|
B
|
7/14/1967
|
00:00
|
119.817
|
17
|
0
|
20
|
1
|
29
|
1
|
|
|
T.txt
|
41651
|
B
|
7/14/1967
|
00:00
|
119.817
|
17
|
0
|
25
|
1
|
28.9
|
1
|
|
|
T.txt
|
41651
|
B
|
7/14/1967
|
00:00
|
119.817
|
17
|
0
|
30
|
1
|
28.9
|
1
|
|
|
T.txt
|
41651
|
B
|
7/14/1967
|
00:00
|
119.817
|
17
|
0
|
35
|
1
|
28.9
|
1
|
|
|
S.txt
|
3
|
B
|
6/3/1925
|
00:00
|
119.75
|
23.1667
|
0
|
0
|
1
|
|
|
33.12
|
1
|
S.txt
|
3
|
B
|
6/3/1925
|
00:00
|
119.75
|
23.1667
|
0
|
25
|
1
|
|
|
33.3
|
1
|
S.txt
|
3
|
B
|
6/3/1925
|
00:00
|
119.75
|
23.1667
|
0
|
50
|
1
|
|
|
33.77
|
1
|
S.txt
|
3
|
B
|
6/3/1925
|
00:00
|
119.75
|
23.1667
|
0
|
100
|
1
|
|
|
34.51
|
1
|
Кодировка ASCII
Расширение файла .txt
Разделитель столбцов TAB
Первая строка - заголовки столбцов, стандартная строка имеет вид: Cruise , Station , Type , mon/day/yr , hh:mm , Lon(E) , Lat(N) , Bot.Depth[m]. После каждой колонки с данными кроме того может стоять колонка с флагом качества данных QF.
Вторая и последующие строки – данные. Каждая строка содержит метаданные и данные для одного горизонта.
В данном случае в качестве Cruise используется имя файла, из которого были импортированы данные в коллекцию первоначально: T.txt- температура, S.txt- соленость. Поэтому в соответствующих блоках столбец с другими данными остается пустым. В других случаях это может быть название судна или месяц и др.
Тип станции маркируется B если станция имеет меньше 250 горизонтов и С – если больше. Отсутствующая глубина места обозначается 0.
Флаги качества:
0 – надежные данные, 1 - качество данных неизвестно, 4 – сомнительные данные, 8 - плохое качество данных.
|
General
ASCII coding
file extention
.txt
Column separation character
TAB
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 have an optional quality-flag QF
2nd unit last line : Data Lines
Each line contains metadata and data for one observed level.
The Cruise are arranged for each data block: T.txt- temperature only; S.txt- salinity only.
The Station Type is a single character string. It is B for stations with less than about 250 levels and C for stations with more than 250.
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.
|
Глава из руководства по ODV, посвященная табличным форматам
ODV Spreadsheet Files
ODV can read and import data from a variety of spreadsheet-type ASCII files. If the format of the import file is generic ODV spreadsheet format compliant, the data import will be fully automatic and no user interaction is required. Generic ODV spreadsheet files can be dropped on the ODV window or icon. Other spreadsheet data files can be read and imported as well, if they satisfy the general ODV spreadsheet format requirements. The import of general ODV spreadsheet files usually requires user interaction. ODV will prompt for information about the specific file format and will ask the user to identify specific meta-data and data columns.
ODV supports spreadsheet data files with or without station meta-data information and with or without column label information. ODV spreadsheet files may contain comments. The column separation character may be one of the following: TAB, semicolon (;), comma (,), SPACE, or slash (/). The missing data indicator value(s) may be a list of arbitrary numerical value(s) or a blank field. Multiple values must be separated by one or more spaces. Empty fields in the import file or fields that contain one of these values are considered missing values.
ODV generic and general spreadsheet files may contain many stations from many cruises. All samples of a given station must be in consecutive order but need not necessarily be sorted. When reading the file, ODV breaks the data into stations whenever one or more of the entries for Cruise, Station, and Type change from one line to the next. If Station is not provided in the data file, the date mon/day/yr and the Longitude [degrees_east] and Latitude [degrees_north] values are checked, and a station break occurs whenever one or more of these values change. The imported data from these files are added to the currently open data collections, or, if no collection is currently open, are used to create a new collection.
To import data from a generic ODV spreadsheet file into the currently open collection choose Import>ODV Spreadsheet and use the standard file-select dialog to identify the data file that you want to import. Specify import options and press OK to start the data import. Generic ODV spreadsheet files can also be dragged-and-dropped onto the ODV icon or an open ODV window.
If the file is not a generic ODV spreadsheet file, a Spreadsheet File Properties dialog box appears and lets you specify the column separation character and the missing data value(s) (multiple values must be separated by one or more spaces; fields that are empty or contain one of these values or are considered missing). You can also identify the line containing the column labels (leave empty if not present) and the first data line. ODV provides reasonable defaults for all items and only a few changes should be necessary in most cases. For the Column Sep. Character choose the character that will give a vertical list of labels in the Column Labels box. Press OK when all spreadsheet file properties are set, or press Cancel to abort the import.
If the labels for the metadata columns deviate from the specifications of the generic ODV spreadsheet format (see below), a Header Variable Association dialog box appears that lets you associate input columns with the collection metadata variables, or it lets you set defaults for those variables not provided in the input file. Already associated variables are marked by asterisks (*). To define a new association select items in the Source File and Target Collection lists and press Associate. To invoke a conversion during import press Convert and choose one of the available conversion algorithms. To delete an existing association, select the respective variables and press Undo. If the import file does not contain information for one or more collection header variables you can specify defaults: (1) select the respective target variable; (2) press Set Default and (3) enter the default value. Note that the specified default settings are used for all data lines in the file. Press OK when done or Cancel to abort the import procedure. Finally specify import options and press OK to start the data import.
Также с табличным форматом ODV можно ознакомиться по адресу http://jdoss1.jodc.go.jp/NEW_JDOSS_HP/format/feti_format/odv_data_structure_e.htm
(Format structure of ODV spreadsheet)
|
