Cooperative Shark Mark Recapture Database (MRDBS)

The Shark Mark Recapture Database is a Cooperative Research Program database system used to keep multispecies mark-recapture information in a common format for management and analysis. It tracks fish and tags independently, is web based for remote access for data input and QA/QC, and has the capability to perform audits and updates.

To keep release and recapture information from the Cooperative Shark Tagging Program for further analysis.

Contact Point of Contact for access

NEFSC Data Access Procedure:

1. Formal request in writing usually to the data owner/contact or Center Director;

2. Requester is contacted by data owner to review and verify the request content and details for data delivery options.

3. If data is confidential then owner will determine if the data may be released to the requester;

4. If data can be released, the data is downloaded and packaged for delivery electronically; or the requester may be directed to where the data is available online.

Must get prior approval from Point of Contact for access. Data contains PII - must be redacted before giving access to data

NEFSC Data Access Constraint:

If data is stored on an internal NEFSC network, the requester may not have direct access to query the data unless they are also authorized for network access.

Must get prior approval from Point of Contact on data usage

Oracle 11g database on raja

Volunteer anglers collect the majority of the data, so can not be deemed entirely accurate

We rely on volunteer anglers to submit data, so there may be omissions that we can not control

Data validation during data entry

Database integrity constraints

Post audits by internal editors

Data will be archived once a solution for archiving relational data sets is defined, data contains PII which must be redacted

Archival of source data preserving unaltered collected data, Scheduled backups, Remote storage backups, Password protection

When a animal is tagged or recaptured, information about tag number, event, animal, location and contact is recorded.  These data are audited and entered into the Mark Recapture database using a web application with extensive data audits.