Geological Society of America

T54 Bridging the Laboratory–Database Divide in Geochemistry

Tuesday, 27 October 2020
10:00 AM - 12:00 PM
Meeting Rooms

EODP: ADAPTING EXISTING DATABASE STRUCTURES TO WORK WITH SCIENTIFIC OCEAN DRILLING DATA

Paper number: T54-3
Program: Technical Sessions
Time: 10:30 AM – 10:45 AM

Authors

Andrew Fraass Presenting Author
University of Bristol, Bristol
Andrew Fraass Presenting Author
The Academy of Natural Sciences of Drexel University, Philadelphia, PA
Leah J. LeVay
Texas A&M University, College Station, TX
Jocelyn Sessa
The Academy of Natural Sciences of Drexel University, Philadelphia, PA
Shanan Peters
University of Wisconsin–Madison, Madison, WI
Seth Kaufman
Whirl-i-Gig, Greenport, NY
Wai-Yin Kwan
Whirl-i-Gig, Greenport, NY
Kelly Rozanitis
The Academy of Natural Sciences of Drexel University, Philadelphia, PA
Wunn Noon Naw
The Academy of Natural Sciences of Drexel University, Philadelphia, PA
Phoebe O'Brien
University of Bristol, Bristol

Abstract

Scientific ocean drilling, through the International Ocean Discovery Program (IODP) and its predecessors, has produced vast quantities of data revolutionizing many geoscience subdisciplines. Much of that data, however, is dispersed into a variety of bespoke databases. Of key importance is the lack of a resource that collates marine stratigraphy and the age, deposition, and fossil composition of the ~435 km of scientific ocean drilling cores. Having that data processed and located in a central repository would be an obvious boon to the research community, allowing for both its scientific use and as a stratigraphic nexus upon which to mount other research initiatives. Extending Ocean Drilling Pursuits (eODP) is an NSF EarthCube-funded project seeking to facilitate access to, and aid visualization of, these large ocean datasets. To do this we are leveraging two established resources, the Paleobiology Database (PBDB) and Macrostrat, and collaborating with Open Core Data and NeptuneSandBox.

Having acquired funding in late 2019-early 2020, we will share in this presentation what we’ve learned, discuss standards and practices, and structural concerns raised thus far. A fundamental issue is that scientific ocean drilling data are held within several unconnected databases, largely corresponding to which program generated the data. For example, Deep Sea Drilling Project-era data are maintained by NOAA in .html tables, whereas the current IODP database, LIMS, produces a variety of file types that are accessed via an API (application programming interface). In order to standardize stratigraphic and fossil occurrence data into a unified format, an intermediate platform (called the ‘Baggage Stripper’) is being built to standardize across the disparate sources, preserve the data as it was collected during cruises, and cross-walk to the PBDB and Macrostrat. Other efforts have included QA/QC on these data and determining how the PBDB and Macrostrat need to be modified to handle ocean drilling data.

Geological Society of America Abstracts with Programs. Vol. 52, No. 6

doi: 10.1130/abs/2020AM-357130

© Copyright 2020 The Geological Society of America (GSA), all rights reserved. Permission is hereby granted to the author(s) of this abstract to reproduce and distribute it freely, for noncommercial purposes. Permission is hereby granted to any individual scientist to download a single copy of this electronic file and reproduce up to 20 paper copies for noncommercial purposes advancing science and education, including classroom use, providing all reproductions include the complete content shown here, including the author information. All other forms of reproduction and/or transmittal are prohibited without written permission from GSA Copyright Permissions.