ROcD-nGoM: A River-Ocean Coupled Database for the Northern Gulf of Mexico
Description
This is a River-Ocean Coupled Database for the Northern Gulf of Mexico. This database contains river chemistry and discharge (Q) data for 54 rivers, streams, and bayous entering the nGoM. It has both the raw observations (ConcAve) as well as a daily concentration (ConcDay) and flux estimations from the USGS WRTDS model. The database also contains 17 chemical and physical ocean parameters from the Gulf of Mexico Coastal Ocean Observing System (GCOOS) and the MODIS and seaWiFS satellite sensors.
The data is provided in two formats: (1) raw with outlier flags and (2) cleaned and time averaged. The raw format provides the daily concentrations of the USGS and GCOOS data and monthly data for the satellite product. There are two outlier flags for parameters which indicate if the value is in the 0.5 percentile of high or low concentrations of all the data. They are called “outlier_99.5” for the 0.5% of data on the high end of the distribution and “outlier_0.05” for the 0.5% of the data on the low end of the distribution. The USGS river data has outlier flags for “ConcAve”, “ConcDay”, and “Q”. The ConcDay range designation is defined by the distribution of the actual raw measurements (ConcAve). The ocean data has outlier flags for each parameter except wind/current direction. The time averaged format includes monthly, seasonal, and yearly values of all the parameters. These values are calculated following the removal of the outliers in the raw data.
Table 1 River Parameter Summary
|
Parameter |
Fraction |
Time Range |
Number of ConcAve Observations |
Number of ConcDay Observations |
|
Temperature, water |
None |
1939-2021 |
12,034 |
780,448 |
|
Temperature, air |
None |
1969-2021 |
1,265 |
118,709 |
|
Oxygen |
Dissolved |
1965-2021 |
9,867 |
664,441 |
|
H ion |
Total |
1939-2021 |
14,985 |
784,763 |
|
Alkalinity |
Combined |
1931-2021 |
13,046 |
678,341 |
|
Carbon |
Total |
1971-1978 |
122 |
6,335 |
|
Carbon |
Suspended |
1966-2021 |
1,323 |
94,892 |
|
Organic carbon |
Total |
1968-2021 |
7,917 |
711,198 |
|
Organic carbon |
Dissolved |
1966-2021 |
2,880 |
266,522 |
|
Organic carbon |
Suspended |
1966-2021 |
1,555 |
159,132 |
|
Inorganic carbon |
Total |
1971-1978 |
67 |
3,550 |
|
Inorganic carbon |
Dissolved |
2018-2021 |
57 |
1,243 |
|
Inorganic carbon |
Suspended |
1969-2021 |
1,952 |
135,448 |
|
Carbon dioxide |
Dissolved |
1944-2021 |
13,563 |
671,243 |
|
Bicarbonate |
Total |
1931-2021 |
14,924 |
729,840 |
|
Bicarbonate |
Dissolved |
1966-2021 |
2,233 |
155,438 |
|
Carbonate |
Dissolved |
1966-2021 |
351 |
26,561 |
|
Mixed nitrogen |
Total |
1966-2021 |
14,308 |
943,673 |
|
Mixed nitrogen |
Dissolved |
1966-2021 |
2,488 |
234,288 |
|
Organic nitrogen |
Total |
1966-2021 |
16,083 |
1,051,439 |
|
Organic nitrogen |
Dissolved |
1966-2021 |
2,430 |
229,907 |
|
Nitrate + Nitrite |
Total |
1966-2021 |
7,882 |
585,068 |
|
Nitrate + Nitrite |
Dissolved |
1966-2021 |
4,451 |
326,492 |
|
Kjeldahl nitrogen |
Total |
1966-2021 |
21,391 |
1,271,620 |
|
Kjeldahl nitrogen |
Dissolved |
1966-2021 |
6,107 |
403,969 |
|
Kjeldahl nitrogen |
Suspended |
1979-1981 |
22 |
940 |
|
Ammonia + Ammonium |
Total |
1966-2021 |
8,651 |
663,683 |
|
Ammonia + Ammonium |
Dissolved |
1966-2021 |
4,705 |
489,685 |
|
Nitrate |
Total |
1950-2021 |
5,850 |
390,608 |
|
Nitrate |
Dissolved |
1931-2021 |
9,952 |
841,209 |
|
Nitrite |
Total |
1966-2021 |
4,934 |
445,358 |
|
Nitrite |
Dissolved |
1939-2021 |
3,393 |
339,303 |
|
Phosphorus |
Total |
1966-2021 |
16,184 |
994,499 |
|
Phosphorus |
Dissolved |
1966-2021 |
6,445 |
415,793 |
|
Orthophosphate |
Total |
1963-2021 |
3,117 |
273,300 |
|
Orthophosphate |
Dissolved |
1939-2021 |
7,070 |
538,502 |
|
Silica |
Dissolved |
1944-2021 |
13,392 |
681,384 |
|
Calcium |
Dissolved |
1931-2021 |
13,458 |
665,822 |
|
Magnesium |
Dissolved |
1944-2021 |
13,789 |
678,403 |
|
Sodium |
Dissolved |
1950-2021 |
12,041 |
654,578 |
|
Potassium |
Dissolved |
1950-2021 |
10,198 |
636,726 |
|
Chloride |
Dissolved |
1931-2021 |
15,142 |
713,021 |
|
Sulfate |
Dissolved |
1931-2021 |
14,788 |
727,231 |
|
Iron |
Total |
1952-1973 |
644 |
30,808 |
|
Iron |
Dissolved |
1950-2021 |
14,912 |
1,236,904 |
|
Iron |
Recoverable |
1969-2021 |
1076 |
188.961 |
|
Lead |
Suspended |
1969-2021 |
471 |
115,614 |
|
Lead |
Recoverable |
1969-2016 |
173 |
38,538 |
|
Aluminum |
Dissolved |
1963-2021 |
897 |
131,097 |
|
Fluoride |
Dissolved |
1939-2021 |
11,415 |
624,546 |
|
Arsenic |
Total |
1969-2021 |
1,220 |
119,746 |
|
Arsenic |
Dissolved |
1966-2021 |
8,006 |
697,097 |
|
Arsenic |
Suspended |
1969-2021 |
322 |
57,834 |
|
Boron |
Dissolved |
1966-2021 |
1,355 |
96,100 |
|
Selenium |
Total |
1969-2021 |
156 |
44,090 |
|
Selenium |
Dissolved |
1966-2021 |
1,283 |
146,183 |
Table 3 Ocean Parameter Summary
|
Parameter |
Source |
Time range |
Number of observations |
|
Chlorophyll |
GCOOS |
1972-2021 |
48,333 |
|
Chlorophyll |
MODIS |
2002-2021 |
9,826,629 |
|
Chlorophyll |
seaWiFS |
1997-2010 |
1,724,074 |
|
Oxygen |
GCOOS |
1922-2021 |
396,270 |
|
Phosphorus |
GCOOS |
1968-2014 |
28,917 |
|
Nitrogen |
GCOOS |
1969-2013 |
931 |
|
Nitrate |
GCOOS |
1972-2014 |
14,277 |
|
Nitrite |
GCOOS |
1968-2014 |
9,929 |
|
Nitrate + Nitrite |
GCOOS |
1969-2014 |
4,289 |
|
Wave |
GCOOS |
2008-2019 |
819,601 |
|
Turbidity |
GCOOS |
2008-2021 |
48,006 |
|
Sea surface height |
GCOOS |
2008-2019 |
206,607 |
|
Wind |
GCOOS |
2001-2021 |
365,600 |
|
Current |
GCOOS |
1995-2021 |
69,004 |
|
Temperature |
GCOOS |
1956-2021 |
369,913 |
|
pH |
GCOOS |
1962-2014 |
398,085 |
|
Salinity |
GCOOS |
1922-2021 |
338,261 |