Skip to Content
Report an accessibility problem

Water quality at Sycamore Creek research site, central Arizona 1977-1999

Publication date: 2007

Author(s):

  • Nancy Grimm
  • Stuart Fisher
  • Joanne Bessler
  • Rob Bills
  • Tegan Blaine
  • Andrew Boulton
  • John Cetin
  • Sandra Clinton
  • Tom Colella
  • Alicia Corbett
  • Lisa Dent
  • Kelly Donovan
  • Leanne Downs
  • Nicole Drake
  • Tom Dudley
  • Jennifer Edmonds
  • Susan Ford
  • Chad Fredrickson
  • Janey Freeman
  • James Gavin
  • Aisha Goettl
  • Rosa Gómez
  • Dena Greene
  • Kevin Grove
  • Bryan Harper
  • Julia Henry
  • Shero Holland
  • Bob Holmes
  • Jennifer Hunter
  • Andrea Jackson
  • Jay Jones
  • Cathy Kochert
  • Traci Main
  • Michael Mallett
  • Eugènia Martí
  • Andres Millan
  • Miguel Murphy
  • Michael Myers
  • Markus Naegeli
  • Renee Peralta
  • Bruce Peterson
  • Chris Peterson
  • Kevin Petrone
  • Sam Rector
  • John Roach
  • John Schade
  • Ann Schrot
  • Jaime Seddon
  • Ryan Sponseller
  • Emily Stanley
  • Kathy Stinchfield
  • Maggie Tseng
  • Maury Valett
  • Josefa Velasco
  • Jill Welter
  • Dalaine Wood
  • Jennifer Zachary
  • Weixing Zhu

Abstract:

Water quality was measured along the Sycamore Creek in central Arizona for the time period 1977-1999. Sites are listed in meters downstream.


Keywords:


Temporal Coverage:

1977-03-05 to 1999-05-27

Geographic Coverage:

Geographic Description: Sycamore Creek
Bounding Coordinates:
Longitude:-111.5411 to -111.5411
Latitude:33.694166 to 33.694166

Contact:

Information Manager, 
Global Institute of Sustainability,Arizona State University,POB 875402,Tempe
 caplter.data@asu.edu

Data Files (9) :

Tabular: 266_chloride_1.csv

Description: chloride concentration

Column Description Type Units
SiteID ID for site as used in waterquality_sites table
integer
LocalDateTime Sampling date
datetime Format: MM/DD/YYYY
DataValue chloride
float milligramsPerLiter
QualifierID ID for flag as used in qualifier table
integer
Enumeration:
  • 1: Below method detection limit
  • 2: Below method detection limit and Below lowest standard used in analysis
  • 3: Below method detection limit and Below lowest standard used in analysisand Value is an average of 3 replicates not shown here
  • 4: Below lowest standard used in analysis
  • 5: Below lowest standard used in analysisand Value is an average of 3 replicates not shown here
  • 6: Value is an average of 3 replicates not shown here
  • 7: Calculated using manually run nitrate concentrations and manually run ammonium concentrations (see method)and This calculation is based on average (over 3 replicates) values for nitrate and NH4
  • 8: Calculated using manually run nitrate concentrations and manually run ammonium concentrations (see method)and
  • 9: Average value is based on some values that are below the detection limit of the method
  • 10: This calculation is based on average (over 3 replicates) values for nitrate and NH4
  • 11: Calculated using TRAACS nitrate concentrations and manually run ammonium concentrations
  • 12: Dissolved organic nitrogen value came out negative so TDN value is probably bad, TDN, DON values are suspect
ValueID No Metadata Provided
integer

Tabular: 266_sulfate_1.csv

Description: sulfate concentration

Column Description Type Units
SiteID ID for site as used in waterquality_sites table
integer
LocalDateTime Sampling date
datetime Format: MM/DD/YYYY
DataValue sulfate
float milligramsPerLiter
QualifierID ID for flag as used in qualifier table
integer
Enumeration:
  • 1: Below method detection limit
  • 2: Below method detection limit and Below lowest standard used in analysis
  • 3: Below method detection limit and Below lowest standard used in analysisand Value is an average of 3 replicates not shown here
  • 4: Below lowest standard used in analysis
  • 5: Below lowest standard used in analysisand Value is an average of 3 replicates not shown here
  • 6: Value is an average of 3 replicates not shown here
  • 7: Calculated using manually run nitrate concentrations and manually run ammonium concentrations (see method)and This calculation is based on average (over 3 replicates) values for nitrate and NH4
  • 8: Calculated using manually run nitrate concentrations and manually run ammonium concentrations (see method)and
  • 9: Average value is based on some values that are below the detection limit of the method
  • 10: This calculation is based on average (over 3 replicates) values for nitrate and NH4
  • 11: Calculated using TRAACS nitrate concentrations and manually run ammonium concentrations
  • 12: Dissolved organic nitrogen value came out negative so TDN value is probably bad, TDN, DON values are suspect
