Function to read and format water quality data obtained from the WIR water portal for use in annual reporting for the Swan River

swan_WIN_report_data reads in all xlsx downloaded files from WIR and based on a reporting year, formats the data for use in generating the annual report.

Usage

swan_WIN_report_data(inpath, reportingYear = 2019, outpath)

Arguments

inpath

character filepath to the downloaded data xlsx files.

reportingYear

4 digit numerical representing current reporting year.

outpath

character filepath to desired export location.

Value

a csv export named SG-E-SWANEST_annual_report_data_for_YYYY.

Details

Original source data must be downloaded from http://wir.water.wa.gov.au/Pages/Water-Information-Reporting.aspx using the keyword "SG-E-SWANEST" and requesting "Water Quality (discrete) for Site(s) cross-tabulated". These datasets are then read in and reformatted for ease of use in the annual report.

Author

Bart Huntley, bart.huntley@dbca.wa.gov.au

For more details see https://dbca-wa.github.io/rivRmon/index.html the rivRmon website

Examples

if (FALSE) { # \dontrun{
swan_WIN_report_data(inpath, reportYear = 2019, outpath)} # }