You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 47 Next »

Table of content

The GEODESC applications and user documentation will be in development until ~mid 2022.

Overview

The GEODESC application tool set was designed and built in 2019-2022 to support geological core description and micropaleontological data capture on the scientific drilling vessel JOIDES Resolution (JR). It replaces the DESClogik application used for more than a decade.

The GEODESC system includes five browser-based user applications backed by an Oracle database (Figure 1):

  • The Data Capture application is based on the widely used and user-approved method of capturing observational data in spreadsheets: A row represents a description interval, and the columns specify the scope of the observations and the observables. You need the  observer role assigned to your database account to use the app for your project. 
  • The Template Manager application allows you to make any changes you need to your project templates. You need the template maker role assigned to your database account to use the app for your project.
  • The Data Access application allows anyone to download the final description files and template metadata files, on the ship and on shore. Access to data is moratorium protected.
  • The Catalog Manager is a tool to gradually update the GEODESC catalogs used in the Template Manager app into the future, based on actual use. Only qualified support people are given the reviewer role to update the catalog.
  • The Taxa File Checker application facilitates the creation of micropaleontology templates using validated taxonomic name lists. Anyone can use this application.

Figure 1. GEODESC overview diagram.

Data Capture application

Once your project templates are installed using the Template Manager application, you will spend most of your time with the Data Capture application. This application has three pages:

  • Sign in
  • Workset dashboard
  • Worksheet or workbook

The sign in page:

The dashboard page:

  • After you sign in, you land on the workset dashboard.
  • If the desired workset is available in the lower panel, double-click it or select and then Open.
  • If not, create one or more worksets you want to work on.
    • Select a template in the upper left table.
      • A project typically uses multiple spreadsheet templates based on the scale, type and objective of observations.
      • If the desired template is not listed, even after refreshing the page, use the Template Manager application.
    • Select Expedition, Site, Hole and optionally a range of cores in the panel on the right.
    • Click Create and the workset(s) appear in the workset list (pre-selected).
    • Click Open to create the worksheet (or workbook for multiple worksets)
  • When you Open one or more worksets, nobody else can work on that set of cores and template at the same time.

The worksheet (or workbook including multiple tabbed worksheets):

  • Note that the spreadsheet functions are constrained by many special features designed to make data capture efficient and to promote data integrity. 
    • You cannot add empty rows or columns
    • Columns and their validation criteria are configured in the Template Manager application.
    • Rows are added with specific function to ensure each row represents a description interval including a sample ID.
  • Use the first button in the function ribbon at the top to add samples.
    • One row is added for each sample, with the observation scope given in the first 18 columns.
  • If working with large samples (e.g., section halves, cores), change the offsets to define the description interval.
    • Use the row context menu to select among three options for adding, inserting or replicating intervals.
  • Enter observations in the observable columns, using free text, numbers, or list values, depending on how the columns are configured.
    • Data entries are immediately autosaved to the database for data safety.
    • To update the description data file in the database that is available to the entire team, click the Upload button.
      • An upload initiates a sort and a validation and flags all errors that are not already flagged.
      • Tis triggers a data validation and data cannot be uploaded unless all errors are fixed.
      • The final data consist of tab-delimited text files, one data file per template and hole, and one metadata file per template.
  • Use the Close button on the ribbon when done with your observation session.
    • You are given options to keep or loose data if not uploaded, and keep or delete that specific workset definition.

The Template Manager application

At the beginning of a project, the Template Manager application is used to install project templates and enable them for use in the Data Capture application. This is the only process summarized here and includes the following pages/windows:

  • Sign in
  • Project templates → Copy catalog templates to project
  • Edit template → Template settings

Once data capture is underway, the application is only used occasionally to make changes to the template configurations, using ~50 additional pages and modal windows (about half are only applicable to micropaleontology templates). These functions fall into three categories (see the full Template Manager user guide for details):

  • Add columns from the catalog or create new ones, remove columns.
  • Edit or create validation criteria for columns, including value (dropdown) lists, numeric entry, and formulas.
  • Edit column display settings for default display in the Data Capture worksheets (can be further edited in Data Capture)

The sign in page:

The Project templates page:

  • After you sign in, you land on the Project templates page.
  • If you don't see all the templates you want to use in your project, click the Copy from catalog button.
    • Browse or filter to find what looks like a suitable template in the catalog.
    • Click the Copy selected catalog template to project button.
    • Note: If you can't find a suitable catalog template, you can create a project template from scratch, but that is a more involved process than modifying an existing one.
  • Back on the Project templates page, you will see the added template.

The Edit template page (the template 'dashboard"):

  • To edit a template, select it on the Project templates page and click the Edit button, or double-click the template.
    • You will land on the Edit template page, the dashboard for any template modifications.
  • If you are ready to make the template available in Data Capture:
    • Click the Template settings button on the top left.
    • In the pop-up window, check the Make template available to observers check box.
    • Click the Save button on the window.
    • Click the Save template button on the Edit template page.
    • Go to the Data Capture application tab and refresh the page - voila! 

The Data Access application

The Data Access application is used to download all information available in, and collected with GEODESC.

You can navigate between the two categories of information in the 'hamburger' (top left of page):

  • Descriptive data (you must select an expedition first and you can filter in multiple ways)
    • Descriptive data files
    • Descriptive metadata files
  • Catalog content
    • Template catalog
    • Observable catalog
    • Entry value catalog
    • Taxonomic catalogs
    • Zone catalog
    • Datum catalog

The Catalog Manager application

The GEODESC catalogs offer the template makers resources that should facilitate template modifications, or even creation, while maintaining the general integrity of observable definitions. Although the catalogs are based on a careful analysis of decades of spreadsheet use on the JR, they are never perfect and we anticipate that some if not all of them will keep evolving over the years. That is why we built the Catalog Manager application, to ensure that changes to the catalog are consistent with all the GEODESC features and requirements.  

Using the Catalog Manager requires the reviewer role, which is given to a few qualified staff members. Project teams cannot change the catalog directly, but they can make any changes they need to their project templates. Reviewers take such changes into account when updating the catalogs for future expeditions.

Limitations for external use

The GEODESC tool set is taking advantage of existing tools and resources on the JR for efficient data gathering and reporting, and therefore cannot easily be used outside the JR computing infrastructure. Most importantly, GEODESC is using the feature-rich sample registry that evolved over decades to accommodate user needs. In addition, it uses the same depth computation rules and routines for standard depths and alternate depths that are used for all other shipboard data.

If GEODESC was to be fully used in another organization, these resources would have to be replicated or replaced.

However, external projects can take advantage of the GEODESC catalog resources and final product data files, all available in tab-delimited text format, and use them in commercial spreadsheet programs or custom programs with or without adding sample registry and data validation functions. 

  • No labels