SESAME IP
Skip Navigation Links
ODV data exchange format
The ODV generic spreadsheet format is the preferred exchange format for import of data into ODV collections and for data export from ODV collections. It allows for automatic data exchange and requires no user interaction.

In the framework of the SESAME project , the ODV format has been adopted for data exchange with additional requirements:
  • The first three lines in the file must be commented and contain the SESAME relevant meta data in the following format:
    1. Provider: Provider Name equals to entryterm field in SESAME data provider list
    2. SESAME data policy: Data availability equals to entryterm field in SESAME data policy
    3. SESAME package: Data responsible work package equals to entryterm field in SESAME package
  • The first non commented line must contain the following metadata header labels exactly as given below, followed by originator parameter names.
    1. Cruise: Cruise name
    2. Station: Station name or ID
    3. Type: Data type. The type default value is '*'.
    4. yyyy-mm-ddThh:mm:ss.sss: Data and time in ISO-8601 Dates
    5. Longitude [degrees_east]: The format of the coordinate is given in decimal form with point separator,
    6. Latitude [degrees_north]: The format of the coordinate is given in decimal form with point separator,
    7. Bot. Depth [m]: Bottom depth. If Bot. Depth is not available, use “0” (zero) in this field
  • The second non commented line must start from"Parameter mapping according to the SESAME vocabulary =>" and contain the  list of parameters in the standard terms of SESAME vocabulary
Additional properties
  •  Column separation character must be TAB.
  •  File extension must be .txt
  •  Date and time format is yyyy-mm-dd hh:mm
  • Comment lines start with // and  may appear anywhere in the file.
Example
//Provider: Institute of Marine Sciences, Middle East Technical University
//SESAME data policy: Originator
//SESAME package: WP1
Cruise Station Type yyyy-mm-ddThh:mm:ss.sss Longitude [degrees_east] Latitude [degrees_north] Bot. Depth [m] "Sea Level, m" "Temp, °"
Parameter mapping according to SESAME vocabulary => SLEV TEMP
RMN    Messina    *    2006-02-15T00:00:00.000    15.56777778    38.18916667    0    0.22    14.2
RMN    Messina    *    2006-02-15T01:00:00.000    15.56777778    38.18916667    0    0.18    14.2
RMN    Messina    *    2006-02-15T02:00:00.000    15.56777778    38.18916667    0    0.15    14.2