####################### 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, 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" # 4 LATITUDE_DEG Integer decimal degrees of hole latitude Latitude (deg.) latitude (deg) integer between 0 and 90 deg 5 LATITUDE_MIN Double decimal minutes of hole latitude ) Latitude (min.) latitude (min) numeric value min. 6 LATITUDE_DIR Text direction latitude Direction # # 7 LONGITUDE_DEG Integer decimal degrees of hole longitude ( longitude of hole A) Longitude (deg.) longitude (deg) of hole integer between 0 and 180 deg. 8 LONGITUDE_MIN Double decimal minutes of hole longitude Longitude (min.) longitude (min) of hole numeric value min. 9 LONGITUDE_DIR Text direction site longitude Direction # m 10 LONGITUDE_DEC Double decimal longitude of site (hole 'A') Longitude (dec.) site longitude (dec) numeric value min. 11 LATITUDE_DEC Double decimal latitude of site (hole 'A') Latitude (dec.) site latitude (dec) numeric value min. 12 START_DATE Date date hole was started Start Date "start date (date in UTC), required field" # 13 END_DATE Date date hole ended End Date date in UTC # 14 WATER_DEPTH Double depth of water at hole Water Depth "water depth (float, not 0), required field, m below sealevel" m 15 WD_METHOD Text description of water depth measurement Method "water depth method, required field" # 16 GEAR Text gear of hole Gear gear used for hole ('drill' is default) min. 17 ELEVATION Double elevation of hole Elevation (m) elevation of hole (m) numeric value min. 18 REMARKS Text remarks on activity Remarks # # 19 ELEVATION_2 Double elevation of hole Elevation (m) elevation of hole (m) numeric value min. 20 PLANNED_LENGTH Double planned length Planned Length # m 21 DIRECTION Double direction Direction # degrees 22 INCLINATION Double inclination Dip # degrees 23 DRILLING_DEPTH_DRF Text method used for drilling depth below rig floor (DRF) Depth Method (BRF) # # 24 DRILLING_DEPTH_DSF Text method used for drilling depth below sea floor (DSF) Depth Method (BSF) # # 25 CORE_DEPTH_CSF Text method used for core depth (CSF) Core Depth Method (CSF) # # 26 CORE_DEPTH_CCSF Text method used for core composite depth (CCSF) Core Depth Method (CCSF) # # 27 IGSN Text IGSN IGSN # # ####################### Data Part ############################# EXPEDITION SITE HOLE START_DATE END_DATE WATER_DEPTH WD_METHOD REMARKS LATITUDE_DEG LATITUDE_MIN LATITUDE_DIR LONGITUDE_DEG LONGITUDE_MIN LONGITUDE_DIR LATITUDE_DEC LONGITUDE_DEC GEAR ELEVATION ELEVATION_2 PLANNED_LENGTH DIRECTION INCLINATION DRILLING_DEPTH_DRF DRILLING_DEPTH_DSF CORE_DEPTH_CSF CORE_DEPTH_CCSF IGSN 5056 1 A 30-Jul-2015 02-Aug-2015 0 undefined PLJ-JUN15-1A 11 2.19 S 76 6.624 W -11.037 -76.11 hydraulic piston coring 4099 ICDP5056EH23001 5056 1 B 03-Aug-2015 03-Aug-2015 8.24 undefined PLJ-JUN15-1B 11 2.157 S 76 6.646 W -11.036 -76.111 hydraulic piston coring 4099 ICDP5056EH33001 5056 1 C 03-Aug-2015 05-Aug-2015 0 undefined PLJ-JUN15-1C 11 2.104 S 76 6.648 W -11.035 -76.111 hydraulic piston coring 4099 ICDP5056EH43001 5056 1 D 05-Aug-2015 07-Aug-2015 0 undefined PLJ-JUN15-1D 11 2.142 S 76 6.65 W -11.036 -76.111 hydraulic piston coring 4099 ICDP5056EH53001 5056 1 E 08-Aug-2015 11-Aug-2015 0 undefined PLJ-JUN15-1E 11 2.142 S 76 6.65 W -11.036 -76.111 hydraulic piston coring 4099 ICDP5056EH63001 5056 1 P 30-Jul-2015 11-Aug-2015 0 undefined PLJ-JUN15-1P composite 11 2.142 S 76 6.65 W -11.036 -76.111 hydraulic piston coring 4099 ICDP5056EH73001 5056 2 A 11-Aug-2015 11-Aug-2015 3.9 undefined PLJ-JUN15-2A 11 0.259 S 76 4.163 W -11.004 -76.069 hydraulic piston coring 4099 ICDP5056EH83001 5056 2 B 11-Aug-2015 12-Aug-2015 3.9 undefined PLJ-JUN15-2B 11 0.259 S 76 4.163 W -11.004 -76.069 hydraulic piston coring 4099 ICDP5056EH93001 5056 2 C 12-Aug-2015 13-Aug-2015 3.9 undefined PLJ-JUN15-2C 11 0.259 S 76 4.163 W -11.004 -76.069 hydraulic piston coring 4099 ICDP5056EHA3001 5056 3 A 13-Aug-2015 13-Aug-2015 0 undefined PLJ-JUN15-3A 11 2.636 S 76 3.547 W -11.044 -76.059 hydraulic piston coring 4099 ICDP5056EHB3001 5056 3 B 13-Aug-2015 14-Aug-2015 0 undefined PLJ-JUN15-3B 11 2.585 S 76 3.115 W -11.043 -76.052 hydraulic piston coring 4099 ICDP5056EHC3001 5056 3 C 14-Aug-2015 14-Aug-2015 0 undefined PLJ-JUN15-3C 11 2.585 S 76 3.115 W -11.043 -76.052 hydraulic piston coring 4099 ICDP5056EHD3001 5056 3 P 13-Aug-2015 14-Aug-2015 0 undefined PLJ-JUN15-3P composite 11 2.585 S 76 3.115 W -11.043 -76.052 hydraulic piston coring 4099 ICDP5056EHE3001