Database documentation: ctd (Fisheries Oceanography)

  Download as PDF (105KB)

K. A. Mackay & W. J. Taylor

NIWA Internal Report

Revised on 21December 2002

Contents

1 Introduction to the Database Document series

2 Fisheries Oceanography Database

2.1 Data sources

2.2 Uses of the ctd Database

2.3 Trip, cruise, or voyage?

3 Data Structures

3.1 Table relationships

3.2 Database design

4 Table Summaries

5 ctd Tables

5.1 Table 1: t_trip

5.2 Table 2: t_station

5.3 Table 3: t_metres

5.4 Table 4: t_bottle_casts

5.5 Table 5: t_bot_values.

5.6 Table 6: t_press_cals

5.7 Table 7: t_pre_coeffs

5.8 Table 8: t_temp_cals

5.9 Table 9: t_tem_coeffs

5.10 Table 10: t_cond_cals

5.11 Table 11: t_con_coeffs

6 References

7 Acknowledgements

Appendix

List of Figures

Table 1: Entity Relationship Diagram (ERD) for the ctd database.

Table 2: Temperature Coefficient s for the calculation of t s

Table 3: Accuracy of depth, temperature, and salinity data acquired using various methods.