ValueID No Metadata Provided
integer

Tabular: 266_ammonium_1.csv

Description: ammonium concentration

Column Description Type Units
SiteID ID for site as used in waterquality_sites table
integer
LocalDateTime Sampling date
datetime Format: MM/DD/YYYY
DataValue ammonium
float microgramsPerLiter
QualifierID ID for flag as used in qualifier table
integer
Enumeration:
  • 1: Below method detection limit
  • 2: Below method detection limit and Below lowest standard used in analysis
  • 3: Below method detection limit and Below lowest standard used in analysisand Value is an average of 3 replicates not shown here
  • 4: Below lowest standard used in analysis
  • 5: Below lowest standard used in analysisand Value is an average of 3 replicates not shown here
  • 6: Value is an average of 3 replicates not shown here
  • 7: Calculated using manually run nitrate concentrations and manually run ammonium concentrations (see method)and This calculation is based on average (over 3 replicates) values for nitrate and NH4
  • 8: Calculated using manually run nitrate concentrations and manually run ammonium concentrations (see method)and
  • 9: Average value is based on some values that are below the detection limit of the method
  • 10: This calculation is based on average (over 3 replicates) values for nitrate and NH4
  • 11: Calculated using TRAACS nitrate concentrations and manually run ammonium concentrations
  • 12: Dissolved organic nitrogen value came out negative so TDN value is probably bad, TDN, DON values are suspect
ValueID No Metadata Provided
integer

Tabular: 266_nitrateManual_1.csv

Description: nitrate concentration

Column Description Type Units
SiteID ID for site as used in waterquality_sites table
integer
LocalDateTime Sampling date
datetime Format: MM/DD/YYYY
DataValue nitrateManual
float microgramsPerLiter
QualifierID ID for flag as used in qualifier table
integer
Enumeration:
  • 1: Below method detection limit
  • 2: Below method detection limit and Below lowest standard used in analysis
  • 3: Below method detection limit and Below lowest standard used in analysisand Value is an average of 3 replicates not shown here
  • 4: Below lowest standard used in analysis
  • 5: Below lowest standard used in analysisand Value is an average of 3 replicates not shown here
  • 6: Value is an average of 3 replicates not shown here
  • 7: Calculated using manually run nitrate concentrations and manually run ammonium concentrations (see method)and This calculation is based on average (over 3 replicates) values for nitrate and NH4
  • 8: Calculated using manually run nitrate concentrations and manually run ammonium concentrations (see method)and
  • 9: Average value is based on some values that are below the detection limit of the method
  • 10: This calculation is based on average (over 3 replicates) values for nitrate and NH4
  • 11: Calculated using TRAACS nitrate concentrations and manually run ammonium concentrations
  • 12: Dissolved organic nitrogen value came out negative so TDN value is probably bad, TDN, DON values are suspect
ValueID No Metadata Provided
integer

Tabular: 266_phosphateSoluble_1.csv

Description: concentration

Column Description Type Units
SiteID ID for site as used in waterquality_sites table
integer
LocalDateTime Sampling date
datetime Format: MM/DD/YYYY
DataValue phosphateSoluble
float microgramsPerLiter
QualifierID ID for flag as used in qualifier table
integer
Enumeration:
  • 1: Below method detection limit
  • 2: Below method detection limit and Below lowest standard used in analysis
  • 3: Below method detection limit and Below lowest standard used in analysisand Value is an average of 3 replicates not shown here
  • 4: Below lowest standard used in analysis
  • 5: Below lowest standard used in analysisand Value is an average of 3 replicates not shown here
  • 6: Value is an average of 3 replicates not shown here
  • 7: Calculated using manually run nitrate concentrations and manually run ammonium concentrations (see method)and This calculation is based on average (over 3 replicates) values for nitrate and NH4
  • 8: Calculated using manually run nitrate concentrations and manually run ammonium concentrations (see method)and
  • 9: Average value is based on some values that are below the detection limit of the method
  • 10: This calculation is based on average (over 3 replicates) values for nitrate and NH4
  • 11: Calculated using TRAACS nitrate concentrations and manually run ammonium concentrations
  • 12: Dissolved organic nitrogen value came out negative so TDN value is probably bad, TDN, DON values are suspect
ValueID No Metadata Provided
integer

Tabular: 266_doc_1.csv

Description: concentration

