####################### Meta Data Part ############################# Column Name Data Type Description Label Validation Text Unit 1 EXPEDITION Numeric expedition number Expedition Number "expedition code (Int. 1-9999), required key field <>0" # 2 SITE Numeric "site number, integer" Site Number "site code (max. 5 chars, f.e. M0001), required key field <>0" # 3 HOLE Text "code for hole, one character (A_Z)" Hole "hole code (max. 1 chars, A-Z), required key field LIKE ( '[A-Z]')" # 4 LONGITUDE_DEC Double decimal longitude of site (hole 'A') Longitude (dec.) site longitude (dec) deg. 5 LATITUDE_DEC Double decimal latitude of site (hole 'A') Latitude (dec.) site latitude (dec) deg. 6 START_DATE Date date hole was started Start Date "start date (local date), required field" dd-mmm-yyyy 7 END_DATE Date date hole ended End Date "end date (local date), required field" dd-mmm-yyyy 8 WATER_DEPTH Double depth of water at hole Water Depth "water depth (float, not 0), required field, m below sealevel <>0" m 9 WD_METHOD Text description of water depth measurement Method "water depth method, required field <>''" # 10 GEAR Text gear of hole Gear gear used for hole ('drill' is default) # 11 ELEVATION Double elevation of hole Elevation (m) elevation of hole (m) m 12 REMARKS Text remarks on activity Remarks # # 13 ELEVATION_2 Double elevation of hole Elevation (m) elevation of hole (m) m 14 IGSN Text IGSN IGSN # # ####################### Data Part ############################# EXPEDITION SITE HOLE LONGITUDE_DEC LATITUDE_DEC START_DATE END_DATE WATER_DEPTH WD_METHOD GEAR ELEVATION REMARKS ELEVATION_2 IGSN 5061 1 A 37.70403 -3.31675 07-Nov-2016 10-Nov-2016 87.65 undefined 878 DCH-1A 878 ICDP5061EH33001 5061 1 B 37.70403 -3.31676 10-Nov-2016 11-Nov-2016 87.65 undefined 878 DCH-1B 878 ICDP5061EH43001 5061 1 C 37.70397 -3.31673 14-Nov-2016 14-Nov-2016 87.65 undefined 878 DCH-1C 878 ICDP5061EH53001 5061 1 D 37.70387 -3.3168 16-Nov-2016 17-Nov-2016 87.65 undefined 878 DCH-1D 878 ICDP5061EH63001 5061 1 E 37.70397 -3.31674 18-Nov-2016 19-Nov-2016 87.65 undefined 878 DCH-1E 878 ICDP5061EH73001 5061 1 Z 37.70395 -3.31673 06-Nov-2016 06-Nov-2016 87.65 undefined 878 DCH-1Z 878 ICDP5061EH83001