####################### Meta Data Part ############################# Column Name Data Type Description Label Validation Text Unit 1 EXPEDITION Numeric expedition number expedition number (Int. 1 - 99999), required key field <>0 # 2 SITE Numeric site number, site number (Int. 1 - 99999), required key field <>0 # 3 NAME Text site name or locality, max. 40 chars # # # 4 PLATFORM Text platform identifier, C=Chikyu, J=Joides,M=Mission Specific platform identifier, required field, C=Chikyu, J=Joides,M=Mission Specific # # 5 LATITUDE_DEG Integer decimal degrees of site latitude ( latitude of hole A) latitude (deg): integer between 0 and 90 # degrees 6 LATITUDE_MIN Double decimal minutes of site latitude ( latitude of hole A) latitude (min): numeric value # minutes 7 LATITUDE_DIR Text direction latitude # # # 8 LONGITUDE_DEG Integer decimal degrees of site longitude ( longitude of hole A) site longitude (deg): integer between 0 and 180 # degrees 9 LONGITUDE_MIN Double decimal minutes of site longitude site longitude (min): numeric value # minutes 10 LONGITUDE_DIR Text direction site longitude # # m 11 DATE_END Date date of station end date in UTC # dd-mmm-yyyy 12 DATE_START Date date of station start date in UTC # dd-mmm-yyyy 13 WATER_DEPTH Double water depth water depth (float), m below sealevel # m 14 WD_METHOD Text method of water depth measurement water depth method # # 15 REMARKS Text remarks on station # # # 16 LONGITUDE_DEC Double decimal longitude of site (hole 'A') site longitude (dec): numeric value # degrees 17 LATITUDE_DEC Double decimal latitude of site (hole 'A') site latitude (dec): numeric value # degrees 18 ELEVATION Double elevation of site elevation of site (m): numeric value # masl 19 ELEVATION_2 Double alternate / second elevation of site second elevation of site (m): numeric value # masl ####################### Data Part ############################# EXPEDITION SITE NAME PLATFORM LATITUDE_DEG LATITUDE_MIN LATITUDE_DIR LONGITUDE_DEG LONGITUDE_MIN LONGITUDE_DIR DATE_END DATE_START WATER_DEPTH WD_METHOD REMARKS LONGITUDE_DEC LATITUDE_DEC ELEVATION ELEVATION_2 5052 1 Gaunt Creek R 43 18.964 S 170 19.530 E 06-Feb-2011 00:00 18-Jan-2011 00:00 0 undefined DFDP-1 Datums are hacksaw marks on the sides of boreholes 170.326 -43.316 185 5052 2 Whataroa River, S New Zealand, W Coast R 43 17.439 S 170 24.397 E 18-Dec-2014 00:00 01-Oct-2014 00:00 0 undefined DFDP-2 170.407 -43.291 93.690