This lesson is still being designed and assembled (Pre-Alpha version)

Reporting to the Database

Overview

Teaching: 30 min
Exercises: 0 min
Questions
  • How do I report to the OTN Database?

  • Why should I report my data?

  • How do I receive my detection matches?

Objectives

Metadata Reporting and Best Practices

Reporting Data to an OTN Node

Researchers who are part of the OTN Network are encouraged to register their projects and report data and metadata in a timely manner to their Data Manager. This will benefit all researchers in the region through the database’s detection-matching system.

This presentation Reporting to OTN will cover some of the following topics.

You are encouraged to read the OTN FAQs Page for more information.

How to register with the OTN Database

In order to register a project with OTN, we require 3 metadata types:

  1. project metadata
  2. instrument deployment metadata
  3. tagging metadata

See the templates here. OTNDC@DAL.CA is the best contact for assistance

What is the benefit of registering with the OTN Database?

OTN and affiliated networks provide automated cross-referencing of detection data with other tags in the system to help resolve “mystery detections” and provide detection data to taggers in other regions. OTN’s Data Manager will also extensively quality control submitted metadata for errors to ensure the most accurate records possible are stored in the database. OTN’s database and Data Portal website are excellent places to archive datasets for future use and share with collaborators. We offer pathways to publish datasets with OBIS, and via open data portals like ERDDAP, GeoServer etc. The data-product format returned by OTN is directly ingestible by analysis packages such as glatos and resonATe for ease of analysis. OTN offers support for the use of these packages and tools.

Metadata Tips and Tricks

Below are some field-specific guidelines for completing metadata. The OTN Field team has their own metadata format, based on the Shortform Template, but containing OTN-specific columns, which is used for many projects.

The OTN-Field deployment metadata sheet is available HERE

If you are unsure of what information to put in a column, refer to the Data Dictionary tab of the metadata for other instructions.

Upon Deployment

When a mission contains deployments, there is some information needed:

OTN staff have had great success with recording deployments properly.

Upon Recovery

When a mission contains equipment recoveries, there is some information needed:

OTN staff have had great success with recording recoveries properly.

Download-only Missions

When a mission contains stations which are remotely downloaded, metadata still needs to be completed:

TIP: For deployments where multiple remote downloads occur (5-year+ VR4 moorings), on each download, you replace the previously listed download date in the metadata with the new date and accompanying comments.

Lost or Found Gear

Generally, equipment is marked with a y in the recovery indicator column if recovery is successfully completed during a mission, or n if recovery has not yet been attempted for the specific mooring. There are other cases which need special consideration in the metadata:

Recovered equipment:

Non-recovered equipment:

Found equipment:

Other accepted terms include moved, which is used when a mooring is recovered successfully, but was a substantial distance from its deployment location suggesting fishing interactions or movement during a storm.

OTN specific-columns

Mission IDs for both the recovery and deployment missions are helpful to ensure we’re able to link the mission report (notes) to the deployment history. These fields aren’t mandatory but can be very useful internally!

Consecutive deployment number is helpful for tracking stations which have been rolled-over and those which haven’t yet, but is not a mandatory field.

Raw Field Notes

Often, typos are introduced into metadata sheets while being transcribed. This means that the true information is only found in the raw field notes, contained in muddy write-in-the-rain notebooks. These are easily lost and not easily searchable.

For these reasons, it is strongly encouraged to take a photo of the field notes at the end of the mission and upload it to the project’s Data Portal repository folder for safe-keeping. These can be used to untangle metadata mysteries that might occur, and will preserve this information when projects are handed between technicians.

Example Raw Metadata Image

Key Points

  • Metadata templates are used to report records

  • OTN matches data and metadata across numerous geographic areas

  • Detection extracts are returned to researchers after data pushes