Environmental Data Initiative logo
EDI Staging Environment

Data Package Metadata   View Summary

Baltimore Ecosystem Study: Code for calculations of annual pharmaceutical loads at Gwynns Falls Carroll Park

General Information
Data Package:
Local Identifier:knb-lter-bes.5014.1
Title:Baltimore Ecosystem Study: Code for calculations of annual pharmaceutical loads at Gwynns Falls Carroll Park
Alternate Identifier:DOI PLACE HOLDER
Abstract:

Code for analyses presented in: Fork, M.L., J. Fick, A.J. Reisinger, and E.J. Rosi. "Dosing the coast: Leaking sewage infrastructure delivers large annual loads and dynamic mixtures of pharmaceuticals to urban rivers." In press at Environmental Science and Technology.

Two markdown files contains code to pre-process other data and to analyze grab samples from BES streams collected weekly from 2 Nov 2017 through 15 Nov 2018 and analyzed for 92 target pharmaceuticals. Data and methods are available via EDI at https://doi.org/10.6073/pasta/36453abc14ce8d6a33711231fdee9792.

Briefly, the analyses here: A) examine spatial and temporal variability in pharmaceutical detections and concentrations among 7 BES watersheds, and B) combine measured concentrations at the watershed outlet (GFCP) with USGS streamflow data to estimate annual loads of pharmaceuticals by resampling or by interpolating concentrations over the discharge record.

Publication Date:2021-07-29

Time Period
Begin:
2017-11-02
End:
2018-11-15

People and Organizations
Contact:Cary Institute of Ecosystem Studies [  email ]
Contact:Fork, Megan (Cary Institute of Ecosystem Studies) [  email ]
Creator:Fork, Megan (Cary Institute of Ecosystem Studies)

Data Entities
Other Name:
"Data prep for pharmaceutical analysis"
Description:
prepares input data files from BES and other publicly available data (sources are listed in code) for BESPharmaAnalyses.Rmd
Other Name:
"BES pharmaceutical analysis and loads"
Description:
provides code for analysis of pharmaceutical data, including calculation of annual load at GFCP, and figures associated with Fork et al. 2021 Env. Sci. Tech.
Detailed Metadata

Data Entities

Non-Categorized Data Resource

Name:"Data prep for pharmaceutical analysis"
Entity Type:unknown
Description:prepares input data files from BES and other publicly available data (sources are listed in code) for BESPharmaAnalyses.Rmd
Physical Structure Description:
Object Name:DataPrepForPharmaAnalyses.Rmd
Size:5407 bytes
Authentication:9f555e402c4eeda05ccaf78b91325b9b Calculated By MD5
Externally Defined Format:
Format Name:text/x-markdown
Data:https://pasta-s.lternet.edu/package/data/eml/knb-lter-bes/5014/1/8e2bc16f57256e868b030ca63ad4ee3a

Non-Categorized Data Resource

Name:"BES pharmaceutical analysis and loads"
Entity Type:unknown
Description:provides code for analysis of pharmaceutical data, including calculation of annual load at GFCP, and figures associated with Fork et al. 2021 Env. Sci. Tech.
Physical Structure Description:
Object Name:BESPharmaAnalyses.Rmd
Size:56378 bytes
Authentication:93efd398fa12de4404c2df8dea5d5dce Calculated By MD5
Externally Defined Format:
Format Name:text/x-markdown
Data:https://pasta-s.lternet.edu/package/data/eml/knb-lter-bes/5014/1/8bf0d1bc0fa41aee06122ad43112ab52

Data Package Usage Rights

