Plum Island Ecosystems LTER Database

Acceptance and utilization of LTER data requires that:

(1) The Principal Investigator be sent a notice stating reasons for acquiring any data and a description of the publication intentions.
(2) The Principal Investigator of the data set be sent a copy of the report or manuscript prior to submission and be adequately cited in any resultant publications.
(3) A copy of any resultant publications should be sent to:

Principal Investigator
Ecosystems Center
Marine Biological Laboratory
7 MBL St.
Woods Hole, MA 02543

Dataset URLs:METADATA: HTML, Rich Text, XML(EML compliant)
DATA: Comma Delimited, Excel file with Metadata and data
Dataset ID:WAT-IP-HistoricalNitrogenBudget.04
Dataset Title:Annual estimates of nitrogen loading to the Ipswich River Watershed, 1931 - 2014.
Investigator 1: 
First Name:Wilfred
Last Name:Wollheim
Address line 1:Morse Hall
Address line 2:UNH
Address line 3:
City:Durham
State:NH
Zip Code:03824
Country:USA
Associate Investigators:Nat Morse
Keywords:PIE LTER, Ipswich River, disturbance, nutrients, nitrogen, fertilizer, atmospheric deposition, food, waste, sewer, export
Abstract:The nitrogen budget of the Ipswich River watershed was reconstructed to explore trends over time, 1931 to 2014, in gross N inputs, net N inputs, riverine exports.Various sources were used to reconstruct major N budget terms for atmospheric deposition, fertilizer, food imports, sewage N exports, riverine N exports.
Contact: Plum Island Ecosystems LTER Information Manager
The Ecosystems Center
Marine Biological Lab
7 MBL St
Woods Hole, MA 02543
Phone (508) 289 7485
Email: pie_im@mbl.edu
Online URL: http://pie-lter.ecosystems.mbl.edu
DATA FILE INFORMATION:
Data File URL http://ecosystems.mbl.edu/PIE/data/WAT/data/WAT-IP-HistoricalNitrogenBudget.csv
Data File Name WAT-IP-HistoricalNitrogenBudget
Beginning Date 1/1/1931
End Date 12/31/2014
Number of Data Records 84
Other Files to Reference
Availability Status Type 1
Quality Control Information
Maintenance Description On-going study, data continue to be added/updated
Log of Changes: Version 01, 23Mar2012, data and metadata update. Used MarcrosExportEML_HTML (working)pie_excel2007.xlsm 3/23/2012 12:08 PM for QA/QC to EML 2.1.0
Version 02: April 18, 2013, data and metadata updated to comply with importation to Drupal and LTER PASTA. Research location name and description checked updated.Used MarcrosExportEML_HTML (working)pie_excel2007.xlsm 3/14/13 12:02 PM for QA/QC to EML 2.1.0
Version 04: February 29, 2016, updated data and edited metadata through 2014 to comply with importation to Drupal and LTER PASTA. Used MarcrosExportEML_HTML (working)pie_excel2007_Jan2015.xlsm 1/15/15 4:26 PM for QA/QC to EML 2.1.0
Version 05: February 29, 2016, title update, updated data and edited metadata through 2014 to comply with importation to Drupal and LTER PASTA. Used MarcrosExportEML_HTML (working)pie_excel2007_Jan2015.xlsm 1/15/15 4:26 PM for QA/QC to EML 2.1.0
 
RESEARCH LOCATION: MON-PIE-Site Site 2
Geographic Description PIE LTER research site including watersheds and estuary, Essex and Middlesex Counties, MA  
Location Bounding Box    
West Bounding Coordinate -71.22  
East Bounding Coordinate -70.75  
North Bounding Coordinate 42.83  
South Bounding Coordinate 42.5  
OR if single point location    
Latitude    
Longitude    
Elevation    
     
     
 
TAXONOMIC COVERAGE:
Taxonomic Protocols
Organisms studied
 
Methods:Atmospheric deposition estimates prior to the period of NADP wet deposition estimates (<1982) use the model of Bowen and Valiela (2001) (N deposition = Year * 0.026 - 39.4). From 1982 to 2014, we use wet deposition estimates from NADP, and the model of Bowen and Valiela to derive estimates of dry deposition and DON deposition (where DON is 0.24 of total deposition, and wet and dry deposition are each 50% of the remainder). Wet deposition data came from the NADP Lexington, MA site for 1982 to 2008 and from the NADP Franklin, MA site for 2009 to 2014 (the site at Lexington MA was discontinued in 2010).

Gross imports in food = Population in Ipswich * 4.8 kg/person/year.

Fertilizer inputs are from Ruddy et al. 2004 and Battaglin (county level data from 1945 to 2001), scaled to proportion of Ipswich in Middlesex and Essex county MA. Fertilizer estimates for prior to 1945 assumethe decay function derived from Vadeboucour et al. 2010. Due to missing county level data, N inputs to the watershed cannot be updated for 2009 to 2014.


Human waste N export is assumed to occur for population on sewer systems (all waste water treatment plants are outside the basin boundaries). Proportion of the population on sewer systems is based on data from Claessens et al. 2006.

Net Food N inputs are Gross imports - Sewered Exports.

Riverine N exports are based on the PIE LTER long term nitrogen database. The USGS Load Estimator program LOADEST was applied to the monthly grab sample data over the perriod of record to predict daily nitrogen flux from 1993 to 2008. For 2009 to 2014, riverine N exports are estimated as the annual flow-weighted mean multiplied by total yearly discharge.

Runoff is derived from th USGS gage at Ipswich period of record from 1934 to present.

N in water diversions uses net interbasin transfers of water from Claessens et al. 2006, and assumes concentration as at the mouth of watershed used to calculate riverine N exports.


Bowen, J.L. and Valiela, I. 2001. The ecological effects of urbanization of coastal watersheds:Historical increases in nitrogen loads and eutrophication of Waquoit Bay estuaries. Canadien Journal of Fisheries and Aquatic Sciences. 58, 1489-1500.

Claessens, L., C. Hopkinson, E. Rastetter, and J. Vallino. 2006. Effect of historical changes in land use and climate on the water budget of an urbanizing watershed. Water Resources Research 42:W03426.

Data Table

Variable Name Variable Description Units Measurement Scale Code Information Number Type DateTime Format Missing Value Code Missing Value Code Explanation
Year year   datetime     YYYY NA NA = data are not available
Runoff mean annual runoff millimeterPerYear ratio   real   NA NA = data are not available
AtmosphericDeposition total annual wet and dry deposition kilogramPerKilometerSquaredPerYear ratio   real   NA NA = data are not available
GrossFoodN total annual gross food N imports kilogramPerKilometerSquaredPerYear ratio   real   NA NA = data are not available
FertilizerN total annual fertilizer N inputs kilogramPerKilometerSquaredPerYear ratio   real   NA NA = data are not available
SewerNExport total annual sewer N exports kilogramPerKilometerSquaredPerYear ratio   real   NA NA = data are not available
NetNInput net total annual N inputs kilogramPerKilometerSquaredPerYear ratio   real   NA NA = data are not available
Nexport total annual riverine TDN exports kilogramPerKilometerSquaredPerYear ratio   real   NA NA = data are not available
NinWaterDiversion total annual TDN exports in water diversions kilogramPerKilometerSquaredPerYear ratio   real   NA NA = data are not available