####################### Meta Data Part ############################# Column Name Data Type Description Label Validation Text Unit 1 EXPEDITION Numeric expedition code Expedition expedition code (Int. 1 - 99999), required key field between 1 and 9999 # 2 SITE Numeric site, number between 1 and 9999 Site site (1 -9999), required key field <>0 <>0 # 3 HOLE text hole identifier, A-Z Hole hole ( A-Z), required key field LIKE ('[A-Z]') # 4 CORE Numeric core identifier Core core identifier, required field, 1-99999 between 1 and 99999 # 5 CORE_TYPE Text type of core, piston, gravity.... Core Type core type(max. 1 char) <>'' # 6 SECTION Numeric section number Section section number > = 0 >=0 # 7 SECTION_ID Numeric core section code, autoincremented Section ID # # # 8 INIT_LENGTH Double section length Section Length # # # 9 REV_LENGTH Double curated length Curated Length # # # 10 TOP_DEPTH Double elevation of core section top Top Depth (m) # # m 11 BOTTOM_DEPTH Double elevation of core section bottom Bottom Depth (m) # # m 12 ANALYST Text initials of the data operator Curator # # # 13 REMARKS Text additional remarks Remarks # # # 14 CC Text section is core catcher section?, yes or no CC core catcher section ? (yes or no ) IN ( 'yes','no') # 15 MCD_TOP Double composite top depth (mcd) of sample in m MCD Top MCD top depth >= 0 >=0 m 16 SEC_MCD_OFFSET Double offset of composite depth for section Sec. MCD Offset required real value # m 17 BOX Integer number of core box section is stored Box # # # 18 SLOT Numeric number of core box slot section is stored Slot required integer value between 1 and 5 between 1 AND 5 # 19 POSITION Text postion of section in core box (T=top, M=middle, B=bottom,F=full) Position required text string of max. 1 character ('T', 'M','B','F') IN ( 'T', 'M','B','F') # 20 IGSN Text IGSN IGSN text string of max. 15 characters # # ####################### Data Part ############################# EXPEDITION SITE HOLE CORE CORE_TYPE SECTION SECTION_ID INIT_LENGTH REV_LENGTH TOP_DEPTH BOTTOM_DEPTH ANALYST REMARKS CC MCD_TOP SEC_MCD_OFFSET BOX SLOT POSITION IGSN 5029 4 B 3 Z 1 3101870 0.520 0.520 3648 3,648.520 RZ yes 3648 0 1 1 T ICDP5029ESCFHU2 5029 4 B 5 Z 1 3101872 1.110 1.110 3,865.500 3,866.610 RZ yes 3,865.500 0 1 1 B ICDP5029ESQFHU2 5029 4 B 5 Z 2 3101874 1.310 1.310 3,866.610 3,867.920 RZ no 3,866.610 0 2 1 F ICDP5029ESUFHU2 5029 4 B 5 Z 3 3101876 1.430 1.430 3,867.920 3,869.350 RZ yes 3,867.920 0 3 1 F ICDP5029ESWFHU2 5029 4 B 6 Z 1 3101878 0.150 0.150 3,869.800 3,869.950 RZ yes 3,869.800 0 1 1 B ICDP5029ES2GHU2 5029 4 B 7 Z 1 3101880 0.120 0.120 4,089.500 4,089.620 RZ yes 4,089.500 0 1 1 B ICDP5029ES4GHU2 5029 4 B 8 Z 1 3101882 0.200 0.200 4,254.300 4,254.500 RZ yes 4,254.300 0 1 1 B ICDP5029ES6GHU2 5029 4 B 10 Z 1 3101884 0.230 0.230 4,309.900 4,310.130 RZ yes 4,309.900 0 1 1 B ICDP5029ESGGHU2 5029 4 B 11 Z 1 3101886 1.550 1.550 4,634.200 4,635.750 GOF no 4,634.200 0 1 1 T ICDP5029ESIGHU2 5029 4 B 11 Z 2 3101888 1.480 1.480 4,635.750 4,637.230 GOF no 4,635.750 0 1 1 T ICDP5029ESKGHU2 5029 4 B 11 Z 3 3101890 1.650 1.650 4,637.230 4,638.880 GOF no 4,637.230 0 3 1 F ICDP5029ESMGHU2 5029 4 B 11 Z 4 3101892 1.440 1.440 4,638.880 4,640.320 GOF no 4,638.880 0 4 1 T ICDP5029ESOGHU2 5029 4 B 11 Z 5 3101894 1.460 1.460 4,640.320 4,641.780 GOF no 4,640.320 0 5 1 T ICDP5029ESQGHU2 5029 4 B 12 Z 1 3101896 1.410 1.410 4,642.800 4,644.210 GOF no 4,642.800 0 1 1 T ICDP5029ESSGHU2 5029 4 B 12 Z 2 3101898 1.400 1.400 4,644.210 4,645.610 GOF no 4,644.210 0 2 1 T ICDP5029ESUGHU2 5029 4 B 12 Z 3 3101900 1.580 1.580 4,645.610 4,647.190 GOF no 4,645.610 0 3 1 T ICDP5029ESWGHU2 5029 4 B 12 Z 4 3101902 1.650 1.650 4,647.190 4,648.840 GOF no 4,647.190 0 4 1 F ICDP5029ESYGHU2 5029 4 B 12 Z 5 3101904 1.660 1.660 4,648.840 4,650.500 GOF no 4,648.840 0 5 1 F ICDP5029ES0HHU2 5029 4 B 12 Z 6 3101906 1.300 1.300 4,650.500 4,651.800 GOF no 4,650.500 0 6 1 T ICDP5029ES2HHU2 5029 4 B 13 Z 1 3101908 0.980 0.980 4652 4,652.980 GOF no 4652 0 1 1 T ICDP5029ES4HHU2 5029 4 B 13 Z 2 3101910 1.640 1.640 4,652.980 4,654.620 GOF no 4,652.980 0 2 1 F ICDP5029ES6HHU2 5029 4 B 13 Z 3 3101912 1.370 1.370 4,654.620 4,655.990 GOF no 4,654.620 0 3 1 T ICDP5029ES8HHU2 5029 4 B 13 Z 4 3101914 1.590 1.590 4,655.990 4,657.580 GOF no 4,655.990 0 4 1 T ICDP5029ESAHHU2