This information is released under the Creative Commons license - Attribution - CC BY (https://creativecommons.org/licenses/by/4.0/). The consumer of these data ("Data User" herein) is required to cite it appropriately in any publication that results from its use. The Data User should realize that these data may be actively used by others for ongoing research and that coordination may be necessary to prevent duplicate publication. The Data User is urged to contact the authors of these data if any questions about methodology or results occur. Where appropriate, the Data User is encouraged to consider collaboration or co-authorship with the authors. The Data User should realize that misinterpretation of data may occur if used out of context of the original study. While substantial efforts are made to ensure the accuracy of data and associated documentation, complete accuracy of data sets cannot be guaranteed. All data are made available "as is." The Data User should be aware, however, that data are updated periodically and it is the responsibility of the Data User to check for new versions of the data. The data authors and the repository where these data were obtained shall not be liable for damages resulting from any use or misinterpretation of the data. Thank you.

Keywords

By Thesaurus:
BES VocabularyBaltimore, MD, Maryland, Baltimore Ecosystem Study, BES, LTER, pharmaceutical
LTER Controlled Vocabularywatersheds, urban, water chemistry, pollution, streams
National Research & Development TaxonomyEcology, Ecosystems, & Environment, Environment and People , Urban natural resources management
ISO 19115 Topic Categoryenvironment

Methods and Protocols

These methods, instrumentation and/or protocols apply to all data in this dataset:

Methods and protocols used in the collection of this data package
Description:

We estimated the total annual load of pharmaceuticals (November 2017 - November 2018) at GFCP by multiplying concentrations of detected pharmaceuticals by the streamflow (Q) reported by the U.S. Geological Survey (station number 01589352).

Because many samples had concentrations of individual pharmaceuticals below the methodological limit of quantification (LoQ), the length of our record was only one year, and we did not observe strong relationships between concentration and Q, we used a portfolio of approaches to calculate total annual loads. First, we used two methods to estimate the concentration for samples in which pharmaceutical concentration was below the LoQ: 1) set all values <LoQ to 0 ng L-1, or 2) set all values to 0.5*LoQ for the given pharmaceutical. We combined this fully-factorially with two interpolation methods for estimating concentration of pharmaceuticals for Q observations occurring between weekly water sampling observations: A) linear interpolation of concentrations between samples and B) randomly sampling with replacement from the observed population of concentrations for each Q observation between samples (10,000 iterations). We then summed over the year of record to obtain four estimates for total annual load for each pharmaceutical.

People and Organizations

Publishers:
Organization:Environmental Data Initiative
Email Address:
info@environmentaldatainitiative.org
Web Address:
https://environmentaldatainitiative.org
Creators:
Individual: Megan Fork
Organization:Cary Institute of Ecosystem Studies
Email Address:
forkm@caryinstitute.org
Id:https://orcid.org/0000-0002-7789-3316
Contacts:
Organization:Cary Institute of Ecosystem Studies
Email Address:
besim@caryinstitute.org
Individual: Megan Fork
Organization:Cary Institute of Ecosystem Studies
Email Address:
forkm@caryinstitute.org

Temporal, Geographic and Taxonomic Coverage

Temporal, Geographic and/or Taxonomic information that applies to all data in this dataset:

Time Period
Begin:
2017-11-02
End:
2018-11-15
Geographic Region:
Description:Gwynns Falls watershed in Baltimore City and County and Pond Branch/Baisman Run in Baltimore County
Bounding Coordinates:
Northern:  39.4907Southern:  39.27511
Western:  -76.84181Eastern:  -76.64305
Sampling Site: 
Description:GFCP Sampling Site
Site Coordinates:
Longitude (degree): -76.649Latitude (degree): 39.2715

Project

Parent Project Information:

Title:Dynamic heterogeneity: Investigating causes and consequences of ecological change in the Baltimore urban ecosystem
Personnel:
Individual: Emma Rosi
Organization:Cary Institute of Ecosystem Studies
Email Address:
rosie@caryinstitute.org
Id:https://orcid.org/0000-0002-3476-6368
Role:Principal Investigator
Funding: NSF 1637661
Related Project:
Title:Baltimore Ecosystem Study: Synthesis of long-term studies of how multiple human and biophysical factors interact to drive ecological change of an urban ecosystem
Personnel:
Individual: Emma Rosi
Organization:Cary Institute of Ecosystem Studies
Email Address:
rosie@caryinstitute.org
Id:https://orcid.org/0000-0002-3476-6368
Role:Principal Investigator
Funding: NSF 1855277

Maintenance

Maintenance:
Description:complete
Frequency:
Other Metadata

Copyright 2024 Environmental Data Initiative. This material is based upon work supported by the National Science Foundation under grants #2223103 and #2223104. Any opinions, findings, conclusions, or recommendations expressed in the material are those of the author(s) and do not necessarily reflect the views of the National Science Foundation. Please contact us with questions, comments, or for technical assistance regarding this web site or the Environmental Data Initiative. Please read our privacy policy to know what information we collect about you and to understand your privacy rights.

EDI is a collaboration between the University of New Mexico and the University of Wisconsin – Madison, Center for Limnology:

UNM logo UW-M logo