####################### 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 (Int. 1-9999), 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 LATITUDE_DEG Integer decimal degrees of hole latitude Latitude (deg.) latitude (deg): integer between 0 and 90 between 0 and 90 deg 5 LATITUDE_MIN Double decimal minutes of hole latitude ) Latitude (min.) latitude (min): numeric value # dec 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 between 0 and 180 deg. 8 LONGITUDE_MIN Double decimal minutes of hole longitude Longitude (min.) longitude (min) of hole: numeric value # dec min. 9 LONGITUDE_DIR Text direction site longitude Direction # # # 10 LONGITUDE_DEC Double decimal longitude of site (hole 'A') Longitude (dec.) site longitude (dec): numeric value # dec deg. 11 LATITUDE_DEC Double decimal latitude of site (hole 'A') Latitude (dec.) site latitude (dec):numeric value # dec deg. 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 GEAR Text gear of hole Gear gear used for hole ('drill' is default) # # 15 ELEVATION Double elevation of hole Elevation (m) elevation of hole (m): numeric value # m 16 REMARKS Text remarks on activity Remarks # # # 17 PLANNED_LENGTH Double planned length Planned Length # # m 18 IGSN Text IGSN IGSN # # # ####################### Data Part ############################# EXPEDITION SITE HOLE LATITUDE_DEG LATITUDE_MIN LATITUDE_DIR LONGITUDE_DEG LONGITUDE_MIN LONGITUDE_DIR LONGITUDE_DEC LATITUDE_DEC START_DATE END_DATE GEAR ELEVATION REMARKS PLANNED_LENGTH IGSN 5029 4 A 63 49.652 N 22 40.683 W -22.678 63.828 31-Jul-2016 00:00 22-Sep-2016 00:00 rig 10 5029_4_A-RN-15 -deepening RN-15 down to 5000m with spot coring of ca. 200m ICDP5029EEI2001 5029 4 B 63 49.620 N 22 40.683 W -22.678 63.827 22-Sep-2016 00:00 rig 10 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EE63001