Author:  Barclay, Janet Rice
Title: Field Data from Cornell’s Teaching and Research Farm
Type: Dataset
Language: English
Subject Keywords: Harford Farm, T&R Farm, NO3, Cl, DOC, dN15, dO18, Soil Organic Matter, Isotopes
Abstract: This data set contains field data from the Cornell Teaching and Research Farm in Harford, NY during the period of April 25, 2012 to November 27, 2012.  Locations.csv describes the well / field point / stream locations.  FieldData.csv describes the conditions measured at the locations on each field visit.  Samples.csv describes the water and soil samples that were collected.  Analysis.csv lists the analytical analyses that were performed on the water samples.  Results.csv gives the results of the Analyses.  SM.csv lists the soil moisture (Volumetric Water Content) that was measured in the field.  Soil.csv reports the results of the soil analysis.
Sponsors: Partial funding for this project was awarded by an NSF-IGERT traineeship (Cross-scale Biogeochemistry and Climate) and a grant funded by Federal Formula Funds distributed through the New York State Agricultural Experiment Station.  
Spatial Extent: 4701261 N to 4695291 N, 395197 E to 400287 E, UTM Zone 18
Temporal Extent: 2012-04-25 to 2012-11-27
No Data Indicator: “----“

1. Locations.csv, descriptions of the sampling locations (wells, field & stream points)
1.1. Column “Location_ID”, a unique location identifier
1.2. Column “Lat”, site latitude, decimal degrees
1.3. Column “Long”, site longitude, decimal degrees
1.4. Column “Projected_Y”, site northing, m, UTM zone 18N
1.5. Column “Projected_X”, site easting, m, UTM zone 18N
1.6. Column “LandCover”, landcover at the site
1.7. Column “Type”, site type (well, mini-piezometer=50cm depth, stream, point)
2. FieldData.csv, descriptions of the data measured in the field during each field visit
2.1. Column “FieldData_ID”,  unique Field Data identifier, naming convention: FD_HF_[Location_ID]_[date as yyyymmdd]
2.2. Column “Location_ID”, location identifier referenced to Locations.csv
2.3. Column “DateTime_UTC”, date & time, yyyy-mm-dd hh:mm UTC
2.4. Column “WaterDepth_m”, depth to the water table measured from the ground surface, m
2.5. Column “DO”, dissolved oxegyn content of the sample, ppm
2.6. Column “pH”, pH
2.7. Column “WaterTemp_C”, water temperature, degrees C
2.8. Column “AirTemp_C”, air temperature at the ground surface, degrees C
2.9. Column “SoilTemp11_C”, soil temperature at 11cm depth, degrees C
2.10. Column “SoilTemp30_C”, soil temperature at 30cmm depth, degrees C
2.11. Column “Notes”, notes
3. Samples.csv, a record of the samples of water and soil that were collected
3.1. Column “Sample_ID”, a unique sample identifier, naming convention: Samp_[Location_ID]_[date as yyyymmdd]_[other notation (A,B, etc) as needed]
3.2. Column “FieldData_ID”, FieldData identified referenced to FieldData.csv
3.3. Column “Type”, sample type, soil or water
4. Analysis.csv, listing of the analyses performed on the water samples
4.1. Column “Analysis_ID”, unique identifier, naming convention: Anal_[Machine]_[date as yyyymmdd]
4.2. Column “Date”, date, yyyy-mm-dd
4.3. Column “Machine”, type of analysis, IC = ion chromatograph (Dionex ICS-2000 Ion Chromatograph), DOC = dissolved organic carbon (O-I Analyzer 1010 Total Organic Carbon Analyzer), Spec = Spectographic Analysis of Nitrate, Isotope=bacterial denitrifier assay at the UC Davis Stable Isotope Facility (K. Casciotti, D. M. Sigman, M. Galanter Hastings, J. K. Bohlke and A. Hikert, "Measurement of the Oxygen Isotopic Composition of Nitrate in Seawater and Freshwater Using the Denitrifier Method," Analytical Chemistry, vol. 74, pp. 4905-4912, 2002. & D. Sigman, K. L. Casciotti, M. Andreani, C. Barford, M. Galanter and J. K. Bohlke, "A Bacterial Method for the Nitrogen Isotopic Analysis of Nitrate in Seawater and Freshwater," Analytic Chemistry, vol. 73, pp. 4145-4153, 2001.)
5. Results.csv, describes the results of the water sample analyses
5.1. Column “Results_ID”, unique identifier, naming convention: Res_[Analysis Machine]_[Analysis Date as yyyymmdd]_[Sample Location_ID]_[Sample Date as yyyymmdd](_[Sample Notation if needed])
5.2. Column “Analysis_ID”, identifies the analysis run, referenced to Analysis.csv
5.3. Column “Sample_ID”, unique sample identifier, referenced to Samples.csv
5.4. Column “NO3N”, sample nitrate-N concentration, ppm, Lc (critical level) = 0.18, PQL (quantification limit) = 0.571
5.5. Column “NO2N”, sample nitrite-N concentration, ppm, Lc (critical level) = 0.031, PQL (quantification limit) = 0.097
5.6. Column “Cl”, sample Cl- concentration, ppm, Lc (critical level) = 0.062, PQL (quantification limit) = 0.197
5.7. Column “SO4”, sample SO4-S concentration, ppm, Lc (critical level) = 0.329, PQL (quantification limit) = 1.046
5.8. Column “DOC”, dissolved organic carbon concentration, ppm
5.9. Column “DIC”, dissolved inorganic carbon concentration, ppm
5.10. Column “dN15”, delta 15N, per mil
5.11. Column “dO18”, delta 18O, per mil
5.12. Column “Flag”, Flagging of data results,”F”
5.13. Column “Notes”, descriptions of data flags and other notes
6. SM.csv, describes soil moistures measurements made with a HydroSense Soil Water Measurement System
6.1. Column “SM_ID”, unique soil moisture measurement identifier, naming convention: SM_FD_HF_[Location_ID]_[Date as yyyymmdd]_[Depth in cm]-[Measurement Number]
6.2. Column “FieldData_ID”, unique Field Data identifier, referenced to FieldData.csv
6.3. Column “Depth_cm”, measurement depth, cm
6.4. Column “SM”, Volumetric Water Content
6.5. Column “Period”, probe output period, ms
7. Soil.csv, gives the analysis results of the soil samples
7.1. Column “Sample_ID”, unique soil sample identifier, referenced to Samples.csv
7.2. Column “BulkDensity”, bulk density of the soil sample, g/cm3