Database documentation: acoustic

 Download as PDF (502KB) 

G.J. Macaulay

NIWA 

June 27, 2006

Contents

1  Database Document Series

2  Acoustic data collection

3  Data structures

4  Table Summaries

5  acoustic Tables

                5.1 algorithms

                5.2 bottomprints

                5.3 bottoms

                5.4 clients
            
                5.5 componentclassifier

                5.6 components

                5.7 componenttypes

                5.8 daporigins

                5.9 dfilenamelegacycal

                5.10 dfilenamewaterproperties

                5.11 directoryclassifier

                5.12 directoryplatformsystem

                5.13 equipment

                5.14 experiments

                5.15 experimenttypes

                5.16 filenote

                5.17 files

                5.18 files_transect_detailed

                5.19 files_transect_simplified

                5.20 globals

                5.21 legacycal

                5.22 logbooks

                5.23 mbsregionslices

                5.24 mbsspec

                5.25 mbssst

                5.26 padcs

                5.27 ping
        
                5.28 pingattitude

                5.29 region

                5.30 regionpoints

                5.31 regionsinfile

                5.32 sborigins

                5.33 splussrt

                5.34 svcorrectionfactors

                5.35 t_trip

                5.36 transducers

                5.37 v_files

                5.38 v_files_detailed

                5.39 v_files_endpoint

                5.40 v_files_simplified

                5.41 v_files_startpoint

                5.42 vessels

                5.43 voyages

                5.44 vtvariation

                5.45 waterproperties

6 acoustic business rules

                6.1 Introduction

                6.2 Summary of rules

7 Data formats

                7.1 Header format

                7.2 Header type 32

List of Figures

1        ERD for entire database

2        ERD for the files and related tables

3        ERD for the tables associated with the echosounder equipment

4        ERD for the tables associated with an experiment

5        ERD for the tables associated with echo integration analysis of the acoustic data

6        ERD for temporary tables used to provide information during data loading, as well as some tables that contain global information