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:
water dynamics in a desert city,
Biogeochemical Patterns, Processes, and Human Outcomes,
movement of organic matter,
movement of inorganic matter sonoran desert,
phoenix,
geosciences,
Biogeochemical Patterns, Processes, and Human Outcomes,
Climate, Ecosystems and People,
water quality,
long term monitoring,
long term experiments,
sycamore creek water,
nitrate,
nitrogen,
methods,
streams,
organisms,
water quality,
long term monitoring,
ammonium,
organic nitrogen caplter,
central arizona phoenix longterm ecological research,
arizona,
caplter created,
az,
cap,
arid land
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 |
|