Documentation for VIMS Ambient Water Monitoring Data, Daily Summary

Contents:

1.  Data Dictionary
2.  Number of observations per year, 1947-2003
3.  Algorithm used to calculate Salinity from Conductivity and Water Temperature 


1.  Data Dictionary

  The following are lists of parameters for each of the daily Pier data files.
Mean, Min and Max daily values were calculated from multiple daily observations (N).

vims_temperature.csv

Parameter	Label
YEAR		Year
MONTH		Month
DAY		Day
JULDAY		JULIAN DAY
AVE_TEMP	MEAN DAILY TEMPERATURE (DEG C)
LO_TEMP		MIN DAILY TEMPERATURE (DEG C)
HI_TEMP	M	AX DAILY TEMPERATURE (DEG C)
N_TEMP		Number of Temp observations per day
DATE		MM/DD/YYYY

vims_salinity.csv

Variable	Label
YEAR		Year
MONTH		Month
DAY		Day
JULDAY		JULIAN DAY
MEAN_SAL	MEAN DAILY SALINITY (PPT)
LO_SAL		MIN DAILY SALINITY (PPT)
HI_SAL		MAX DAILY SALINITY (PPT)
N_SAL		Number of Sal observations per day
DATE		MM/DD/YYYY



2.  Number of observations per year, 1947-2003

The following are the number of data records for each parameter by year of daily data.

Series	Year	N Temp	N Sal
1	1947	188	0
2	1948	38	0
3	1952	192	0
4	1953	247	0
5	1954	362	0
6	1955	362	0
7	1956	366	0
8	1957	365	0
9	1958	364	0
10	1959	363	0
11	1960	363	0
12	1961	364	0
13	1962	343	0
14	1963	364	0
15	1964	251	0
16	1965	363	0
17	1966	358	0
18	1967	361	0
19	1968	303	0
20	1969	335	0
21	1970	342	0
22	1971	344	54
23	1972	281	139
24	1973	365	350
25	1974	362	350
26	1975	360	313
27	1976	360	311
28	1977	357	315
29	1978	363	278
30	1979	215	0
31	1980	286	154
32	1981	327	0
33	1982	329	0
34	1983	316	0
35	1984	269	0
36	1985	317	0
37	1986	334	334
38	1987	322	304
39	1988	366	345
40	1989	323	292
41	1990	330	313
42	1991	353	353
43	1992	355	355
44	1993	364	364
45	1994	354	354
46	1995	355	348
47	1996	352	352
48	1997	362	337
49	1998	366	338
50	1999	343	346
51	2000	365	359
52	2001	359	358
53	2002	309	309
54	2003	258	258




3.  Algorithm used to calculate Salinity from Conductivity and Water Temperature 

The following algorithm was used to calculate in-situ salinity for the 6-minute Pier data starting in 1986,following the 1981 UNESCO standard per the published Practical Salinity Scale of 1978 (PSS‐
78, (Unesco (1981, 1983))).


T=TEMP;
M=COND;
P=0;
XT= T - 15.0;
R= M / 42.909;
RTE= (((0.0000000010031 * T - 0.00000069698) * T
      +0.0001104259) * T + 0.0200564) * T + 0.6766097;
A= -0.003107 * T + 0.4215;
B= (0.0004464 * T + 0.03426) * T + 1.0;
C= ((0.000000000000003989 * P - 0.0000000006370)
    * P + 0.00002070) * P;
RT= R / (RTE * (1.0 + C / (B + A * R)));
XR= SQRT(RT);
DS= (XT / (1.0 + 0.0162 * XT)) * (((((-0.0144 * XR
     + 0.0636) * XR - 0.0375) * XR - 0.0066) * XR
     - 0.0056) * XR + 0.0005);
Q= ((((2.7081 * XR - 7.0261) * XR + 14.0941) * XR
    + 25.3851) * XR - 0.1692) * XR + 0.0080;
SAL= Q + DS;