talk · Tuesday 22 September · 08:50–⁠09:05 · SAL C

Extending Specify 7 for geological collections (GeoSpecify)

Theresa Miller · Rocks, Minerals, and Metadata: Integrating Earth Sciences into the TDWG Community

Recording time 19:04–33:20Open on Vimeo ↗

Summaries and key moments are machine-produced. Check the recording for the speaker’s exact words.

The short versionGeoSpecify brings geology into the same Specify data model as biological collections, with purpose-built age, stratigraphy and composite-object features.

Overview

What this was about

Theresa Miller presented GeoSpecify, the SwissCollNet-funded collaboration (Natural History Museum Bern, Specify Collections Consortium, Ben Norton) that extended the existing Specify 7 data model for geology rather than building a separate system. After requirements gathering with Swiss museums and an advisory committee, Specify gained an improved chronostratigraphy tree with start/end ages and biostratigraphy flags, a tectonic unit tree, an extended Geologic Context table, one-to-many relative and absolute age tables, and an 'extended age query' that searches all age fields by name or numeric range with strict or non-strict matching. Collection object types, discipline default forms, collection object groups (discrete, consolidated, drill core) and components allow mixed rock, mineral and fossil collections in one system, with Darwin Core Archive export planned to include the mineralogy extension.

Why it matters. Institutions with mixed biological, paleontological and geological holdings can manage them in one standards-aligned system and publish geology data via Darwin Core.

Key ideas

In the room

  • Project led by Beda Hofmann (NHM Bern), James Beach (Specify) and Ben Norton, funded via the Swiss Academy of Sciences' SwissCollNet; phase 1 (from 2023) built a conceptual model and classification, phase 2 defined requirements and implementation.
  • Requirements came from four Swiss collections (Bern, Basel, Geneva, Lausanne), a GeoSpecify advisory committee and an on-site requirements trip; needs included warnings for heavy or toxic specimens.
  • Chronostratigraphy tree shows start/end dates, links to the International Chronostratigraphic Chart, stays ordered by age and can flag biostratigraphy nodes.
  • Lithostratigraphy and a new Tectonic Unit tree are populated locally because terms vary by region.
  • Geologic Context links to all stratigraphic trees and supports start and end chronostratigraphic periods; relative and absolute ages are one-to-many (e.g. deposition and metamorphism ages).
  • Extended age query searches geologic context, relative and absolute ages together, converting period names to numeric ranges and supporting strict/non-strict range matching.
  • Collection Object Types let one collection hold minerals, rocks and fossils with different trees, forms and numbering; Collection Object Groups (discrete, consolidated, drill core) and components capture composite specimens.
Jump in

Notable moments

In their words

Transcript

Automatically generated captions can contain mistakes, especially in names and technical terms. Times are relative to the room recording.

Read the transcript ↓
Loading transcript…
Programme abstract

Extending Specify 7 for Geological Collections

Theresa Miller

For 25 years, Specify has provided biological research museums and genetic repositories with software and technical services for curating, integrating, and publishing collections information. With funding from the Swiss Academy of Sciences (SwissCollNet initiative) and in collaboration with four Swiss natural history museums (Basel, Bern, Lausanne, Geneva), the Specify Collections Consortium (SCC) extended Specify to support geological collections.

Geocollections database requirements are similar in many ways to those of biological collections, however their unique properties and cataloging protocols challenged us to extend Specify concepts and capabilities. In addition to adding new tables, such as Absolute and Relative Age, and a new tree, Tectonic Unit, Specify added support for new protocols, most notably, Collection Object Groups (COGs), Components, and Collection Object Types (COTs).

In this presentation, SCC staff will discuss and demonstrate the new tables, tree, and features added to the Specify schema in order to support Geology Collections and their unique needs. These new features were designed to also support functionality required by Natural History Collections, the backbone of our membership.

The SCC is an open-source, collections community collaborative governed, funded, and sustained by its member institutions. Our software and technical support priorities address member data and system infrastructure needs. With Specify’s extension into the earth sciences, natural history museums will now be able to curate, integrate, and publish data from a robustly engineered single platform for both biological and geological collections.

Submitted to the conference programme before the talk, so the talk itself may differ.