read.obs: Read field observation data

In DEQrmichie/heatsourcetools: Heat Source Model Post Processing Tools

Read field observation data

Description

Read a .xlsx workbook formatted with field observation data. The workbook is setup using a similar format as DEQ's AWQMS data submission templates.

Usage

read.obs(obs_dir, file_name)

Arguments

obs_dir	The path to directory where observation data .xlsx file is located.
file_name	The name of the observation data .xlsx file.

Details

The workbook must contain two worksheets named:

• Monitoring_Locations

• Results

And an optional worksheet for TIR data named:

• TIR

The worksheets must contain the columns identified in the lists below. Additional columns can be included but will not be used by the function.

Required 'Monitoring_Locations' worksheet columns

• Monitoring.Location.ID: Character value of the monitoring location ID.

• GNIS_Name: Character name of the waterbody.

• model_km: Numeric model stream kilometer corresponding to the location of the monitoring site

Required 'Results' worksheet columns:

• Monitoring.Location.ID: Character value of the monitoring location ID.

• Activity.Start.Date: Date of sample. Formatted as an excel date in the format 'YYYY/MM/DD'.

• Activity.Start.Time: Time of sample. Formatted as an excel date in the format 'HH24:MM'.

• Activity.Start.End.Time.Zone: Character timezone (e.g. PDT or PST).

• Characteristic.Name: Characteristic name used in AWQMS. (e.g. 'Temperature, water', 'Flow')

• Result.Value: Measured characteristic result value.

• Result.Unit: Units for measured characteristic result. Same as what is used in AWQMS. (e.g. 'deg C', 'm3/sec', 'm')

Required 'TIR' worksheet columns:

• Monitoring.Location.ID: Character value of the monitoring location ID.

• model_km: Numeric model stream kilometer corresponding to the location of the monitoring site

• Activity.Start.Date: Date of sample. Formatted as an excel date in the format 'YYYY/MM/DD'.

• Activity.Start.Time: Time of sample. Formatted as an excel date in the format 'HH24:MM'.

• Activity.Start.End.Time.Zone: Character timezone (e.g. PDT or PST).

• Characteristic.Name: Characteristic name used in AWQMS. (e.g. 'Temperature, water', 'Flow')

• Result.Value: Measured characteristic result value.

• Result.Unit: Units for measured characteristic result. Same as what is used in AWQMS. (e.g. 'deg C', 'm3/sec', 'm')

DEQrmichie/heatsourcetools documentation built on Jan. 25, 2025, 2:31 p.m.