Appendix A : Data Catalogue
Coorong data categories
All data available for model setup and validation has been compiled, from HCHB research, prior research and routine monitoring (see Chapter 3). Data is categorised in the general areas of :
- Bathymetry
- Meteorology
- Hydrology
- Water Quality
- Sediment
- Biota
These are defined into sub-categories, as outlined in Table 9.4.
| Classification | Description |
|---|---|
| MET General | General weather data, including AT, RH, Wind, and/or Clouds |
| MET Wind | Wind data |
| MET Solar | Solar data |
| HYDRO Level | Water level data |
| HYDRO Flow | Water flow data |
| HYDRO Wave | Wave data |
| HYDRO Velocity | Velocity data, e.g. from ADV or ADCP |
| WQ Grab | WQ sample taken for laboratory analysis, e.g., nutrients |
| WQ Sensor | WQ sensor deployed at a fixed position |
| WQ Profile | WQ profiles |
| WQ Image | WQ image from satellite or remote vehicle |
| SED Grab | Data taken from a sediment core or grab |
| SED Flux | Sediment flux data, from core or bethic chamber |
| SED Profile | Sediment profile data (e.g., porewater) |
| ECO Benthic | Benthic biomass or species abundance, incl life cycle data, e.g., seagrass biomass |
| ECO Pelagic | Pelagic biomass or species abundance, incl life cycle data, e.g., phytoplankton |
| ECO Flux | Biological flux such as in situ uptake rate, e.g. photosynthesis, respiration |
| MIXED | Data is a mixture of above categories |
| UNCLASSIFIED | Data yet to be classififed |
| BATHYMETRY | Bathymetric data |
Coorong data catalogue
A summary of the available data categorised by these data types and by agency/supplier is shown below (Table 9.5). Data is accesible via the data folder of the CDM GitHub repository. Please refer to the master data catalogue spreadsheet therein for data provenance information.
| Source | Agency Code | Description | # Sites | Date Range | Contact Name | Document Title |
|---|---|---|---|---|---|---|
| BATHYMETRY | ||||||
| DEW | DEW Bathymetry | X,Y,Z survey points around Parnka Point region |
|
2021 | Matt Gibbs | bathymetry (folder) |
| DEW | DEW 2021 Contour | 25cm Contours and channel topo |
|
2021 | Matt Gibbs | Coorong_TheNeedles_SwanIsland_Bathymetry_2021 |
| DEW | DEW 2018 DEM | 2m Coorong DEM (2018) (resampled from 1m) |
|
2018 | Matt Gibbs | TOPO_DEM_COORONG_2M.tif |
| DEW | DEW MM | Murray Mouth Surveys |
|
1999 - 2019 | NA | Data not stored in CDM |
| ECO Benthic | ||||||
| T & I 2 | UA ORH | Ruppia presence/absence, Algae No/Rare/Present/Extreme | 24 (Dec 2016) or 11 (Mar 2011) | Dec-2016, Mar 2017 | Michelle Waycott | Ruppia 2016 data.xlsx |
| T & I 2 | UA DP | % cores with shoots, count of shoots | 13 | 1999-2015 every July | David Paton | Ruppia core data 1999-2015 (taken every July)_CC.xls |
| T & I 2 | UA DP | contains no actual Ruppia data, only some metadata of the above dataset (latlong etc) | 13 | 1999-2015 every July | David Paton | Research data compile (Arcmap compatible).xls |
| T & I 2 | UA HCHB | biomass (g dry weight) of seagrass, count of R.tuberosa seeds, count of R.tuberosa type I&II turions, count of Ruppia spp. flowers, count of Ruppia spp. fruit, count of seagrass shoots, count of Althenia flowers, count of R.megacarpa seeds | 97 | Sep/Oct-2020 | Michelle Waycott | 01FEB2021 Aquatic Plant seasonal sampling.xlsx (superseded by ‘seasonal sampling 20210304.xlsx’) |
| T & I 2 | UA HCHB | biomass (g dry weight) of seagrass, count of R.tuberosa seeds, count of R.tuberosa type I&II turions, count of Ruppia spp. flowers, count of Ruppia spp. fruit, count of seagrass shoots, count of Althenia flowers, count of R.megacarpa seeds, algae cover | 97 | Sep/Oct-2020 | Michelle Waycott | seasonal sampling 20210304.xlsx (superseded by ‘10Dec2021 three seasons Aquatic plant surveys.xlsx’) |
| T & I 2 | UA MDBA | count of shoots (green/brown), turions type I&II, seeds | 13 | 1998-2018 every July | Michelle Waycott or David Paton? | MDBA_Coorong_RuppiaDB.accdb |
| T & I 2 | UA MDBA | count of shoots (green/brown), turions type I&II, seeds, flowerstalk (since 2017 at some sites), % grazed, grazed length | 22 | 2007-2019 every Jan | Michelle Waycott or David Paton? | MDBA_Coorong_RuppiaDB.accdb |
| T & I 2 | UA MDBA | count of shoots (green/brown), turions (half/full), seeds, % grazed, grazed length, algae presence/absence | 8 | 42856 | David Paton | MDBA_Coorong_RuppiaDB.accdb |
| T & I 2 | UA MDBA | count of flowerhead | 9 | 42675 | David Paton | MDBA_Coorong_RuppiaDB.accdb |
| T & I 2 | UA HCHB | biomass (g dry weight) of seagrass, count of R.tuberosa seeds, count of R.tuberosa type I&II turions, count of Ruppia spp. flowers, count of Ruppia spp. fruit, count of seagrass shoots, count of Althenia flowers, count of R.megacarpa seeds, algae cover | 100 (Sep-Dec 2020) or 91 (Mar-Apr 2021) | Sep2020 - Apr2021 | Michelle Waycott | Baseline aquatic plant 4 x surveys 2020-2021_100.xlsx |
| T & I 2 | UA HCHB | NA | NA | NA | NA | 2_5_3 v1 plant phenology all fields 18Apr2022.xlsx |
| T & I 2 | UA HCHB | biomass (g dry weight) of seagrass, count of R.tuberosa seeds, count of R.tuberosa type I&II turions, count of Ruppia spp. flowers, count of Ruppia spp. fruit, count of seagrass shoots, count of Althenia flowers, count of R.megacarpa seeds, algae cover | pending | from Aug 2021 onwards | NA | pending |
| ECO Pelagic | ||||||
| T & I 2 | UA Algae | Microalgae sampling at 21 sites | 21 | 27/10/2020 - 15/06/2021 | Michelle Waycott | Component 2 Microalgae data 20220615.xlsx |
| HYDRO Flow | ||||||
| DEW | DEW Salt Creek | Salt Creek Flow | 1 | 1990 - 2021 | Claire Sims | FINAL_compiledSaltCkData_1990-2021.xlsx |
| DEW | DEW Barrage | Barrage Flow | 6 | 1990 - 2021 | Claire Sims | REVISED_FINAL_compiledBarragesData_1990-2021_Dec2021 (superseded) |
| DEW | DEW Barrage | Barrage Flow | 6 | 2011-2022 | Claire Sims | barrage_daily_total.csv |
| HYDRO Level | ||||||
| T & I 2 | UA MDBA | 4 categories of water depth (dry, waterline, 30cm, 60cm) with latlong (recorded during Ruppia survey) | 22 | 2007-2019 every Jan | Michelle Waycott or David Paton? | MDBA_Coorong_RuppiaDB.accdb |
| T & I 2 | UA MDBA | 4 categories of water depth (dry, waterline, 30cm, 60cm) with latlong (recorded during Ruppia survey) | 8 | 42856 | David Paton | MDBA_Coorong_RuppiaDB.accdb |
| DEW | DEW VH | Victor Harbor Tidal Data | 1 | 1990 - 2021 | Claire Sims | FINAL_compiledTideData_1990-2021_DatumCorrection.xlsx |
| HYDRO Velocity | ||||||
| UA | UA ADV | 3D Velocity and Amplitude at Policeman Point Boat Ramp and Villa dei Yumpa | 2 | 1/2/2021-3/2/2021 | Daniel Chilton / Justin Brookes | ADV data 1-3FEB21_formatted (folder) |
| UA | UA ADV | 3D Velocity and Amplitude at Policeman Point Boat Ramp and Villa dei Yumpa | 2 | 1/3/2021-3/3/2021 | Daniel Chilton / Justin Brookes | ADV data 1-3MAR21_formatted (folder) |
| HYDRO Wave | ||||||
| UA | UA Wave | In situ wave heights and periods | 2 | Dec 2020 & Mar 2021 | Daniel Chilton / Justin Brookes | Wave data DEC20 - MAR21.csv |
| MET General | ||||||
| DEW | DEW WDSA Met | Hourly met data (air pressure, air temp,humidity, solar rad, wind speed, wind dir) | 8 | 2010 - 2022 | NA | Data not stored in CDM: Can be downloaded via scripts_datafiles.m |
| BOM | BOM | BOM daily data | 18 Stations | 1870 - 2021 | NA | BOM/Raw (folder) |
| BOM | BOM | BARRA met product | Gridded | 2006 - 2019 | NA | Data not stored in CDM |
| NRM | NRM | NRM Narrung AWS data | 1 | 2016 - 2022 | NA | NRM/Narrung (folder) |
| MIXED | ||||||
| T & I 1 | UA Sediment | Sediment environmental conditions (TN, TP, TOC, abundance of macrobenthic fauna) | 7 | NA | Orlando | Macrobenthic_and_sediment_data_Orlando_Sabine.xlsx |
| DEW | DEW WDSA Hydro | Hourly hydro data (flow, level, water temp, conductivity, salinity,TDS) | 55 | 2010 - 2021 | NA | Data not stored in CDM: Can be downloaded via scripts_datafiles.m |
| SED Flux | ||||||
| T & I 1 | UA Sediment | Lab fluxes: O2 DOC CH4 N2O Light/dark | 4 | 44228 | Leslie Huang | Fluxes February 2021.xlsx |
| T & I 1 | UA Sediment | Cores: DGT-DET probes 15N O2 PO43- NH4+ NO3- Light/dark Net primary production Community respiration Gross primary production | 1 (5 replicates) | 44136 | Leslie Huang | Oxygen and nutrient fluxes Nov 2020 (Parnka Point).xlsx |
| SED Grab | ||||||
| T & I 1 | UA Sediment | Sediment grab % gravel to mud; 7 classes | 7 | 44317 | NA | Component 4 grain size results with GPS.xlsx |
| T & I 1 | UA Sediment | Sediment grab Moisture, pH, conductivity, TN, TOC, OM, TP | 7 | 44317 | NA | Component 4 sediment results with GPS.xlsx |
| T & I 1 | UA Sediment | Cores DGT-DET | 4 | 44228 | Leslie Huang | Coorong GHG’s (Coorong February 2021).xlsx |
| T & I 1 | UA Sediment | Grab samples 0 to 5 cm Texture, C, N, P, Mn, Fe, S | 50 | 43891 | Luke Mosley | Coorong Sediment Quality survey Mar20 Lab Results.xlsx |
| T & I 1 | UA Sediment | Grab samples 0 to 2 cm Rapid assessment | 50 | 43891 | Luke Mosley | Coorong_March_2020_final Field Results and Photos.xlsx |
| T & I 1 | UA Sediment | Lab cores: O2 sensors light/dark wet/dry weights | 4 | 44228 | Leslie Huang | sediment core information and incubation time February 2021.xlsx |
| T & I 1 | UA Sediment | Core slices: 0 to 3 cm, 3 to 10 cm, 10 to 20 cm pH TN TP TOC | 4 | 44287 | Luke Mosley | UNI012-SS-K5799 Sediment Results Feb-Mar 2021 Leslie_Luke.xlsx |
| T & I 2 | UA Sediment | sediment colour, texture, odour, score (sampled during Ruppia survey) | 85 (Mar-Apr 2021) or 14 (Aug-Nov 2021) | Mar - Nov 2021 | Michelle Waycott | Baseline aquatic plant 4 x surveys 2020-2021_100.xlsx |
| SED Profile | ||||||
| T & I 1 | UA Sediment | Cores: NH4+ PO43- Light/dark | 3 | 44136 | Leslie Huang | ammonium and phosphate data (November 2020).xlsx |
| T & I 1 | UA Sediment | Cores: Fe day/night | 4 | 44228 | Leslie Huang | Fe data (Coorong February 2021).xlsx |
| T & I 1 | UA Sediment | Cores: Fe day/night | 3 | 44136 | Leslie Huang | Fe data (November 2020).xlsx |
| T & I 1 | UA Sediment | Cores: -2.75 to 11.5 cm DET-DGT probes | 4 | 44228 | Leslie Huang | S data (Coorong February 2021).xlsx |
| T & I 1 | UA Sediment | Cores: -2.75 to 11.5 cm DET-DGT probes | 3 | 44136 | Leslie Huang | S data (November 2020).xlsx |
| UNCLASSIFIED | ||||||
| T & I 3 | FU Fish Diet | NA | NA | NA | NA | Fish diet matrix for CIIP - Figure 5 Ye et al. 2020.xlsx |
| T & I 4 | HCHB Bird Tracking | NA | NA | NA | NA | HCHB_Component4_Task4_4.4.2MovementDatabase.xlsx |
| WQ Grab | ||||||
| T & I 1 | AWQC (compiled) | Compilation of historical nutrient and chemistry data from AWQC | 16 | 1995 - 2020 | Luke Mosley | Coorong Data 1995_2020_Final.xlsx |
| T & I 1 | UA DO Light Dark | Light / Dark bottle DO grab samples at 3 locations | 3 | 44511 | Luke Mosley | Light dark bottle DO data to Matt H.xlsx |
| T & I 2 | UA DO Logger | WQ Data at 20 locations | 21 | 27/10/2020 - 15/06/2021 | Michelle Waycott | Component 2 Water quality data 20220615.xlsx |
| T & I 2 | UA Nutrients | Nutrent Grab samples | 21 | 30/09/2020 - 05/01/2022 | Michelle Waycott | Component 2 Nutrients 20220601.xlsx |
| T & I 2 | UA Nutrients | Historical 2017 Survey results | 1 | Dec-2016, Mar 2017 | Michelle Waycott | OCRH 2017 survery results nutrients.xlsx |
| T & I 2 | UA ORH | salinity, water depth (sampled during Ruppia survey) | 25 (Dec 2016) or 11 (Mar 2011) | Dec-2016, Mar 2017 | Michelle Waycott | Ruppia 2016 data.xlsx |
| T & I 2 | UA HCHB WQ | salinity, water depth (sampled during Ruppia survey) | 93 | Sep/Oct-2020 | Michelle Waycott | seasonal sampling 20210304.xlsx (superseded by ‘10Dec2021 three seasons Aquatic plant surveys.xlsx’) |
| T & I 2 | UA HCHB WQ | salinity, water depth (sampled during Ruppia survey) | 102 (Sep-Dec 2020) or 42 (Mar-Apr 2021) or 87 (Aug-Nov 2021) | Sep2020 - Nov2021 | Michelle Waycott | Baseline aquatic plant 4 x surveys 2020-2021_100.xlsx |
| T & I 3 | FU TLM | NA | NA | NA | NA | TLM water quality data and chl.xlsx |
| DEW | ALS | Nutrient and chemistry data from ALS | 19 | 2020 - 2021 | Matt Gibbs | ALS Results (folder) |
| DEW | AWQC (DEW) | Nutrient and chemistry data from AWQC | 15 | 2020 | Matt Gibbs | AWQC Results (folder) |
| DEW | ALS BGA | BGA Cell Count and Biomass data from ALS | 19 | 2020 - 2021 | Matt Gibbs | ALS Results (folder) |
| UA | UA Grab | 2 hourly Villa dei Yumpa Grab Samples | 1 | 01/03/2021 - 03/03/3021 | NA | Goyder_nutrients_shared_data_VDY1-3MAR21_2-hourly.csv |
| SAWater | SAWater | River Murray WQ Grab samples, Lock 6 to Goolwa | 20 | 2019 - 2021 | NA | River Murray Water Quality Data - Brendan Busch.xlsx |
| WQ Profile | ||||||
| DEW | DEW Profile | Monthly profile campaigns | 20 | 2018 - 2021 | NA | Field results spreadsheet (folder) |
| WQ Sensor | ||||||
| T & I 1 | UA Logger | Temperature logger in CSL | 3 | 10/2019 - 03/2020 | Michelle Waycott | All HOBO temperature data to March 2020.xlsx |
| T & I 2 | UA DO Logger | DO Logger at North McGrath Flats | 1 | 22/09/2021 - 11/11/2021 | Michelle Waycott | Logger_1.csv |
| T & I 2 | UA DO Logger | DO Logger at Salt Creek | 1 | 22/09/2021 - 11/11/2021 | Michelle Waycott | Logger_2.csv |
| T & I 2 | UA DO Logger | Temp & Light data | 8 | 03/10/2019 - 19/01/2022 | Michelle Waycott | Component 2 on site Temp and Light Logger Data June 2022.xlsx |
| DEW | DEW Profile | Conductivity and Temperature Profile Campaigns |
|
2019 - 2020 | Matt Gibbs | EC Profile Data (folder) |
| DEW | DEW WDSA Sonde | Hourly WQ data (pH, Turbidity, TChla, Oxygen conc., Oxygen Sat., BGA, fDom) | 13 | 2010 - 2022 | NA | Data not stored in CDM: Can be downloaded via scripts_datafiles.m |
| UA | UA LISST | In situ particle size data collected by the LISST profiler | 2 | Dec 2020 & Mar 2021 | Daniel Chilton / Justin Brookes | Merged LISST data DEC20 - MAR21.csv |
| UA | UA Sonde | Sonde measurments and grab samples at Policeman Point Boat Ramp and Villa dei Yumpa | 3 | Dec 2020 & Mar 2021 | NA | Water Quality data_DEC20-MAR21.xlsx |