Novel software for oceanographic cruise planning, execution and results database management
Faced with the need to integrate the results of dozens of cruises performed by the Gulf of Mexico’s Research Consortium (CIGOM) financed by Mexico’s CONACYT-SENER Hydrocarbon fund (2015-2022), we developed a software package with an online interface that:
The system provides a group of tools to plan an expedition: catalogs to manage the instruments and crew on board, custom interfaces to plot a detailed schedule of sampling which includes course, statitions and depths to visit during the expedition.
During the expedition the system can be used online or bring on board in an offline laptop to review the expedition plan and easily confirm the samples obtained in constrast to what was planed. The system is also very flexible to accomadate any last minute change and record the exceptions in the metadata.
The system provides capture templates which come with the samples successfully obtained and aditional enviromental data from instruments obtained during the expedition. The data is stored in SQL and nonSQL databases acording to the complexity of such data, which can range from discrete geochemical data points to taxonomic lists obtained through metabarcoding.
In order to promote the collaboration and data discovery, the system implements a group of filters that provide dynamic options based on the data being selected. This helps the user to easily search data without previus knowledge of the database content. The filtered results can be exported in several formats.
Although SGEO was created to fulfill CIGoM necessities, the success of the system motived us to adapt the system with the capacity to host multiple projects, regions and diferent types of expeditions. We are also looking foward to connect our system with international initiatives of data analysis and visualization tools.
Contact us if you are interested in using the system for your projects or collaborate with us:
Dr. Sharon Herzka - firstname.lastname@example.org
Technical Support - email@example.com
For more information about other areas of the CIGoM project visit the website cigom.org