ROcD-nGoM: A River-Ocean Coupled Database for the Northern Gulf of Mexico

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. <strong>Table 1 River Parameter Summary</strong> <strong>Parameter</strong> <strong>Fraction</strong> <strong>Time Range</strong> <strong>Number of ConcAve Observations</strong> <strong>Number of ConcDay Observations</strong> 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 <strong>Table 3 Ocean Parameter Summary</strong> 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