Research Opportunities
Research Database Documentation
acoustic
Database Document Series
Acoustic Data Collection
Data Structures
Figure 1 ERD for the entire database
Figure 2 ERD for the files and related tables
Figure 3 ERD for the tables associated with the echosounder equipment
Figure 4 ERD for the tables associated with an experiment
Figure 5 ERD for the tables associated with echo integration analysis of the acoustic data
Figure 6 ERD for temporary tables used to provide information during data loading as well as some tables that contain global information
Table Summaries
Acoustic Tables
Acoustic Business Rules
Data Formats
References

4 Table Summaries

The seven main tables contained in the acoustic database are:

experiments  contains details on a set of data collected as part of a voyage, project,
or experiment.  
equipment contains details on the equipment used to collect a set of data.  
files  contains details on the acoustic echodata files, as well environmental data for
the beginning and end of the transect.  
ping  contains environmental data for every ping.  
components   contains details on the equipment used to collect each acoustic data set.  
slplussrt   contains calibration factors to enable conversion of the acoustic data to
physical units. 
mbsspec contains details on the process in which the acoustic data was combined to
form biomass estimates




Previous | Next
Updated : 4 March 2008