Development and evaluation of an improved TFM formulation for use in feeder stream treatments

The data for this project can be broken down into three sub-groups: TFM Pellet data, Temp data, and Water Quality data. Each subgroup and associated csv files are explained below: TFM Pellet data: The TFM Pellet dataset consists of 36 individual csv files with each file having a unique name making it representative of 1 trial of the study. For example “0.08 mps at 12C Trials rep 1.csv” would be the first replicate with a flow of 0.08 meters per second and a water temperature of 12°C. Each of the csv files has 16 columns of data. Target Temp: The target temperature of the trial Target Velocity: The target velocity (m/sec) of the trial Replicate #: The rep of the trial Actual Temp: The actual measured temp at the beginning of the trial Average Actual Velocity: The measured velocity in m/sec Average flow: The measured flow in Liters/min Average Height: The measured height of the water column (mm) Mass of TFM in Pellets: The mass of TFM (grams) in the pellets used Time Between Samples: the time in minutes between each sample Sample Name: a unique name given to each sample based on the time Time: numeric description of how many hours into the trial it has been River Conc.: TFM concentration (mg/L)provided by HPLC data TFM Released: The amount of TFM in mg released from the pellets during the previous sample time based on the River Conc. at this sample time: Total TFM Released: a cumulative amount of TFM released % TFM Used: Percent TFM that is gone from the pellets, essentially a percent recovery % recov correction: corrects for the amount of TFM used in order to have a total recovery of 100% Temp Data: This dataset consists of 3 csv files, one for each of the three temperatures in our trials. Temp 12.csv, Temp 16.csv, Temp 20.csv. Each file has a summary of recorded temps in Celcius for the 12 trials that were run at the temperature associated with the file name. There are only two columns in each file: Date_Time, and Temp. The “Date_Time” column shows the date and time the temperature was recorded. The “Temp” column shows the temperature that was recorded in degress celcius. Water Quality data: This data consists of a single csv file summary of the water quality collected during each trial. There are 11 columns in the file: Velocity: Target velocity of the trial Temperature: Target temp of the trial Replicate: rep (1-4) of each trial pre post: whether or not the data was collected at the beginning (pre) or end (post) of each trial pH: the measured pH Alk: the measured alkalinity (mg/L CaCO3) Hardness: the measured hardness (mg/L CaCO3) Flow 1: There were two flow measurements taken before each trial and two flows taken at the end of each trial. This represents the first one taken and is in L/min. Flow 2: This represents the second flow reading taken in L/min. Depth: the depth of the water column in mm Velocity: the calculated velocity of the stream in meters per second

                                            [
  "010:12"
]
                                        

                                            {
  "fn": "James A Luoma",
  "@type": "vcard:Contact",
  "hasEmail": "mailto:jluoma@usgs.gov"
}
                                        

                                            [
  {
    "@type": "dcat:Distribution",
    "title": "Digital Data",
    "format": "XML",
    "accessURL": "https://doi.org/10.5066/P928SZH8",
    "mediaType": "application/http",
    "description": "Landing page for access to the data"
  },
  {
    "@type": "dcat:Distribution",
    "title": "Original Metadata",
    "format": "XML",
    "mediaType": "text/xml",
    "description": "The metadata original format",
    "downloadURL": "https://data.usgs.gov/datacatalog/metadata/USGS.5f739bec82cef8d183995f27.xml"
  }
]
                                        

                                            [
  "Great Lakes Fishery Commission (GLFC)",
  "Invasive species",
  "Lampricide",
  "Sea Lamprey",
  "USGS:5f739bec82cef8d183995f27",
  "biota",
  "none"
]
                                        

                                            {
  "name": "U.S. Geological Survey",
  "@type": "org:Organization"
}
                                        

                                            [
  "Geospatial"
]