The LILY Database: Linking Lithology to IODP Physical, Chemical, and Magnetic Properties Data

During each expedition of the International Ocean Discovery Program and its precursor, the Integrated Ocean Drilling Program (jointly referred to as IODP), vast arrays of data are collected from drill cores. These data, which are accessible from the IODP LIMS (Laboratory Information Management System) database, include physical, chemical, and magnetic properties collected semi-continuously along cores using automated track systems, as well as a variety of analyses conducted on discrete subsamples taken from the cores. In addition, the lithology of all cores is described based on visual characteristics of the surface of split cores, visual examination of smear slides and thin sections, and compositional or mineralogical information derived from geochemical analyses. We extract basic lithologic information from this complex array of descriptive information and then tie that information to all other measurements. This new database is referred to as LIMS with Lithology (LILY). LILY currently contains over 34 million data from 89 km of core recovered on 42 expeditions conducted 2009-2019. Some uses of LILY include identifying the abundance of different lithologies, finding data from core intervals with a specific lithology, assessing the efficacy of coring systems in different lithologies, or characterizing and analyzing physical, chemical, and magnetic properties based on lithology. We illustrate the use of LILY by computing the grain density by lithology from over 24,000 moisture and density measurements and then use those grain densities, along with the large IODP bulk density dataset, to compute a new high-resolution porosity dataset with over 3.7 million new porosity estimates.

CONTENT DESCRIPTION:

The main LILY database is stored in the files with the suffix _DataLITH.csv. Each file contains IODP LIMS data with lithology and other metadata added. The file prefix gives the type of data. For example, AVS_DataLITH.csv contains the Automated Vane Shear (AVS) shear strength data paired with lithology and other metadata. A list of all data types is given in Supporting Information Table S1 of Childress et al. (submitted to AGU G-cubed).

Other compressed data folders contain multiple files used in creating the LILY database:

1_RawDESC.zip: Contains 7,940 .csv files derived from the raw text content of the DESClogik Excel worksheets that was extracted, converted to comma separated value (.csv) format, and put into files with a consistent naming convention, without applying any corrections or conversions to the original text. Each file is the direct extraction of a tab from the DESC workbooks, available at https://web.iodp.tamu.edu/DESCReport/

2_CoreSUMM.zip: Contains one file with Core Summary information, which includes the expedition, site, hole, core, coring type, top and bottom depths drilled, advances and recoveries, time and date of recovery, and the number of sections. These data are further paired with additional metadata (expanded core type, latitude, longitude, and water depth). Coordinates and water depth for each hole are derived from LIMS (and the JANUS database at http://www-odp.tamu.edu/database/ for older expeditions).

3_RawDATA.zip: Contains the raw track/discrete dataset downloaded by expedition from IODP LIMS database and placed in folders for each type of data (AVS, CARB, SRM, etc.)

4_RawLITH.zip: Contains 42 .csv files, with one file for each expedition. Each file contains all lithologic description (prefix, principal and suffix, etc.) information for an entire expedition, as it was originally described. These have been transformed to a consistent format and paired with consistent identification information and additional metadata. Headers are normalized across all expeditions and SampleID information is standardized.

5_CleanLITH: Contains 42 .csv files. Each file contains all lithologic description (prefix, principal and suffix) information for an entire expedition. The lithologic descriptions have been standardized to a consistent nomenclature using the dictionary given in Support Information Table S4 of Childress et al. (submitted to AGU G-cubed). These data are further paired with additional metadata (e.g., degree of consolidation, expanded core type, latitude, longitude, and water depth).