Water discharge rates at SAFE Project experimental streams

Description:
Data for calculating stream discharge in SAFE's experimental rivers
Project: This dataset was collected as part of the following SAFE research project: Effects of retaining riparian forest zones of differing width on stream hydrology following conversion to oil palm
XML metadata: GEMINI compliant metadata for this dataset is available here
Files: This consists of 1 file: Template_hydro.xlsx
Template_hydro.xlsx
This file contains dataset metadata and 4 data tables:

Stream level data for estimating discharge (described in worksheet StreamLevels)
Description: Five-minute recordings of stream height
Each recording has 10 separate values
Number of fields: 14
Number of data rows: 141659
Fields:

Site: Site of datalogger (Field type: location)
Datetime: Date and time of measurement (Field type: datetime)
Distance1: Distance between datalogger and water surface (Field type: numeric)
Distance2: Distance between datalogger and water surface (Field type: numeric)
Distance3: Distance between datalogger and water surface (Field type: numeric)
Distance4: Distance between datalogger and water surface (Field type: numeric)
Distance5: Distance between datalogger and water surface (Field type: numeric)
Distance6: Distance between datalogger and water surface (Field type: numeric)
Distance7: Distance between datalogger and water surface (Field type: numeric)
Distance8: Distance between datalogger and water surface (Field type: numeric)
Distance9: Distance between datalogger and water surface (Field type: numeric)
Distance10: Distance between datalogger and water surface (Field type: numeric)
LoggerBattery: Battery level of the datalogger; max = 4.20V (Field type: numeric)
LoggerTemp: Temperature of the datalogger (Field type: numeric)

Salt dilution experiments to estimate discharge rates (described in worksheet SaltDilution)
Description: Salt dilution experiments to estimate discharge rates.
Experiments were repeated at each stream on multiple dates.
Salt was added 2.5 minutes into each experiment.
Details about sites and conditions relating to the experiments are in the 'SaltDilutionMeta' worksheet.
Number of fields: 6
Number of data rows: 14620
Fields:

Site: SAFE stream where dilution was carried out (Field type: location)
Date: Date of dilution experiment (Field type: date)
Treatment: Was salt added or not? (Field type: categorical)
Time: Time since measurements began (Field type: numeric)
Conductivity: Conductivity (Field type: numeric)
SaltConc: Salt concentration (Field type: numeric)

Calibration for salt dilution experiment (described in worksheet SaltDilutionCalib)
Description: Calibrating salt concentration to conductivity measuments for salt dilution gauging
Number of fields: 3
Number of data rows: 8
Fields:

Concentration: Salt concentration (Field type: numeric)
Conductivity: Conductivity (Field type: numeric)
Temp: Water temperature (Field type: numeric)

Salt dilution experiment metadata (described in worksheet SaltDilutionMeta)
Description: Metadata giving context for salt dilution experiment data in 'SaltDilution' worksheet
Number of fields: 16
Number of data rows: 23
Fields:

Site: Stream on which salt dilution took place (Field type: location)
Date: Date experiment was conducted (Field type: date)
Treatment: Was salt added or not? (Field type: categorical)
SaltAmount: Amount of salt added (Field type: numeric)
Start: Start time (Field type: time)
End: End time (Field type: time)
InitConducRelease: Conductivity at start of experiment at location where salt was poured in (Field type: numeric)
InitConducRecord: Conductivity at start of experiment at location where measurements were recorded (Field type: numeric)
EndConducRelease: Conductivity at end of experiment at location where salt was poured in (Field type: numeric)
EndConducRecord: Conductivity at end of experiment at location where measurements were recorded (Field type: numeric)
ReleaseLat: Latitude of location where salt was released (Field type: numeric)
ReleaseLong: Longitude of location where salt was released (Field type: numeric)
RecordLat: Latitude of location where conductivity was recorded (Field type: numeric)
RecordLong: Longitude of location where conductivity was recorded (Field type: numeric)
Distance between poured and measured (m): Distance between location where salt was released and conductivity was recorded (Field type: numeric)
Video: Link to video of conductivity metre (Field type: id)
Date range: 2019-01-24 to 2019-07-01
Latitudinal extent: 4.6498 to 4.7317
Longitudinal extent: 117.5413 to 117.6233