Published February 14, 2024 | Version 1.0
Computational notebook Open

AskICE-D: A querying tool for the ICE-D project

  • 1. ROR icon University at Buffalo, State University of New York
  • 2. ROR icon Berkeley Geochronology Center
  • 3. ROR icon Lawrence Livermore National Laboratory

Description

The ICE-D project (www.ice-d.org) is an effort to organize cosmogenic-nuclide exposure-age data that are useful for, among other things, reconstructing past glacier and ice sheet change. It uses a “transparent-middle-layer” design that solves a number of problems associated with synoptic analysis of geochronology data by enforcing internally consistent calculation of geologic ages across a large data set. At present, the database is fairly complete for Antarctica (www.ice-d.org/antarctica), Greenland (www.ice-d.org/greenland) and alpine glaciers in many parts of the world (www.ice-d.org/alpine), but data is continually being published and there is room for improvement.

The ICE-D project is hosted online as a Google Cloud Project, and the database of raw observations used to calculate exposure ages is structured as an SQL database. As such, major effort has been spent to 'onboard' users from the community to get connected to the database and teach users to query the database, which requires time and some technical skills in using SQL. To lower the barrier to entry and invite a broader of audience of potential users, this tool was developed with a simple user interface that can automatically build SQL queries based on user input, send a request directly to the ICE-D database, and dynamically return results all without any prior knowledge on the user's behalf of SQL nor any registration with the ICE-D Project (although we highly encourage folks who want to get involved to reach out to us!)

When using the tool, please feel free to contact us with any questions and/or bugs/issues/improvements to report.

Files

askiced.zip

Files (1.4 MB)

Name Size Download all
md5:e6ae54402cadf1dda9904a4389f8032b
1.4 MB Preview Download

Additional details

Related works

Is published in
Computational notebook: https://theghub.org/ (URL)

Funding

Collaborative Research: Frameworks: Ghub as a Community-Driven Data-Model Framework for Ice-Sheet Science 2004826
National Science Foundation

Software

Programming language
Python, SQL

References