####################### Meta Data Part ############################# Column Name Data Type Description Label Validation Text Unit 1 EXPEDITION Numeric expedition number expedition code (Int. 1-9999), required key field <>0 # 2 SITE Numeric site number, integer site code (max. 5 chars, f.e. M0001), required key field <>0 # 3 HOLE Text code for hole, one character (A_Z) hole code (max. 1 chars, A-Z), required key field # # 4 LATITUDE_DEG Integer decimal degrees of hole latitude latitude (deg): integer between 0 and 90 # degrees 5 LATITUDE_MIN Double decimal minutes of hole latitude ) latitude (min): numeric value # minutes 6 LATITUDE_DIR Text direction latitude # # # 7 LONGITUDE_DEG Integer decimal degrees of hole longitude ( longitude of hole A) longitude (deg) of hole: integer between 0 and 180 # degrees 8 LONGITUDE_MIN Double decimal minutes of hole longitude longitude (min) of hole: numeric value # minutes 9 LONGITUDE_DIR Text direction site longitude # # # 10 LONGITUDE_DEC Double decimal longitude of site (hole 'A') site longitude (dec): numeric value # degrees 11 LATITUDE_DEC Double decimal latitude of site (hole 'A') site latitude (dec): numeric value # degrees 12 START_DATE Date date hole was started start date (date in UTC), required field, valid date # dd-mmm-yyyy 13 END_DATE Date date hole ended date in UTC # dd-mmm-yyyy 14 GEAR Text gear of hole gear used for hole ('drill' is default) # # 15 ELEVATION Double elevation of hole elevation of hole (m): numeric value # masl 16 REMARKS Text remarks on activity # # # 17 ELEVATION_2 Double elevation of hole elevation of hole (m): numeric value # masl 18 IGSN Text 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 ELEVATION_2 IGSN 5052 1 A 43 18.964 S 170 19.530 E 170.325 -43.316 18-Jan-2011 00:00 24-Jan-2011 00:00 Rig 179.218 DFDP-1A - Waitangitaona River 179.203 ICDP5052EHZ1001 5052 1 B 43 18.961 S 170 19.604 E 170.327 -43.316 27-Jan-2011 00:00 06-Feb-2011 00:00 Rig 183.992 DFDP-1B - Waitangitaona River 183.977 ICDP5052EH02001 5052 2 A 43 17.439 S 170 24.397 E 170.407 -43.291 01-Sep-2014 00:00 30-Sep-2014 00:00 Washington Rig 93.690 DFDP-2A - Whatarao River ICDP5052EH12001 5052 2 B 43 17.439 S 170 24.388 E 170.406 -43.291 03-Oct-2014 00:00 18-Dec-2014 00:00 Hanjin D+B-45D Rig 94.840 DFDP-2B - Whatarao River ICDP5052EH22001