Column Description Type Units
SiteID ID for site as used in waterquality_sites table
integer
LocalDateTime Sampling date
datetime Format: MM/DD/YYYY
DataValue doc
float milligramsPerLiter
QualifierID ID for flag as used in qualifier table
integer
Enumeration:
  • 1: Below method detection limit
  • 2: Below method detection limit and Below lowest standard used in analysis
  • 3: Below method detection limit and Below lowest standard used in analysisand Value is an average of 3 replicates not shown here
  • 4: Below lowest standard used in analysis
  • 5: Below lowest standard used in analysisand Value is an average of 3 replicates not shown here
  • 6: Value is an average of 3 replicates not shown here
  • 7: Calculated using manually run nitrate concentrations and manually run ammonium concentrations (see method)and This calculation is based on average (over 3 replicates) values for nitrate and NH4
  • 8: Calculated using manually run nitrate concentrations and manually run ammonium concentrations (see method)and
  • 9: Average value is based on some values that are below the detection limit of the method
  • 10: This calculation is based on average (over 3 replicates) values for nitrate and NH4
  • 11: Calculated using TRAACS nitrate concentrations and manually run ammonium concentrations
  • 12: Dissolved organic nitrogen value came out negative so TDN value is probably bad, TDN, DON values are suspect
ValueID No Metadata Provided
integer

Tabular: 266_suva_1.csv

Description: concentration

Column Description Type Units
SiteID ID for site as used in waterquality_sites table
integer
LocalDateTime Sampling date
datetime Format: MM/DD/YYYY
DataValue suva
float milligramsPerLiter
QualifierID ID for flag as used in qualifier table
integer
Enumeration:
  • 1: Below method detection limit
  • 2: Below method detection limit and Below lowest standard used in analysis
  • 3: Below method detection limit and Below lowest standard used in analysisand Value is an average of 3 replicates not shown here
  • 4: Below lowest standard used in analysis
  • 5: Below lowest standard used in analysisand Value is an average of 3 replicates not shown here
  • 6: Value is an average of 3 replicates not shown here
  • 7: Calculated using manually run nitrate concentrations and manually run ammonium concentrations (see method)and This calculation is based on average (over 3 replicates) values for nitrate and NH4
  • 8: Calculated using manually run nitrate concentrations and manually run ammonium concentrations (see method)and
  • 9: Average value is based on some values that are below the detection limit of the method
  • 10: This calculation is based on average (over 3 replicates) values for nitrate and NH4
  • 11: Calculated using TRAACS nitrate concentrations and manually run ammonium concentrations
  • 12: Dissolved organic nitrogen value came out negative so TDN value is probably bad, TDN, DON values are suspect
ValueID No Metadata Provided
integer

Tabular: 266_oxygen_1.csv

Description: concentration

Column Description Type Units
SiteID ID for site as used in waterquality_sites table
integer
LocalDateTime Sampling date
datetime Format: MM/DD/YYYY
DataValue oxygen
float milligramsPerLiter
QualifierID ID for flag as used in qualifier table
integer
Enumeration:
  • 1: Below method detection limit
  • 2: Below method detection limit and Below lowest standard used in analysis
  • 3: Below method detection limit and Below lowest standard used in analysisand Value is an average of 3 replicates not shown here
  • 4: Below lowest standard used in analysis
  • 5: Below lowest standard used in analysisand Value is an average of 3 replicates not shown here
  • 6: Value is an average of 3 replicates not shown here
  • 7: Calculated using manually run nitrate concentrations and manually run ammonium concentrations (see method)and This calculation is based on average (over 3 replicates) values for nitrate and NH4
  • 8: Calculated using manually run nitrate concentrations and manually run ammonium concentrations (see method)and
  • 9: Average value is based on some values that are below the detection limit of the method
  • 10: This calculation is based on average (over 3 replicates) values for nitrate and NH4
  • 11: Calculated using TRAACS nitrate concentrations and manually run ammonium concentrations
  • 12: Dissolved organic nitrogen value came out negative so TDN value is probably bad, TDN, DON values are suspect
ValueID No Metadata Provided
integer

Tabular: 266_waterquality_sites_1.csv

Description: concentration

Column Description Type Units
SiteID ID for site
integer
SiteCode site code as used in original data collection
string
SiteName main site name relative to landmarks along Sycamore Creek
string
Latitude Latitude in decimal degree
float degree
Longitude Longitude in decimal degree
float degree
LatLongDatumID ID for Latitude and Longitude Datum as used in SpatialReference table
integer
Elevation_m elevation in meter
float meter
VerticalDatum Vertical Datum
string
LocalX X coordinate
float
LocalY Y coordinate
float
LocalProjectionID Id for local projection
integer
PosAccuracy_m Position Accuracy in meter
float meter
State State the station is located in
string
County County the station is located in
string
Comments Comments
string

Download EML Metadata for this data package