Database Tables

The Block Lab tagging metadata is separated into fish and shark group tables. Furthermore the fish data is separated into archival and satellite tables.This distinction exists for sharks as well but there are so few archival deployments that most people can safely ignore their existence.

Acoustic tag metadata is stored in the satellite tables.

The tables can be viewed/queried using PSQL, Microsoft Access or any other application/language that can connect with Postgresql.

The main field for joining all tables is eventid. In some tables it's actually called eventid, but in many others it is not. All of the following are synonyms for eventid: fgadkey, fgapkey, fgarkey, fgsdkey, fgdkey, sgdepkey, and sgdkey.

A map of the main tables and their relationships can be found HERE.

The following links describe the data more fully:

Archival Fish Metadata

Satellite/Acoustic Fish Metadata

Processing Fish Metadata

Shark Metadata

Processing Shark Metadata

Archival and Satellite (PAT) Processed Data

SPOT Data

Acoustic Data

Management Data

Other views