4 Table Summaries
The CTD database has 11 tables and one view. The tables are
briefly described below:
t_trip : Trips where physical oceanography data were
collected.
t_station : Information on each station and cast in
each voyage.
t_metres : Temperature, conductivity, salinity,
specific gravity anomaly and speed of sound information for each 1
metre of depth in a cast producing nearly continuous data (downcast
only). There is a view on this table:
3.1 v_metres : Contains data
from t_metres at 10, 20, 30, 50, 75, 100, 125, 150, 200, 250, 300,
400, 500, 600, 700, 800, 900, 1000, 1100, 1200, 1300, 1400, 1500,
1750 and 2000 metres.
t_bottle_casts : Casts using water sampling bottles
and measurement methods used.
t_bot_values : Temperature and conductivity values
from each sample in a bottle cast and, where applicable, CTD
values from the same cast at the same depth.
t_cond_cals : Regressions (calibrations) of
conductivity of water samples against conductivity as measured by
CTD conductivity sensors.
t_con_coeffs : Conductivity correction coefficients
from conductivity calibrations.
t_press_cals : Calibrations of CTD pressure
sensors.
t_temp_cals : Calibrations of CTD temperature
sensors.
t_pre_coeffs : Pressure correction coefficients from
pressure calibrations.
t_tem_coeffs : Temperature correction coefficients
from temperature calibrations.