Data Package Metadata View Summary

Regional drinking water quality monitoring program: long-term monitoring of water quality in select canals, reservoirs, and treatment plants of the greater Phoenix, Arizona metropolitan area drinking water system, ongoing since 1998

General Information

Data Package:
Local Identifier:	knb-lter-cap.617.6
Title:	Regional drinking water quality monitoring program: long-term monitoring of water quality in select canals, reservoirs, and treatment plants of the greater Phoenix, Arizona metropolitan area drinking water system, ongoing since 1998
Alternate Identifier:	DOI PLACE HOLDER
Abstract:	Regional Drinking Water Quality Monitoring Program ================================================== Arizona Statue University (ASU) has been working with regional water providers (Salt River Project (SRP), Central Arizona Project (CAP)) and metropolitan Phoenix cities since 1998 on algae-related issues affecting drinking water supplies, treatment, and distribution. The results have improved the understanding of taste and odor (T&O) occurrence, control, and treatment, improved the understanding of dissolved organic and algae dynamics, and initiated a forum to discuss and address regional water quality issues. The monitoring benefits local Water Treatment Plants (WTPs) by optimizing ongoing operations (i.e., reducing operating costs), improving the quality of municipal water for consumers, facilitating long-term water quality planning, and providing information on potentially future-regulated compounds. ASU has been monitoring water quality in terminal reservoirs (Lake Pleasant, Saguaro Lake, and Bartlett Lake) continuously from 1998 to the present for algae-related constituents (taste and odors, and more recently metals from the upper reservoirs), nutrients, and disinfection by-product precursors (i.e., total and dissolved organic carbon and organic nitrogen). Additional monitoring has been conducted in the SRP and CAP canal systems and in water treatment plants in Phoenix, Tempe and Peoria. During this work the Valley has been in a prolonged drought and recently one above average wet year, and this data provides important baseline data for development of new or expanded WTPs and management of existing WTPs in the future. The current work has improved the understanding of T&O sources and treatment, but additional research and monitoring into the future is necessary. Reservoir monitoring is conducted once per month at Bartlett Lake, Saguaro Lake, and Lake Pleasant, and quarterly at Roosevelt, Apache, and Canyon Lakes. Samples are depth integrated in the epilimnion and hypolimnion. CAP will collect samples from Lake Pleasant. SRP will collect samples from Bartlett, Saguaro, Roosevelt, Apache, and Canyon Lakes. Field measurements for temperature with depth will also be collected. River samples (Salt River below Saguaro Lake @ Blue Point Bridge and Verde River at the Beeline Highway) will be collected once per month. Samples will be analyzed for carbon (TOC/DOC), total nitrogen, total phosphorous, arsenic, conductance and T&O compounds (MIB, Geosmin, Cyclocitrol). The purpose of the lake sampling is to provide early warning information on potentially large changes in water quality – due to algae production, lake destratification, and forest fire or other runoff events. Additional monthly sampling will be coordinated with USGS (Salt River above Roosevelt, Verde River at Tangle) and CAP (Lake Havasu). Canal monitoring is conducted once per month (January through June), and twice per month as needed during periods of higher T&O production (i.e., July-December). Field measurements for temperature and pH will be made. Sampling will include the CAP, Arizona, and South canals at multiple locations. Monthly samples will be analyzed for carbon (TOC/DOC), SUVA/UV254, total dissolved nitrogen, microbes, conductance, and T&O compounds (MIB and Geosmin). Bi-weekly samples will be analyzed only for T&O compounds. The purpose of the canal sampling is to identify hot-spots of T&O production and to make recommendations to the cities/SRP/CAP to perform some type of treatment (brushing, copper, etc.). Additional canal sampling will be scheduled to further identify canal hot spots or to provide more frequent process control information. WTP raw and finished water is collected once per month (January through June), and twice per month as needed during periods of higher T&O production (e.g., July-December). WTP sampling will be conducted at two Tempe WTPs, one Peoria WTP, Glendale WTPs and other selected WTPs. Monthly samples will be analyzed for carbon (TOC/DOC), SUVA/UV254, total dissolved nitrogen, microbes, conductance, and T&O compounds (MIB and Geosmin). Bi-weekly samples will be analyzed only for T&O compounds. The purpose of the WTP sampling is to provide continued evaluation of water quality produced at the WTPs.
Publication Date:	2020-08-03

Time Period

Begin:

1999-08-16

End:

2020-07-23

People and Organizations
Contact:	Information Manager (Central Arizona–Phoenix LTER) [ email ]
Creator:	Fox, Peter (Arizona State University)
Creator:	Abbaszadegan, Morteza (Arizona State University)
Associate:	Westerhoff, Paul (Arizona State University, former associate of project)
Associate:	Sommerfeld, Milton (Arizona State University, Polytechnic campus, former associate of project)

Data Entities
Data Table Name:	617_algae_49fa96bded7c86b3720d56a128efc5a7.csv
Description:	algal characteristics (chlorophyll concentration, cell counts) and specific conductance in canals and reservoirs
Data Table Name:	617_algal_byproducts_d4765274e6268e53e82bfece5fabb7e3.csv
Description:	concentration of algal by-products in canals and reservoirs
Data Table Name:	617_arsenic_18c9184205e943456921449878002c3a.csv
Description:	arsenic and perchlorate concentrations in canals and reservoirs
Data Table Name:	617_carbon_cc0e7f16f828061c7aa3dd325fa9f0ef.csv
Description:	approximately monthly water carbon data in Phoenix-area canals and reservoirs
Data Table Name:	617_field_measurements_61820cda981b4135b9b2efdc641bacc2.csv
Description:	water quality parameters as measured in the field in canals and reservoirs
Data Table Name:	617_microbial_7a331250b6c16318285bb1d355dffc95.csv
Description:	E. coli, Coliform, and Mycobacterium colony counts in canals and reservoirs
Data Table Name:	617_nutrients_a32dafb7546f4adc6404c987eff0ddcc.csv
Description:	concentration of algal by-products in canals and reservoirs
Data Table Name:	617_quarterly_lake_sampling_f0737c30552c0ab276c0d93483672fcb.csv
Description:	concentration of nutrients and algal by-products, and other water quality parameters measured in central-Arizona area lakes
Data Table Name:	617_quarterly_metals_7f32c206f2d47401a024067c57de94b3.csv
Description:	concentration of dissolved metals measured in central-Arizona area lakes and canals
Data Table Name:	617_sampling_locations_46042e79c58446e438b4879dac011e84.csv
Description:	latitude, longitude, and elevation of select canal, lake, and river water-quality sampling locations

Detailed Metadata

Data Entities

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/knb-lter-cap/617/6/83973dbd774560d0d9f59bc1569033b9
Name:	617_algae_49fa96bded7c86b3720d56a128efc5a7.csv
Description:	algal characteristics (chlorophyll concentration, cell counts) and specific conductance in canals and reservoirs
Number of Records:	10208
Number of Columns:	15

Table Structure

Object Name:

617_algae_49fa96bded7c86b3720d56a128efc5a7.csv

Size:

1069305 bytes

Authentication:

49fa96bded7c86b3720d56a128efc5a7 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Column Name:

site number

site location

cluster

site acronym

date

sample type

conductance (uS/cm)

chl A (ug/L)

phaeophytin (ug/L)

phaeophytin chl A (ug/L)

chlorophyta (organisms/ml)

cyanophyta (organisms/ml)

bacillariophyta (organisms/ml)

total (organisms/ml)

algae comments

Definition:

site number or name (A designates epilimnion, B hypolimnion)

site location description

source water

site number or name

sample collection date

type of water sample collected (if not a field sample)

specific conductance

chlorophyll A concentration

phaeophytin concentration

chlorophyll A concentration corrected for phaeophytin

Chlorophyta concentration

Cyanophyta concentation

Bacillariophyta concentration

combined concentration of Chlorophyta, Cyanophyta, and Bacillariophyta

comment(s) about site conditions or sampling details

Storage Type:

string

date

string

float

string

Measurement Type:

nominal

dateTime

nominal

ratio

nominal

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	16th St.
Definition	AZ Canal at 16th Street
Source

Code Definition

Code	19th Av.
Definition	AZ Canal at 19th Avenue
Source

Code Definition

Code	AN IN
Definition	Anthem WTP Inlet
Source

Code Definition

Code	CH IN
Definition	Chandler WTP Inlet
Source

Code Definition

Code	Cons
Definition	Consolidated canal
Source

Code Definition

Code	field_blank
Definition	Field blank
Source

Code Definition

Code	Glendale In
Definition	Glendale WTP Inlet
Source

Code Definition

Code	Glendale Out
Definition	Glendale WTP Treated
Source

Code Definition

Code	Green In
Definition	Greenway WTP Inlet
Source

Code Definition

Code	Green Out
Definition	Greenway WTP Treated
Source

Code Definition

Code	Havasu 1
Definition	Lake Havasu Site 1
Source

Code Definition

Code	Havasu 2
Definition	Lake Havasu Site 2
Source

Code Definition

Code	HOC
Definition	Head of the Consolidated canal
Source

Code Definition

Code	HTC
Definition	Head of the Tempe Canal
Source

Code Definition

Code	Hwy 87
Definition	AZ Canal at Highway 87
Source

Code Definition

Code	lab_blank
Definition	Laboratory blank
Source

Code Definition

Code	Mesa
Definition	AZ Canal at Mesa Dr.
Source

Code Definition

Code	Mesa Turnout
Definition	Mesa Canal Turnout
Source

Code Definition

Code	MOC
Definition	Middle of the Consolidated canal
Source

Code Definition

Code	NP In
Definition	Tempe North WTP Inlet
Source

Code Definition

Code	NP Out
Definition	Tempe North WTP Treated
Source

Code Definition

Code	Pima
Definition	AZ Canal at Pima Rd
Source

Code Definition

Code	R1
Definition	CAP canal above Waddell Canal
Source

Code Definition

Code	R10
Definition	Salt River below Saguaro (Blue Point Bridge)
Source

Code Definition

Code	R11
Definition	CAP Canal at Cross-connect
Source

Code Definition

Code	R12
Definition	AZ Canal above CAP Cross-connect
Source

Code Definition

Code	R13
Definition	AZ Canal below CAP Cross-connect
Source

Code Definition

Code	R14
Definition	AZ Canal - Inlet to Squaw Peak WTP
Source

Code Definition

Code	R15
Definition	Squaw Peak WTP treated water
Source

Code Definition

Code	R16
Definition	AZ Canal - Inlet to Deer Valley WTP
Source

Code Definition

Code	R17
Definition	Deer Valley WTP treated water
Source

Code Definition

Code	R18
Definition	South Canal at Val Vista WTP
Source

Code Definition

Code	R19
Definition	Val Vista WTP treated water
Source

Code Definition

Code	R20
Definition	Verde River at Tangle
Source

Code Definition

Code	R21
Definition	AZ Canal - Central Avenue
Source

Code Definition

Code	R22
Definition	AZ Canal at 56th
Source

Code Definition

Code	R25
Definition	Verde River at Beeline
Source

Code Definition

Code	R26
Definition	Arizona Canal at 19th Ave.
Source

Code Definition

Code	R2A
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	R2B
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	R3
Definition	Waddell Canal
Source

Code Definition

Code	R4
Definition	Cap Canal at 7th St.
Source

Code Definition

Code	R4-Dup
Definition	Cap Canal at 7th St. Duplicate Sample
Source

Code Definition

Code	R5
Definition	Verde River btwn Horseshoe and Bartlett
Source

Code Definition

Code	R5dup
Definition	Verde River btwn Horseshoe and Bartlett Duplicate Sample
Source

Code Definition

Code	R6A
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	R6B
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	R7
Definition	Verde River below Bartlett Reservoir
Source

Code Definition

Code	R8
Definition	Salt River inlet to Saguaro Lake
Source

Code Definition

Code	R9A
Definition	Saguaro Lake near inlet
Source

Code Definition

Code	R9A-Dup
Definition	Saguaro Lake near inlet Duplicate Sample
Source

Code Definition

Code	R9B
Definition	Saguaro Lake near inlet
Source

Code Definition

Code	Roos In
Definition	Salt River Inlet Near Roosevelt Lake
Source

Code Definition

Code	Roosvelt
Definition	SRP above Roosevelt Lake
Source

Code Definition

Code	Salt Gila
Definition	Salt-Gila Pump Station
Source

Code Definition

Code	Scotts
Definition	AZ Canal at Scottsdale Rd.
Source

Code Definition

Code	SOCA
Definition	South Canal below CAP Cross-connect
Source

Code Definition

Code	SPT In
Definition	Tempe South WTP Inlet
Source

Code Definition

Code	SPT Out
Definition	Tempe South WP Treated
Source

Code Definition

Code	UH In
Definition	Union Hills WTP Inlet
Source

Code Definition

Code	UH Out
Definition	Union Hills WTP Treated
Source

Definition

site location description

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	az canal
Definition	Arizona canal
Source

Code Definition

Code	cap
Definition	Central Arizona Project canal
Source

Code Definition

Code	salt
Definition	Salt River
Source

Code Definition

Code	srp
Definition	Salt River Project canal
Source

Code Definition

Code	tempe
Definition	Tempe, AZ area canal
Source

Code Definition

Code	verde
Definition	Verde River
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Above Roosevelt
Definition	metadata_not_provided
Source

Code Definition

Code	az canal
Definition	metadata_not_provided
Source

Code Definition

Code	az canal @ 16th st.
Definition	AZ Canal at 16th Street
Source

Code Definition

Code	az canal @ 19 ave.
Definition	AZ Canal at 19th Avenue
Source

Code Definition

Code	az canal @ 19th av.
Definition	AZ Canal at 19th Avenue
Source

Code Definition

Code	az canal @ 56th st.
Definition	AZ Canal at 56th Street
Source

Code Definition

Code	az canal @ central ave.
Definition	AZ Canal at Central Avenue
Source

Code Definition

Code	az canal @ deer valley
Definition	AZ Canal - Inlet to Deer Valley WTP
Source

Code Definition

Code	az canal @ hwy 87
Definition	AZ Canal at Highway 87
Source

Code Definition

Code	az canal @ Mesa
Definition	AZ Canal at Mesa Dr.
Source

Code Definition

Code	az canal @ pima
Definition	AZ Canal at Pima Rd
Source

Code Definition

Code	az canal @ scotts.
Definition	AZ Canal at Scottsdale Rd.
Source

Code Definition

Code	az canal @ squaw peak
Definition	AZ Canal - Inlet to Squaw Peak WTP
Source

Code Definition

Code	az canal blw cap
Definition	AZ Canal below CAP Cross-connect
Source

Code Definition

Code	az canal inflow
Definition	AZ Canal above CAP Cross-connect
Source

Code Definition

Code	bartlett-epi
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	bartlett-hypo
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	cap @ 7th st
Definition	Cap Canal at 7th St.
Source

Code Definition

Code	cap @ 7th st dup
Definition	Cap Canal at 7th St. Duplicate Sample
Source

Code Definition

Code	cap @ x con
Definition	CAP Canal at Cross-connect
Source

Code Definition

Code	cap-siphon
Definition	metadata_not_provided
Source

Code Definition

Code	deer valley-treated
Definition	Deer Valley WTP treated water
Source

Code Definition

Code	Glen In
Definition	Glendale WTP Inlet
Source

Code Definition

Code	Glen Out
Definition	Glendale WTP Treated
Source

Code Definition

Code	Green In
Definition	Greenway WTP Inlet
Source

Code Definition

Code	Green Out
Definition	Greenway WTP Treated
Source

Code Definition

Code	Havasu 1
Definition	Lake Havasu Site 1
Source

Code Definition

Code	Havasu 2
Definition	Lake Havasu Site 2
Source

Code Definition

Code	head of tempe canal
Definition	Head of Tempe Canal
Source

Code Definition

Code	HOC
Definition	Head of the Consolidated canal
Source

Code Definition

Code	MOC
Definition	Middle of the Consolidated canal
Source

Code Definition

Code	MTO
Definition	Mesa Canal Turnout
Source

Code Definition

Code	North plant inlet
Definition	Tempe North WTP Inlet
Source

Code Definition

Code	north plant outlet
Definition	Tempe North WTP Treated
Source

Code Definition

Code	pleasant-epi
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	pleasant-hypo
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	s canal @ val vista
Definition	South Canal at Val Vista WTP
Source

Code Definition

Code	saguaro-epi
Definition	Saguaro Lake Epilimnion
Source

Code Definition

Code	saguaro-epi dup
Definition	Saguaro Lake Epilimnion Duplicate Sample
Source

Code Definition

Code	saguaro-hypo
Definition	Saguaro Lake Hypolimnion
Source

Code Definition

Code	salt abv saguaro
Definition	Salt River inlet to Saguaro Lake
Source

Code Definition

Code	salt blw saguaro
Definition	Salt River below Saguaro (Blue Point Bridge)
Source

Code Definition

Code	SGPS
Definition	Salt Gila Pump Station
Source

Code Definition

Code	South canal below CAP
Definition	South Canal below CAP Cross-connect
Source

Code Definition

Code	squaw peak-treated
Definition	Squaw Peak WTP treated water
Source

Code Definition

Code	SRNR
Definition	Salt River Inlet Near Roosevelt Lake
Source

Code Definition

Code	STP In
Definition	Tempe Canal - Inlet to Tempe's South Plant
Source

Code Definition

Code	STP Out
Definition	Tempe's South Plant treated water
Source

Code Definition

Code	Union Hills Inlet
Definition	Union Hills WTP Inlet
Source

Code Definition

Code	Union Hills Outlet
Definition	Union Hills WTP Treated
Source

Code Definition

Code	val vista-treated
Definition	Val Vista WTP treated water
Source

Code Definition

Code	verde @ beeline
Definition	verde river at beeline highway
Source

Code Definition

Code	verde abv bartlett
Definition	Verde River btwn Horseshoe and Bartlett
Source

Code Definition

Code	verde abv horseshoe
Definition	Verde River at Tangle
Source

Code Definition

Code	verde blw barlett
Definition	Verde River below Bartlett Reservoir
Source

Code Definition

Code	waddell canal
Definition	Waddell Canal
Source

Format	YYYY-MM-DD
Precision

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	field blank
Definition	Field blank
Source

Code Definition

Code	field duplicate
Definition	Field duplicate sample
Source

Code Definition

Code	had white ppt
Definition	metadata_not_provided
Source

Code Definition

Code	has white ppt
Definition	metadata_not_provided
Source

Code Definition

Code	lab blank
Definition	Laboratory blank
Source

Code Definition

Code	only field duplicate
Definition	metadata_not_provided
Source

Unit	microsiemensPerCentimeter
Type	real
Min	0
Max	9009

Unit	microgramsPerLiter
Type	real
Min	0
Max	66.9

Unit	microgramsPerLiter
Type	real
Min	0
Max	14.35125

Unit	microgramsPerLiter
Type	real
Min	0
Max	71.423

Unit	numberPerMilliliter
Type	whole
Min	0
Max	5818

Unit	numberPerMilliliter
Type	whole
Min	0
Max	439

Unit	numberPerMilliliter
Type	whole
Min	0
Max	5030

Unit	numberPerMilliliter
Type	whole
Min	0
Max	5919

Definition

comment(s) about site conditions or sampling details

Missing Value Code:

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/knb-lter-cap/617/6/52810511dc1c5526128d0cf2d09be70d
Name:	617_algal_byproducts_d4765274e6268e53e82bfece5fabb7e3.csv
Description:	concentration of algal by-products in canals and reservoirs
Number of Records:	13889
Number of Columns:	13

Table Structure

Object Name:

617_algal_byproducts_d4765274e6268e53e82bfece5fabb7e3.csv

Size:

1457904 bytes

Authentication:

d4765274e6268e53e82bfece5fabb7e3 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Column Name:

site number

site location

cluster

site acronym

date

sample type

MIB (ng/L) ASU

geosmin (ng/L) ASU

beta-cyclocitral (ng/L)

IPMP recovery (%)

MIB (ng/L) Phoenix

geosmin (ng/L) Phoenix

comments

Definition:

site number or name (A designates epilimnion, B hypolimnion)

site location description

source water

site number or name

sample collection date

type of water sample collected (if not a field sample)

2-methylisoborneol

geosmin

beta-Cyclocitral

recovery of 2-isopropyl-3-methoxy pyrazine (IPMP used as an internal standard)

MIB as measured by City of Phoenix officials for methods comparison

geosmin as measured by City of Phoenix officials for methods comparison

comment(s) about site conditions or sampling details

Storage Type:

string

date

string

float

string

Measurement Type:

nominal

dateTime

nominal

ratio

nominal

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	16th St.
Definition	AZ Canal at 16th Street
Source

Code Definition

Code	19th Av.
Definition	AZ Canal at 19th Avenue
Source

Code Definition

Code	32nd St.
Definition	AZ Canal at 32nd Street
Source

Code Definition

Code	44th St.
Definition	AZ Canal at 44th Street
Source

Code Definition

Code	7th Av.
Definition	metadata_not_provided
Source

Code Definition

Code	7th St.
Definition	AZ Canal at 7th Street
Source

Code Definition

Code	AN In
Definition	Anthem WTP Inlet
Source

Code Definition

Code	AN Out
Definition	Anthem WTP Treated
Source

Code Definition

Code	CH In
Definition	Chandler WTP Inlet
Source

Code Definition

Code	CH Out
Definition	Chandler WTP Treated
Source

Code Definition

Code	Cons
Definition	Consolidated canal
Source

Code Definition

Code	field_blank
Definition	Field blank
Source

Code Definition

Code	field_spike
Definition	Field spike
Source

Code Definition

Code	Glen In
Definition	Glendale WTP Inlet
Source

Code Definition

Code	Glen Out
Definition	Glendale WTP Treated
Source

Code Definition

Code	GR In
Definition	Greenway WTP Inlet
Source

Code Definition

Code	GR Out
Definition	Greenway WTP Treated
Source

Code Definition

Code	Green In
Definition	Greenway WTP Inlet
Source

Code Definition

Code	Green Out
Definition	Greenway WTP Treated
Source

Code Definition

Code	Havasu 1
Definition	Lake Havasu Site 1
Source

Code Definition

Code	Havasu 2
Definition	Lake Havasu Site 2
Source

Code Definition

Code	HOC
Definition	Head of the Consolidated canal
Source

Code Definition

Code	HTC
Definition	Head of the Tempe Canal
Source

Code Definition

Code	Hwy 87
Definition	AZ Canal at Highway 87
Source

Code Definition

Code	ISTB4
Definition	ISTB4 building drinking water
Source

Code Definition

Code	lab_blank
Definition	Laboratory blank
Source

Code Definition

Code	Mesa
Definition	AZ Canal at Mesa Dr.
Source

Code Definition

Code	Mesa Turnout
Definition	Mesa Canal Turnout
Source

Code Definition

Code	MOC
Definition	Middle of the Consolidated canal
Source

Code Definition

Code	Northern
Definition	AZ Canal at Northern Avenue
Source

Code Definition

Code	NP In
Definition	Tempe North WTP Inlet
Source

Code Definition

Code	NP Out
Definition	Tempe North WTP Treated
Source

Code Definition

Code	Pima
Definition	AZ Canal at Pima Rd
Source

Code Definition

Code	R1
Definition	CAP canal above Waddell Canal
Source

Code Definition

Code	R10
Definition	Salt River below Saguaro (Blue Point Bridge)
Source

Code Definition

Code	R10rain
Definition	Salt River below Saguaro (Blue Point Bridge) rain sample
Source

Code Definition

Code	R11
Definition	CAP Canal at Cross-connect
Source

Code Definition

Code	R11rain
Definition	CAP Canal at Cross-connect rain sample
Source

Code Definition

Code	R12
Definition	AZ Canal above CAP Cross-connect
Source

Code Definition

Code	R12rain
Definition	AZ Canal above CAP Cross-connect rain sample
Source

Code Definition

Code	R13
Definition	AZ Canal below CAP Cross-connect
Source

Code Definition

Code	R13rain
Definition	AZ Canal below CAP Cross-connect rain sample
Source

Code Definition

Code	R14
Definition	AZ Canal - Inlet to Squaw Peak WTP
Source

Code Definition

Code	R15
Definition	Squaw Peak WTP treated water
Source

Code Definition

Code	R16
Definition	AZ Canal - Inlet to Deer Valley WTP
Source

Code Definition

Code	R17
Definition	Deer Valley WTP treated water
Source

Code Definition

Code	R18
Definition	South Canal at Val Vista WTP
Source

Code Definition

Code	R18sediment
Definition	South Canal at Val Vista WTP sediment sample
Source

Code Definition

Code	R19
Definition	Val Vista WTP treated water
Source

Code Definition

Code	R20
Definition	Verde River at Tangle
Source

Code Definition

Code	R21
Definition	AZ Canal - Central Avenue
Source

Code Definition

Code	R22
Definition	AZ Canal at 56th
Source

Code Definition

Code	R23
Definition	metadata_not_provided
Source

Code Definition

Code	R24
Definition	metadata_not_provided
Source

Code Definition

Code	R25
Definition	Verde River at Beeline
Source

Code Definition

Code	R25ex
Definition	verde river at beeline highway extra sample
Source

Code Definition

Code	R25rain
Definition	verde river at beeline highway rain sample
Source

Code Definition

Code	R26
Definition	Arizona Canal at 19th Ave.
Source

Code Definition

Code	R2A
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	R2B
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	R3
Definition	Waddell Canal
Source

Code Definition

Code	R4
Definition	Cap Canal at 7th St.
Source

Code Definition

Code	R4-Dup
Definition	Cap Canal at 7th St. duplicate sample
Source

Code Definition

Code	R4dup
Definition	Cap Canal at 7th St. duplicate sample
Source

Code Definition

Code	R5
Definition	Verde River btwn Horseshoe and Bartlett
Source

Code Definition

Code	R5ex
Definition	Verde River btwn Horseshoe and Bartlett
Source

Code Definition

Code	R6A
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	R6B
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	R6C
Definition	Bartlett Lake near dock
Source

Code Definition

Code	R7
Definition	Verde River below Bartlett Reservoir
Source

Code Definition

Code	R8
Definition	Salt River inlet to Saguaro Lake
Source

Code Definition

Code	R9@10m
Definition	Saguaro Lake at 10m
Source

Code Definition

Code	R9A
Definition	Saguaro Lake near inlet
Source

Code Definition

Code	R9A-Dup
Definition	Saguaro Lake near inlet duplicate sample
Source

Code Definition

Code	R9Adup
Definition	Saguaro Lake near inlet duplicate sample
Source

Code Definition

Code	R9B
Definition	Saguaro Lake near inlet
Source

Code Definition

Code	R9Bturbid
Definition	Saguaro Lake hypolimnion turbidity sample
Source

Code Definition

Code	R9C
Definition	Saguaro Lake near dock
Source

Code Definition

Code	RA Dup
Definition	Saguaro Lake Epilimnion duplicate sample
Source

Code Definition

Code	Roos
Definition	Roosevelt Lake
Source

Code Definition

Code	Roos In
Definition	Salt River Inlet Near Roosevelt Lake
Source

Code Definition

Code	Roosvelt
Definition	SRP above Roosevelt Lake
Source

Code Definition

Code	Salt-Gila
Definition	Salt-Gila Pump Station
Source

Code Definition

Code	Scotts
Definition	AZ Canal at Scottsdale Rd.
Source

Code Definition

Code	SOCA
Definition	South Canal below CAP Cross-connect
Source

Code Definition

Code	SPT In
Definition	Tempe South WTP Inlet
Source

Code Definition

Code	SPT Out
Definition	Tempe South WP Treated
Source

Code Definition

Code	UH In
Definition	Union Hills WTP Inlet
Source

Code Definition

Code	UH Out
Definition	Union Hills WTP Treated
Source

Code Definition

Code	union hills
Definition	union hills water treatment plant impoundment
Source

Code Definition

Code	VV west
Definition	Val Vista West WTP treated water
Source

Definition

site location description

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	cap
Definition	Central Arizona Project canal
Source

Code Definition

Code	salt
Definition	Salt River
Source

Code Definition

Code	srp
Definition	Salt River Project canal
Source

Code Definition

Code	tempe
Definition	Tempe, AZ area canal
Source

Code Definition

Code	verde
Definition	Verde River
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	24th St-treated
Definition	24th St. Water Treatment Plant treated water
Source

Code Definition

Code	Above Roosevelt
Definition	SRP above Roosevelt Lake
Source

Code Definition

Code	Anthem In
Definition	Anthem WTP Inlet
Source

Code Definition

Code	Anthem Out
Definition	Anthem WTP Treated
Source

Code Definition

Code	az canal @ 16th st.
Definition	AZ Canal at 16th Street
Source

Code Definition

Code	az canal @ 19 ave.
Definition	AZ Canal at 19th Avenue
Source

Code Definition

Code	az canal @ 19th av.
Definition	AZ Canal at 19th Avenue
Source

Code Definition

Code	az canal @ 24th St
Definition	AZ Canal at 24th Street
Source

Code Definition

Code	az canal @ 32nd st.
Definition	AZ Canal at 32nd Street
Source

Code Definition

Code	az canal @ 44th st.
Definition	AZ Canal at 44th Street
Source

Code Definition

Code	az canal @ 48th st.
Definition	AZ Canal at 48th Street
Source

Code Definition

Code	az canal @ 56th st.
Definition	AZ Canal at 56th Street
Source

Code Definition

Code	az canal @ 7th av.
Definition	AZ Canal at 7th Avenue
Source

Code Definition

Code	az canal @ central ave.
Definition	ZA Canal at Central Avenue
Source

Code Definition

Code	az canal @ deer valley
Definition	AZ Canal - Inlet to Deer Valley WTP
Source

Code Definition

Code	az canal @ hwy 87
Definition	AZ Canal at Highway 87
Source

Code Definition

Code	az canal @ Mesa
Definition	metadata_not_provided
Source

Code Definition

Code	az canal @ northern
Definition	metadata_not_provided
Source

Code Definition

Code	az canal @ pima
Definition	AZ Canal at Pima Rd
Source

Code Definition

Code	az canal @ scotts.
Definition	metadata_not_provided
Source

Code Definition

Code	az canal @ squaw peak
Definition	AZ Canal - Inlet to Squaw Peak WTP
Source

Code Definition

Code	az canal blw cap
Definition	AZ Canal below CAP Cross-connect
Source

Code Definition

Code	az canal inflow
Definition	AZ Canal above CAP Cross-connect
Source

Code Definition

Code	bartlett-epi
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	bartlett-hypo
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	cap-siphon
Definition	metadata_not_provided
Source

Code Definition

Code	cap @ 7th st
Definition	Cap Canal at 7th St.
Source

Code Definition

Code	cap @ 7th st dup
Definition	Cap Canal at 7th St. duplicate sample
Source

Code Definition

Code	cap @ x con
Definition	CAP Canal at Cross-connect
Source

Code Definition

Code	central & griswold
Definition	metadata_not_provided
Source

Code Definition

Code	Chandler Inlet
Definition	Chandler WTP Inlet
Source

Code Definition

Code	Chandler Treated
Definition	Chandler WTP Treated
Source

Code Definition

Code	deer valley-treated
Definition	Deer Valley WTP treated water
Source

Code Definition

Code	Glen In
Definition	Glendale WTP Inlet
Source

Code Definition

Code	Glen out
Definition	Glendale WTP Treated
Source

Code Definition

Code	Glen Out
Definition	Glendale WTP Treated
Source

Code Definition

Code	Green In
Definition	Greenway WTP Inlet
Source

Code Definition

Code	Green Out
Definition	Greenway WTP Treated
Source

Code Definition

Code	Havasu 1
Definition	Lake Havasu Site 1
Source

Code Definition

Code	Havasu 2
Definition	Lake Havasu Site 2
Source

Code Definition

Code	head of tempe canal
Definition	Head of the Tempe Canal
Source

Code Definition

Code	Head of the Consolidated Canal
Definition	Head of the Consolidated canal
Source

Code Definition

Code	ISTB4
Definition	metadata_not_provided
Source

Code Definition

Code	Middle of the Consolidated Canal
Definition	Middle of the Consolidated canal
Source

Code Definition

Code	MTO
Definition	Mesa Canal Turnout
Source

Code Definition

Code	North plant inlet
Definition	Tempe North WTP inlet
Source

Code Definition

Code	north plant outlet
Definition	Tempe North WTP treated
Source

Code Definition

Code	pleasant-epi
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	pleasant-hypo
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	s canal @ val vista
Definition	South Canal at Val Vista WTP
Source

Code Definition

Code	saguaro-epi
Definition	Saguaro Lake Epilimnion
Source

Code Definition

Code	saguaro-epi dup
Definition	Saguaro Lake Epilimnion duplicate sample
Source

Code Definition

Code	saguaro-hypo
Definition	Saguaro Lake Hypolimnion
Source

Code Definition

Code	salt abv saguaro
Definition	Salt River inlet to Saguaro Lake
Source

Code Definition

Code	salt blw saguaro
Definition	Salt River below Saguaro (Blue Point Bridge)
Source

Code Definition

Code	SGPS
Definition	Salt Gila Pump Station
Source

Code Definition

Code	South canal below CAP
Definition	South Canal below CAP Cross-connect
Source

Code Definition

Code	squaw peak-treated
Definition	Squaw Peak WTP treated water
Source

Code Definition

Code	SRNR
Definition	Salt River Inlet Near Roosevelt Lake
Source

Code Definition

Code	STP In
Definition	Tempe Canal - Inlet to Tempe's South Plant
Source

Code Definition

Code	STP Out
Definition	Tempe's South Plant Treated water
Source

Code Definition

Code	union hills-impound
Definition	union hills water treatment plant impoundment
Source

Code Definition

Code	Union Hills Inlet
Definition	Union Hills WTP Inlet
Source

Code Definition

Code	Union Hills Outlet
Definition	Union Hills WTP Treated
Source

Code Definition

Code	val-vista west
Definition	Val Vista Water Treatment Plant Treated Water - West
Source

Code Definition

Code	val vista-treated
Definition	Val Vista WTP treated water
Source

Code Definition

Code	verde @ beeline
Definition	verde river at beeline highwy
Source

Code Definition

Code	verde above horseshoe
Definition	Verde River at Tangle
Source

Code Definition

Code	verde abv bartlett
Definition	Verde River btwn Horseshoe and Bartlett
Source

Code Definition

Code	verde abv horseshoe
Definition	Verde River at Tangle
Source

Code Definition

Code	verde blw barlett
Definition	Verde River below Bartlett Reservoir
Source

Code Definition

Code	waddell canal
Definition	Waddell Canal
Source

Format	YYYY-MM-DD
Precision

Definition

type of water sample collected (if not a field sample)

Unit	nanogramsPerLiter
Type	real
Min	-2.393036
Max	476.8

Unit	nanogramsPerLiter
Type	real
Min	-5.427595
Max	445.588261

Unit	nanogramsPerLiter
Type	real
Min	-4.081179
Max	87.5

Unit	dimensionless
Type	real
Min	56.2
Max	147

Unit	nanogramsPerLiter
Type	whole
Min	0
Max	52

Unit	nanogramsPerLiter
Type	whole
Min	0
Max	50

Definition

comment(s) about site conditions or sampling details

Missing Value Code:

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/knb-lter-cap/617/6/6e01c81d4b6e51da01c1adb16ff193ab
Name:	617_arsenic_18c9184205e943456921449878002c3a.csv
Description:	arsenic and perchlorate concentrations in canals and reservoirs
Number of Records:	3123
Number of Columns:	8

Table Structure

Object Name:

617_arsenic_18c9184205e943456921449878002c3a.csv

Size:

262394 bytes

Authentication:

18c9184205e943456921449878002c3a Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Column Name:

site number

site location

cluster

site acronym

arsenic (ug/L)

perchlorate (ug/L)

date

BDL

Definition:

site number or name (A designates epilimnion, B hypolimnion)

site location description

source water

site number or name

arsenic concentration as determined by graphite furnace

perchlorate concentration as determined by ion chromatography

sample collection date

1 = sample with arsenic concentration below detectable limit

Storage Type:

string

float

date

string

Measurement Type:

nominal

ratio

dateTime

nominal

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Glen In
Definition	Glendale WTP Inlet
Source

Code Definition

Code	Glen Out
Definition	Glendale WTP Treated
Source

Code Definition

Code	Green In
Definition	Greenway WTP Inlet
Source

Code Definition

Code	Green Out
Definition	Greenway WTP Treated
Source

Code Definition

Code	Havasu 1
Definition	Lake Havasu Site 1
Source

Code Definition

Code	Havasu 2
Definition	Lake Havasu Site 2
Source

Code Definition

Code	HTC
Definition	Head of the Tempe Canal
Source

Code Definition

Code	Hwy 87
Definition	AZ Canal at Highway 87
Source

Code Definition

Code	NP In
Definition	Tempe North WTP Inlet
Source

Code Definition

Code	NP Out
Definition	Tempe North WTP Treated
Source

Code Definition

Code	Pima
Definition	AZ Canal at Pima Rd
Source

Code Definition

Code	R10
Definition	Salt River below Saguaro (Blue Point Bridge)
Source

Code Definition

Code	R11
Definition	CAP Canal at Cross-connect
Source

Code Definition

Code	R12
Definition	AZ Canal above CAP Cross-connect
Source

Code Definition

Code	R13
Definition	AZ Canal below CAP Cross-connect
Source

Code Definition

Code	R14
Definition	AZ Canal - Inlet to Squaw Peak WTP
Source

Code Definition

Code	R15
Definition	Squaw Peak WTP treated water
Source

Code Definition

Code	R16
Definition	AZ Canal - Inlet to Deer Valley WTP
Source

Code Definition

Code	R17
Definition	Deer Valley WTP treated water
Source

Code Definition

Code	R18
Definition	South Canal at Val Vista WTP
Source

Code Definition

Code	R19
Definition	Val Vista WTP treated water
Source

Code Definition

Code	R20
Definition	Verde River at Tangle
Source

Code Definition

Code	R21
Definition	AZ Canal - Central Avenue
Source

Code Definition

Code	R22
Definition	AZ Canal at 56th
Source

Code Definition

Code	R25
Definition	Verde River at Beeline
Source

Code Definition

Code	R2A
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	R2B
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	R3
Definition	Waddell Canal
Source

Code Definition

Code	R6A
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	R6B
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	R9A
Definition	Saguaro Lake near inlet
Source

Code Definition

Code	R9A-Dup
Definition	Saguaro Lake near inlet
Source

Code Definition

Code	R9B
Definition	Saguaro Lake near inlet
Source

Code Definition

Code	SOCA
Definition	South Canal below CAP Cross-connect
Source

Code Definition

Code	SPT In
Definition	Tempe South WTP Inlet
Source

Code Definition

Code	SPT Out
Definition	Tempe South WP Treated
Source

Code Definition

Code	UH In
Definition	Union Hills WTP Inlet
Source

Code Definition

Code	UH Out
Definition	Union Hills WTP Treated
Source

Definition

site location description

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	cap
Definition	Central Arizona Project canal
Source

Code Definition

Code	salt
Definition	Salt River
Source

Code Definition

Code	srp
Definition	Salt River Project canal
Source

Code Definition

Code	tempe
Definition	Tempe, AZ area canal
Source

Code Definition

Code	verde
Definition	Verde River
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	az canal @ 56th st.
Definition	AZ Canal at 56th Street
Source

Code Definition

Code	az canal @ central ave.
Definition	AZ Canal at Central Avenue
Source

Code Definition

Code	az canal @ deer valley
Definition	AZ Canal - Inlet to Deer Valley WTP
Source

Code Definition

Code	az canal @ hwy 87
Definition	AZ Canal at Highway 87
Source

Code Definition

Code	az canal @ pima
Definition	AZ Canal at Pima Rd
Source

Code Definition

Code	az canal @ squaw peak
Definition	AZ Canal - Inlet to Squaw Peak WTP
Source

Code Definition

Code	az canal blw cap
Definition	AZ Canal below CAP Cross-connect
Source

Code Definition

Code	az canal inflow
Definition	AZ Canal above CAP Cross-connect
Source

Code Definition

Code	bartlett-epi
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	bartlett-hypo
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	cap @ x con
Definition	CAP Canal at Cross-connect
Source

Code Definition

Code	deer valley-treated
Definition	Deer Valley WTP treated water
Source

Code Definition

Code	Glen In
Definition	Glendale WTP Inlet
Source

Code Definition

Code	Glen Out
Definition	Glendale WTP Treated
Source

Code Definition

Code	Green In
Definition	Greenway WTP Inlet
Source

Code Definition

Code	Green Out
Definition	Greenway WTP Treated
Source

Code Definition

Code	Havasu 1
Definition	Lake Havasu Site 1
Source

Code Definition

Code	Havasu 2
Definition	Lake Havasu Site 2
Source

Code Definition

Code	head of tempe canal
Definition	Head of Tempe Canal
Source

Code Definition

Code	North plant inlet
Definition	Tempe North WTP Inlet
Source

Code Definition

Code	north plant outlet
Definition	Tempe North WTP Treated
Source

Code Definition

Code	pleasant-epi
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	pleasant-hypo
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	s canal @ val vista
Definition	South Canal at Val Vista WTP
Source

Code Definition

Code	saguaro-epi
Definition	Saguaro Lake Epilimnion
Source

Code Definition

Code	saguaro-epi dup
Definition	Saguaro Lake Epilimnion Duplicate Sample
Source

Code Definition

Code	saguaro-hypo
Definition	Saguaro Lake Hypolimnion
Source

Code Definition

Code	salt blw saguaro
Definition	Salt River below Saguaro (Blue Point Bridge)
Source

Code Definition

Code	South canal below CAP
Definition	South Canal below CAP Cross-connect
Source

Code Definition

Code	SPT In
Definition	Tempe South WTP Inlet
Source

Code Definition

Code	SPT Out
Definition	Tempe South WTP Treated
Source

Code Definition

Code	squaw peak-treated
Definition	Squaw Peak WTP treated water
Source

Code Definition

Code	STP In
Definition	Tempe Canal - Inlet to Tempe's South Plant
Source

Code Definition

Code	STP Out
Definition	Tempe's South Plant treated water
Source

Code Definition

Code	Union Hills Inlet
Definition	Union Hills WTP Inlet
Source

Code Definition

Code	Union Hills Outlet
Definition	Union Hills WTP Treated
Source

Code Definition

Code	val vista-treated
Definition	Val Vista WTP treated water
Source

Code Definition

Code	val vista-treated-West
Definition	Val Vista WTP treated water - west
Source

Code Definition

Code	verde @ beeline
Definition	verde river at beeline highway
Source

Code Definition

Code	verde abv horseshoe
Definition	Verde River at Tangle
Source

Code Definition

Code	waddell canal
Definition	Waddell Canal
Source

Unit	microgramsPerLiter
Type	real
Min	0
Max	32.6

Unit	microgramsPerLiter
Type	real
Min	0
Max	3.77

Format	YYYY-MM-DD
Precision

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	1 = below detectable limits
Source

Missing Value Code:

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/knb-lter-cap/617/6/10a1b29110c0d0674096d14ccf1903c1
Name:	617_carbon_cc0e7f16f828061c7aa3dd325fa9f0ef.csv
Description:	approximately monthly water carbon data in Phoenix-area canals and reservoirs
Number of Records:	12106
Number of Columns:	17

Table Structure

Object Name:

617_carbon_cc0e7f16f828061c7aa3dd325fa9f0ef.csv

Size:

1431702 bytes

Authentication:

cc0e7f16f828061c7aa3dd325fa9f0ef Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Column Name:

site number

site location

cluster

site acronym

date

sample type

TOC (mg/L)

DOC (mg/L)

UVA (cm-1)

suva (L/mg-m)

peak int

peak int WL

int at 450

int at 460

int at 500

FI (450/500)

docm comments

Definition:

site number or name (A designates epilimnion, B hypolimnion)

site location description

source water

site number or name

sample collection date

type of water sample collected (if not a field sample)

total organic carbon

dissolved organic carbon

UV absorbance measured at 254 nanometers

specific ultraviolet absorbance

intensity of peak

wavelength at the highest peak intensity

intensity at 450 nanometers

intensity at 460 nanometers

intensity at 500 nanometers

fluorescence ratio of 450/500

comment(s) about site conditions or sampling details

Storage Type:

string

date

string

float

string

Measurement Type:

nominal

dateTime

nominal

ratio

nominal

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	16th St.
Definition	AZ Canal at 16th Street
Source

Code Definition

Code	19th Av.
Definition	AZ Canal at 19th Avenue
Source

Code Definition

Code	An in
Definition	Anthem WTP Inlet
Source

Code Definition

Code	AN in
Definition	Anthem WTP Inlet
Source

Code Definition

Code	AN IN
Definition	Anthem WTP Inlet
Source

Code Definition

Code	An out
Definition	Anthem WTP Treated
Source

Code Definition

Code	AN out
Definition	Anthem WTP Treated
Source

Code Definition

Code	AN OUT
Definition	Anthem WTP Treated
Source

Code Definition

Code	Ch in
Definition	Chandler WTP Inlet
Source

Code Definition

Code	CH in
Definition	Chandler WTP Inlet
Source

Code Definition

Code	CH IN
Definition	Chandler WTP Inlet
Source

Code Definition

Code	Ch out
Definition	Chandler WTP Treated
Source

Code Definition

Code	CH out
Definition	Chandler WTP Treated
Source

Code Definition

Code	CH OUT
Definition	Chandler WTP Treated
Source

Code Definition

Code	Cons
Definition	Consolidated Canal
Source

Code Definition

Code	field_blank
Definition	Field blank
Source

Code Definition

Code	Gila Salt
Definition	Salt-Gila Pump Station
Source

Code Definition

Code	GL IN
Definition	Glendale WTP Inlet
Source

Code Definition

Code	GL OUT
Definition	Glendale WTP Treated
Source

Code Definition

Code	Glen In
Definition	Glendale WTP Inlet
Source

Code Definition

Code	Glen Out
Definition	Glendale WTP Treated
Source

Code Definition

Code	GR IN
Definition	Greenway WTP Inlet
Source

Code Definition

Code	GR OUT
Definition	Greenway WTP Treated
Source

Code Definition

Code	Green In
Definition	Greenway WTP Inlet
Source

Code Definition

Code	Green Out
Definition	Greenway WTP Treated
Source

Code Definition

Code	HAV
Definition	Lake Havasu
Source

Code Definition

Code	Havasu 1
Definition	Lake Havasu Site 1
Source

Code Definition

Code	Havasu 2
Definition	Lake Havasu Site 2
Source

Code Definition

Code	HOC
Definition	Head of the Consolidated canal
Source

Code Definition

Code	HTC
Definition	Head of the Tempe Canal
Source

Code Definition

Code	Hwy 87
Definition	AZ Canal at Highway 87
Source

Code Definition

Code	HWY 87
Definition	AZ Canal at Highway 87
Source

Code Definition

Code	lab_blank
Definition	Laboratory blank
Source

Code Definition

Code	Mesa
Definition	AZ Canal at Mesa Dr.
Source

Code Definition

Code	Mesa Turnout
Definition	Mesa Canal Turnout
Source

Code Definition

Code	MOC
Definition	Middle of the Consolidated canal
Source

Code Definition

Code	MTO
Definition	Mesa Canal Turnout
Source

Code Definition

Code	NP In
Definition	Tempe North WTP Inlet
Source

Code Definition

Code	NP IN
Definition	Tempe North WTP Inlet
Source

Code Definition

Code	NP Out
Definition	Tempe North WTP Treated
Source

Code Definition

Code	NP OUT
Definition	Tempe North WTP Treated
Source

Code Definition

Code	Pima
Definition	AZ Canal at Pima Rd
Source

Code Definition

Code	PIMA
Definition	AZ Canal at Pima Rd
Source

Code Definition

Code	R1
Definition	CAP canal above Waddell Canal
Source

Code Definition

Code	R10
Definition	Salt River below Saguaro (Blue Point Bridge)
Source

Code Definition

Code	R11
Definition	CAP Canal at Cross-connect
Source

Code Definition

Code	R12
Definition	AZ Canal above CAP Cross-connect
Source

Code Definition

Code	R13
Definition	AZ Canal below CAP Cross-connect
Source

Code Definition

Code	R14
Definition	AZ Canal - Inlet to Squaw Peak WTP
Source

Code Definition

Code	R15
Definition	Squaw Peak WTP treated water
Source

Code Definition

Code	R16
Definition	AZ Canal - Inlet to Deer Valley WTP
Source

Code Definition

Code	R17
Definition	Deer Valley WTP treated water
Source

Code Definition

Code	R18
Definition	South Canal at Val Vista WTP
Source

Code Definition

Code	R19
Definition	Val Vista WTP treated water
Source

Code Definition

Code	R20
Definition	Verde River at Tangle
Source

Code Definition

Code	R20ex
Definition	Verde River at Tangle Creek extra sample
Source

Code Definition

Code	R21
Definition	AZ Canal - Central Avenue
Source

Code Definition

Code	R22
Definition	AZ Canal at 56th
Source

Code Definition

Code	R25
Definition	Verde River at Beeline
Source

Code Definition

Code	R26
Definition	AZ Canal at 19th Ave.
Source

Code Definition

Code	R2A
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	R2B
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	R3
Definition	Waddell Canal
Source

Code Definition

Code	R4
Definition	Cap Canal at 7th St.
Source

Code Definition

Code	R4-Dup
Definition	Cap Canal at 7th St. Duplicate Sample
Source

Code Definition

Code	R5
Definition	Verde River btwn Horseshoe and Bartlett
Source

Code Definition

Code	R5ex
Definition	Verde River btwn Horseshoe and Bartlett extra sample
Source

Code Definition

Code	R6A
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	R6B
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	R6C
Definition	Bartlett Lake near dock
Source

Code Definition

Code	R7
Definition	Verde River below Bartlett Reservoir
Source

Code Definition

Code	R7ex
Definition	Verde River below Bartlett Reservoir extra sample
Source

Code Definition

Code	R8
Definition	Salt River inlet to Saguaro Lake
Source

Code Definition

Code	R9A
Definition	Saguaro Lake near inlet
Source

Code Definition

Code	R9A-Dup
Definition	Saguaro Lake near inlet duplicate sample
Source

Code Definition

Code	R9A-DUP
Definition	Saguaro Lake near inlet duplicate sample
Source

Code Definition

Code	R9B
Definition	Saguaro Lake near inlet
Source

Code Definition

Code	R9C
Definition	Saguaro Lake near dock
Source

Code Definition

Code	Roos In
Definition	Salt River Inlet Near Roosevelt Lake
Source

Code Definition

Code	Roosvelt
Definition	SRP above Roosevelt Lake
Source

Code Definition

Code	Salt Gila
Definition	Salt-Gila Pump Station
Source

Code Definition

Code	Scotts
Definition	AZ Canal at Scottsdale Rd.
Source

Code Definition

Code	SGPS
Definition	Salt Gila Pump Station
Source

Code Definition

Code	SOCA
Definition	South Canal below CAP Cross-connect
Source

Code Definition

Code	SPT In
Definition	Tempe South WTP Inlet
Source

Code Definition

Code	SPT IN
Definition	Tempe South WTP Inlet
Source

Code Definition

Code	SPT Out
Definition	Tempe South WP Treated
Source

Code Definition

Code	SPT OUT
Definition	Tempe South WP Treated
Source

Code Definition

Code	SRNR
Definition	Salt River Inlet Near Roosevelt Lake
Source

Code Definition

Code	UH In
Definition	Union Hills WTP Inlet
Source

Code Definition

Code	UH IN
Definition	Union Hills WTP Inlet
Source

Code Definition

Code	UH Out
Definition	Union Hills WTP Treated
Source

Code Definition

Code	UH OUT
Definition	Union Hills WTP Treated
Source

Code Definition

Code	VV West
Definition	Val Vista West WTP treated water
Source

Definition

site location description

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	az canal
Definition	Arizona canal
Source

Code Definition

Code	cap
Definition	Central Arizona Project canal
Source

Code Definition

Code	chandler
Definition	metadata_not_provided
Source

Code Definition

Code	mesa turnout
Definition	metadata_not_provided
Source

Code Definition

Code	salt
Definition	Salt River
Source

Code Definition

Code	srp
Definition	Salt River Project canal
Source

Code Definition

Code	tempe
Definition	Tempe, AZ area canal
Source

Code Definition

Code	verde
Definition	Verde River
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	24th In
Definition	AZ Canal - Inlet to 24th St Water Treatment Plant
Source

Code Definition

Code	24th Out
Definition	24th St Water Treatment Plant treated water
Source

Code Definition

Code	24th St -treated
Definition	24th St. Water Treatment Plant treated water
Source

Code Definition

Code	Above Roosevelt
Definition	SRP above Roosevelt Lake
Source

Code Definition

Code	anthem
Definition	Anthem Water Treatment Plant
Source

Code Definition

Code	anthem inlet
Definition	Anthem WTP Inlet
Source

Code Definition

Code	anthem treated
Definition	Anthem WTP Treated
Source

Code Definition

Code	az canal @ 16th st.
Definition	AZ Canal at 16th Street
Source

Code Definition

Code	az canal @ 19 ave.
Definition	AZ Canal at 19th Avenue
Source

Code Definition

Code	az canal @ 19th av.
Definition	AZ Canal at 19th Avenue
Source

Code Definition

Code	az canal @ 24th St
Definition	AZ Canal at 24th Street
Source

Code Definition

Code	az canal @ 56th st.
Definition	AZ Canal at 56th Street
Source

Code Definition

Code	az canal @ central ave.
Definition	AZ Canal at Central Avenue
Source

Code Definition

Code	az canal @ deer valley
Definition	AZ Canal - Inlet to Deer Valley WTP
Source

Code Definition

Code	az canal @ hwy 87
Definition	AZ Canal at Highway 87
Source

Code Definition

Code	az canal @ Mesa
Definition	AZ Canal at Mesa Dr.
Source

Code Definition

Code	az canal @ pima
Definition	AZ Canal at Pima Rd
Source

Code Definition

Code	az canal @ scotts.
Definition	AZ Canal at Scottsdale Rd.
Source

Code Definition

Code	az canal @ squaw peak
Definition	AZ Canal - Inlet to Squaw Peak WTP
Source

Code Definition

Code	az canal blw cap
Definition	AZ Canal below CAP Cross-connect
Source

Code Definition

Code	az canal inflow
Definition	AZ Canal above CAP Cross-connect
Source

Code Definition

Code	bartlett-dock
Definition	Bartlett Lake dock sample
Source

Code Definition

Code	bartlett-epi
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	bartlett-hypo
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	cap-siphon
Definition	metadata_not_provided
Source

Code Definition

Code	cap @ 7th st
Definition	Cap Canal at 7th St.
Source

Code Definition

Code	cap @ 7th st dup
Definition	Cap Canal at 7th St. Duplicate Sample
Source

Code Definition

Code	cap @ x con
Definition	CAP Canal at Cross-connect
Source

Code Definition

Code	chandler
Definition	Chandler WTP
Source

Code Definition

Code	chandler inlet
Definition	Chandler WTP Inlet
Source

Code Definition

Code	chandler treated
Definition	Chandler WTP Treated
Source

Code Definition

Code	deer valley-treated
Definition	Deer Valley WTP treated water
Source

Code Definition

Code	field
Definition	Field Blank
Source

Code Definition

Code	Glen In
Definition	Glendale WTP Inlet
Source

Code Definition

Code	Glen Out
Definition	Glendale WTP Treated
Source

Code Definition

Code	Green In
Definition	Greenway WTP Inlet
Source

Code Definition

Code	Green Out
Definition	Greenway WTP Treated
Source

Code Definition

Code	Havasu
Definition	Lake Havasu
Source

Code Definition

Code	Havasu 1
Definition	Lake Havasu Site 1
Source

Code Definition

Code	Havasu 2
Definition	Lake Havasu Site 2
Source

Code Definition

Code	head of tempe canal
Definition	Head of Tempe Canal
Source

Code Definition

Code	head of the consolidated canal
Definition	Head of the Consolidated canal
Source

Code Definition

Code	lab
Definition	Laboratory blank
Source

Code Definition

Code	Mesa Turnout
Definition	Mesa Canal Turnout
Source

Code Definition

Code	middle of the consolidated canal
Definition	Middle of the Consolidated canal
Source

Code Definition

Code	North plant inlet
Definition	Tempe North WTP Inlet
Source

Code Definition

Code	north plant outlet
Definition	Tempe North WTP Treated
Source

Code Definition

Code	pleasant-epi
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	pleasant-hypo
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	Roos In
Definition	Salt River Inlet Near Roosevelt Lake
Source

Code Definition

Code	s canal @ val vista
Definition	South Canal at Val Vista WTP
Source

Code Definition

Code	saguaro-epi
Definition	Saguaro Lake Epilimnion
Source

Code Definition

Code	saguaro-epi dup
Definition	Saguaro Lake Epilimnion Duplicate Sample
Source

Code Definition

Code	saguaro-hypo
Definition	Saguaro Lake Hypolimnion
Source

Code Definition

Code	salt abv saguaro
Definition	Salt River inlet to Saguaro Lake
Source

Code Definition

Code	salt blw saguaro
Definition	Salt River below Saguaro (Blue Point Bridge)
Source

Code Definition

Code	Salt Gila
Definition	Salt-Gila Pump Station
Source

Code Definition

Code	saugaro-dock
Definition	Saguaro Lake dock sample
Source

Code Definition

Code	South canal below CAP
Definition	South Canal below CAP Cross-connect
Source

Code Definition

Code	squaw peak-treated
Definition	Squaw Peak WTP treated water
Source

Code Definition

Code	SRNR
Definition	Salt River Inlet Near Roosevelt Lake
Source

Code Definition

Code	STP In
Definition	Tempe Canal - Inlet to Tempe's South Plant
Source

Code Definition

Code	STP Out
Definition	Tempe's South Plant treated water
Source

Code Definition

Code	Union Hills Inlet
Definition	Union Hills WTP Inlet
Source

Code Definition

Code	Union Hills Outlet
Definition	Union Hills WTP Treated
Source

Code Definition

Code	val vista-treated
Definition	Val Vista WTP treated water
Source

Code Definition

Code	val vista west-treated
Definition	Val Vista WTP treated water - west
Source

Code Definition

Code	verde @ beeline
Definition	verde river at beeline highway
Source

Code Definition

Code	verde abv bartlett
Definition	Verde River btwn Horseshoe and Bartlett
Source

Code Definition

Code	verde abv horseshoe
Definition	Verde River at Tangle
Source

Code Definition

Code	verde blw barlett
Definition	Verde River below Bartlett Reservoir
Source

Code Definition

Code	waddell canal
Definition	Waddell Canal
Source

Format	YYYY-MM-DD
Precision

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	-
Definition	metadata_not_provided
Source

Code Definition

Code	extra sample
Definition	Extra sample collected
Source

Code Definition

Code	field blank
Definition	Field blank
Source

Code Definition

Code	field duplicate
Definition	Field duplicate sample
Source

Code Definition

Code	lab blank
Definition	Laboratory blank
Source

Code Definition

Code	no water
Definition	Dry, no water
Source

Code Definition

Code	not available
Definition	Not available
Source

Code Definition

Code	offline
Definition	Water treatment plant offline
Source

Code Definition

Code	Rain event
Definition	Rain event
Source

Unit	milligramsPerLiter
Type	real
Min	0
Max	26.17

Unit	milligramsPerLiter
Type	real
Min	0
Max	34.5

Unit	perCentimeter
Type	real
Min	0.0011
Max	4.8

Unit	literPerMilligramMeter
Type	real
Min	0
Max	24.126984

Unit	dimensionless
Type	real
Min	1.52
Max	255.17

Unit	nanometer
Type	real
Min	432.78
Max	4448.21

Unit	dimensionless
Type	real
Min	0.44
Max	254.12

Unit	dimensionless
Type	real
Min	0.24
Max	245.32

Unit	dimensionless
Type	real
Min	0.05
Max	156.65

Unit	dimensionless
Type	real
Min	0
Max	2.86

Definition

comment(s) about site conditions or sampling details

Missing Value Code:

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/knb-lter-cap/617/6/1ecb5793178e33b310ad260fc1c92629
Name:	617_field_measurements_61820cda981b4135b9b2efdc641bacc2.csv
Description:	water quality parameters as measured in the field in canals and reservoirs
Number of Records:	15608
Number of Columns:	12

Table Structure

Object Name:

617_field_measurements_61820cda981b4135b9b2efdc641bacc2.csv

Size:

1496480 bytes

Authentication:

61820cda981b4135b9b2efdc641bacc2 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Column Name:

site number

site location

cluster

site acronym

date

depth (m)

T (C)

DO (mg/l)

Secchi disk (m)

samples collected

comments

Definition:

site number or name (A designates epilimnion, B hypolimnion)

site location description

source water

site number or name

sample collection date

water depth where measurement was taken (0 designates just below surface)

water temperature

dissolved oxygen

water transparency measurement as measured from side of boat

types of analyses for which samples were collected

comment(s) about site conditions or sampling details

Storage Type:

string

date

float

string

Measurement Type:

nominal

dateTime

ratio

nominal

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	16th St.
Definition	AZ Canal at 16th Street
Source

Code Definition

Code	19th Av.
Definition	AZ Canal at 19th Avenue
Source

Code Definition

Code	Apa-0
Definition	Apache Lake at surface
Source

Code Definition

Code	Apa-10
Definition	Apache Lake at 10m depth
Source

Code Definition

Code	Apa-15
Definition	Apache Lake at 15m depth
Source

Code Definition

Code	Apa-20
Definition	Apache Lake at 20m depth
Source

Code Definition

Code	Apa-25
Definition	Apache Lake at 25m depth
Source

Code Definition

Code	Apa-30
Definition	Apache Lake at 30m depth
Source

Code Definition

Code	Apa-35
Definition	Apache Lake at 35m depth
Source

Code Definition

Code	Apa-40
Definition	Apache Lake at 40m depth
Source

Code Definition

Code	Apa-45
Definition	Apache Lake at 45m depth
Source

Code Definition

Code	Apa-5
Definition	Apache Lake at 5m depth
Source

Code Definition

Code	Apa-50
Definition	Apache Lake at 50m depth
Source

Code Definition

Code	Apa-55
Definition	Apache Lake at 55m depth
Source

Code Definition

Code	Can-0
Definition	Canyon Lake at surface
Source

Code Definition

Code	Can-10
Definition	Canyon Lake at 10m depth
Source

Code Definition

Code	Can-15
Definition	Canyon Lake at 15m depth
Source

Code Definition

Code	Can-20
Definition	Canyon Lake at 20m depth
Source

Code Definition

Code	Can-25
Definition	Canyon Lake at 25m depth
Source

Code Definition

Code	Can-30
Definition	Canyon Lake at 30m depth
Source

Code Definition

Code	Can-35
Definition	Canyon Lake at 35m depth
Source

Code Definition

Code	Can-40
Definition	Canyon Lake at 40m depth
Source

Code Definition

Code	Can-45
Definition	Canyon Lake at 45m depth
Source

Code Definition

Code	Can-5
Definition	Canyon Lake at 5m depth
Source

Code Definition

Code	Can-50
Definition	Canyon Lake at 50m depth
Source

Code Definition

Code	Cons
Definition	Consolidated Canal
Source

Code Definition

Code	Glen In
Definition	Glendale WTP Inlet
Source

Code Definition

Code	Glen Out
Definition	Glendale WTP Treated
Source

Code Definition

Code	Green In
Definition	Greenway WTP Inlet
Source

Code Definition

Code	Green Out
Definition	Greenway WTP Treated
Source

Code Definition

Code	Havasu 1
Definition	Lake Havasu Site 1
Source

Code Definition

Code	Havasu 2
Definition	Lake Havasu Site 2
Source

Code Definition

Code	HTC
Definition	Head of Tempe Canal
Source

Code Definition

Code	Hwy 87
Definition	AZ Canal at Highway 87
Source

Code Definition

Code	Mesa
Definition	AZ Canal at Mesa Dr.
Source

Code Definition

Code	NP In
Definition	Tempe North WTP Inlet
Source

Code Definition

Code	NP Out
Definition	Tempe North WTP Treated
Source

Code Definition

Code	Pima
Definition	AZ Canal at Pima Rd
Source

Code Definition

Code	R1
Definition	CAP canal above Waddell Canal
Source

Code Definition

Code	R10
Definition	Salt River below Saguaro (Blue Point Bridge)
Source

Code Definition

Code	R11
Definition	CAP Canal at Cross-connect
Source

Code Definition

Code	R12
Definition	AZ Canal above CAP Cross-connect
Source

Code Definition

Code	R13
Definition	AZ Canal below CAP Cross-connect
Source

Code Definition

Code	R14
Definition	AZ Canal - Inlet to Squaw Peak WTP
Source

Code Definition

Code	R15
Definition	Squaw Peak WTP treated water
Source

Code Definition

Code	R16
Definition	AZ Canal - Inlet to Deer Valley WTP
Source

Code Definition

Code	R17
Definition	Deer Valley WTP treated water
Source

Code Definition

Code	R18
Definition	South Canal at Val Vista WTP
Source

Code Definition

Code	R19
Definition	Val Vista WTP treated water
Source

Code Definition

Code	R2
Definition	Lake Pleasant at surface
Source

Code Definition

Code	R2-10
Definition	Lake Pleasant at 10m depth
Source

Code Definition

Code	R2-15
Definition	Lake Pleasant at 15m depth
Source

Code Definition

Code	R2-20
Definition	Lake Pleasant at 20m depth
Source

Code Definition

Code	R2-25
Definition	Lake Pleasant at 25m depth
Source

Code Definition

Code	R2-30
Definition	Lake Pleasant at 30m depth
Source

Code Definition

Code	R2-35
Definition	Lake Pleasant at 35m depth
Source

Code Definition

Code	R2-40
Definition	Lake Pleasant at 40m depth
Source

Code Definition

Code	R2-45
Definition	Lake Pleasant at 45m depth
Source

Code Definition

Code	R2-5
Definition	Lake Pleasant at 5m depth
Source

Code Definition

Code	R2-50
Definition	Lake Pleasant at 50m depth
Source

Code Definition

Code	R2-55
Definition	Lake Pleasant at 55m depth
Source

Code Definition

Code	R20
Definition	Verde River at Tangle
Source

Code Definition

Code	R21
Definition	AZ Canal - Central Avenue
Source

Code Definition

Code	R22
Definition	AZ Canal at 56th
Source

Code Definition

Code	R25
Definition	Verde River at Beeline
Source

Code Definition

Code	R26
Definition	Arizona Canal at 19th Ave.
Source

Code Definition

Code	R2A
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	R3
Definition	Waddell Canal
Source

Code Definition

Code	R4
Definition	Cap Canal at 7th St.
Source

Code Definition

Code	R4-Dup
Definition	Cap Canal at 7th St. duplicate sample
Source

Code Definition

Code	R5
Definition	Verde River btwn Horseshoe and Bartlett
Source

Code Definition

Code	R6-10
Definition	Bartlett Lake at 10m depth
Source

Code Definition

Code	R6-15
Definition	Bartlett Lake at 15m depth
Source

Code Definition

Code	R6-20
Definition	Bartlett Lake at 20m depth
Source

Code Definition

Code	R6-25
Definition	Bartlett Lake at 25m depth
Source

Code Definition

Code	R6-30
Definition	Bartlett Lake at 30m depth
Source

Code Definition

Code	R6-35
Definition	Bartlett Lake at 35m depth
Source

Code Definition

Code	R6-40
Definition	Bartlett Lake at 40m depth
Source

Code Definition

Code	R6-45
Definition	Bartlett Lake at 45m depth
Source

Code Definition

Code	R6-5
Definition	Bartlett Lake at 5m depth
Source

Code Definition

Code	R6-50
Definition	Bartlett Lake at 50m depth
Source

Code Definition

Code	R6-55
Definition	Bartlett Lake at 55m depth
Source

Code Definition

Code	R6A
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	R7
Definition	Verde River below Bartlett Reservoir
Source

Code Definition

Code	R8
Definition	Salt River inlet to Saguaro Lake
Source

Code Definition

Code	R9-10
Definition	Saguaro Lake at 10m depth
Source

Code Definition

Code	R9-15
Definition	Saguaro Lake at 15m depth
Source

Code Definition

Code	R9-20
Definition	Saguaro Lake at 20m depth
Source

Code Definition

Code	R9-25
Definition	Saguaro Lake at 25m depth
Source

Code Definition

Code	R9-30
Definition	Saguaro Lake at 30m depth
Source

Code Definition

Code	R9-35
Definition	Saguaro Lake at 35m depth
Source

Code Definition

Code	R9-40
Definition	Saguaro Lake at 40m depth
Source

Code Definition

Code	R9-45
Definition	Saguaro Lake at 45m depth
Source

Code Definition

Code	R9-5
Definition	Saguaro Lake at 5m depth
Source

Code Definition

Code	R9-50
Definition	Saguaro Lake at 50m depth
Source

Code Definition

Code	R9-55
Definition	Saguaro Lake at 55m depth
Source

Code Definition

Code	R9A
Definition	Saguaro Lake near inlet
Source

Code Definition

Code	Roos-0
Definition	Roosevelt Lake at surface
Source

Code Definition

Code	Roos-10
Definition	Roosevelt Lake at 10m depth
Source

Code Definition

Code	Roos-15
Definition	Roosevelt Lake at 15m depth
Source

Code Definition

Code	Roos-20
Definition	Roosevelt Lake at 20m depth
Source

Code Definition

Code	Roos-25
Definition	Roosevelt Lake at 25m depth
Source

Code Definition

Code	Roos-30
Definition	Roosevelt Lake at 30m depth
Source

Code Definition

Code	Roos-35
Definition	Roosevelt Lake at 35m depth
Source

Code Definition

Code	Roos-40
Definition	Roosevelt Lake at 40m depth
Source

Code Definition

Code	Roos-45
Definition	Roosevelt Lake at 45m depth
Source

Code Definition

Code	Roos-5
Definition	Roosevelt Lake at 5m depth
Source

Code Definition

Code	Roos-50
Definition	Roosevelt Lake at 50m depth
Source

Code Definition

Code	Roosvelt
Definition	SRP above Roosevelt Lake
Source

Code Definition

Code	Scotts
Definition	AZ Canal at Scottsdale Rd.
Source

Code Definition

Code	SOCA
Definition	South Canal below CAP Cross-connect
Source

Code Definition

Code	SPT In
Definition	Tempe South WTP Inlet
Source

Code Definition

Code	SPT Out
Definition	Tempe South WP Treated
Source

Code Definition

Code	UH In
Definition	Union Hills WTP Inlet
Source

Code Definition

Code	UH Out
Definition	Union Hills WTP Treated
Source

Definition

site location description

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	cap
Definition	Central Arizona Project canal
Source

Code Definition

Code	salt
Definition	Salt River
Source

Code Definition

Code	srp
Definition	Salt River Project canal
Source

Code Definition

Code	tempe
Definition	Tempe, AZ area canal
Source

Code Definition

Code	verde
Definition	Verde River
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Above Roosevelt
Definition	metadata_not_provided
Source

Code Definition

Code	Apa-0m
Definition	Apache Lake at surface
Source

Code Definition

Code	Apa-10m
Definition	Apache Lake at 10m depth
Source

Code Definition

Code	Apa-15m
Definition	Apache Lake at 15m depth
Source

Code Definition

Code	Apa-20m
Definition	Apache Lake at 20m depth
Source

Code Definition

Code	Apa-25m
Definition	Apache Lake at 25m depth
Source

Code Definition

Code	Apa-30m
Definition	Apache Lake at 30m depth
Source

Code Definition

Code	Apa-35m
Definition	Apache Lake at 35m depth
Source

Code Definition

Code	Apa-40m
Definition	Apache Lake at 40m depth
Source

Code Definition

Code	Apa-45m
Definition	Apache Lake at 45m depth
Source

Code Definition

Code	Apa-50m
Definition	Apache Lake at 50m depth
Source

Code Definition

Code	Apa-55m
Definition	Apache Lake at 55m depth
Source

Code Definition

Code	Apa-5m
Definition	Apache Lake at 5m depth
Source

Code Definition

Code	Apache-0m
Definition	Apache Lake at surface
Source

Code Definition

Code	Apache-10m
Definition	Apache Lake at 10m depth
Source

Code Definition

Code	Apache-15m
Definition	Apache Lake at 15m depth
Source

Code Definition

Code	Apache-20m
Definition	Apache Lake at 20m depth
Source

Code Definition

Code	Apache-25m
Definition	Apache Lake at 25m depth
Source

Code Definition

Code	Apache-30m
Definition	Apache Lake at 30m depth
Source

Code Definition

Code	Apache-35m
Definition	Apache Lake at 35m depth
Source

Code Definition

Code	Apache-40m
Definition	Apache Lake at 40m depth
Source

Code Definition

Code	Apache-45m
Definition	Apache Lake at 45m depth
Source

Code Definition

Code	Apache-50m
Definition	Apache Lake at 50m depth
Source

Code Definition

Code	Apache-5m
Definition	Apache Lake at 5m depth
Source

Code Definition

Code	az canal @ 16th st.
Definition	AZ Canal at 16th Street
Source

Code Definition

Code	az canal @ 19 ave.
Definition	AZ Canal at 19th Avenue
Source

Code Definition

Code	az canal @ 19th av.
Definition	AZ Canal at 19th Avenue
Source

Code Definition

Code	az canal @ 56th st.
Definition	AZ Canal at 56th Street
Source

Code Definition

Code	az canal @ central ave.
Definition	AZ Canal at Central Avenue
Source

Code Definition

Code	az canal @ deer valley
Definition	AZ Canal - Inlet to Deer Valley WTP
Source

Code Definition

Code	az canal @ hwy 87
Definition	AZ Canal at Highway 87
Source

Code Definition

Code	az canal @ Mesa
Definition	AZ Canal at Mesa Dr.
Source

Code Definition

Code	az canal @ pima
Definition	AZ Canal at Pima Rd
Source

Code Definition

Code	az canal @ scotts.
Definition	AZ Canal at Scottsdale Rd.
Source

Code Definition

Code	az canal @ squaw peak
Definition	AZ Canal - Inlet to Squaw Peak WTP
Source

Code Definition

Code	az canal blw cap
Definition	AZ Canal below CAP Cross-connect
Source

Code Definition

Code	az canal inflow
Definition	AZ Canal above CAP Cross-connect
Source

Code Definition

Code	bartlett-0m
Definition	Bartlett Lake at surface
Source

Code Definition

Code	bartlett-10m
Definition	Bartlett Lake at 10m depth
Source

Code Definition

Code	bartlett-15m
Definition	Bartlett Lake at 15m depth
Source

Code Definition

Code	bartlett-20m
Definition	Bartlett Lake at 20m depth
Source

Code Definition

Code	bartlett-25m
Definition	Bartlett Lake at 25m depth
Source

Code Definition

Code	bartlett-30m
Definition	Bartlett Lake at 30m depth
Source

Code Definition

Code	bartlett-35m
Definition	Bartlett Lake at 35m depth
Source

Code Definition

Code	bartlett-40m
Definition	Bartlett Lake at 40m depth
Source

Code Definition

Code	bartlett-45m
Definition	Bartlett Lake at 45m depth
Source

Code Definition

Code	bartlett-50m
Definition	Bartlett Lake at 50m depth
Source

Code Definition

Code	bartlett-55m
Definition	Bartlett Lake at 55m depth
Source

Code Definition

Code	bartlett-5m
Definition	Bartlett Lake at 5m depth
Source

Code Definition

Code	Can-0m
Definition	Canyon Lake at surface
Source

Code Definition

Code	Can-10m
Definition	Canyon Lake at 10m depth
Source

Code Definition

Code	Can-15m
Definition	Canyon Lake at 15m depth
Source

Code Definition

Code	Can-20m
Definition	Canyon Lake at 20m depth
Source

Code Definition

Code	Can-25m
Definition	Canyon Lake at 25m depth
Source

Code Definition

Code	Can-30m
Definition	Canyon Lake at 30m depth
Source

Code Definition

Code	Can-35m
Definition	Canyon Lake at 35m depth
Source

Code Definition

Code	Can-40m
Definition	Canyon Lake at 40m depth
Source

Code Definition

Code	Can-45m
Definition	Canyon Lake at 45m depth
Source

Code Definition

Code	Can-50m
Definition	Canyon Lake at 50m depth
Source

Code Definition

Code	Can-5m
Definition	Canyon Lake at 5m depth
Source

Code Definition

Code	Canyon-0m
Definition	Canyon Lake at surface
Source

Code Definition

Code	Canyon-10m
Definition	Canyon Lake at 10m depth
Source

Code Definition

Code	Canyon-15m
Definition	Canyon Lake at 15m depth
Source

Code Definition

Code	Canyon-20m
Definition	Canyon Lake at 20m depth
Source

Code Definition

Code	Canyon-25m
Definition	Canyon Lake at 25m depth
Source

Code Definition

Code	Canyon-30m
Definition	Canyon Lake at 30m depth
Source

Code Definition

Code	Canyon-35m
Definition	Canyon Lake at 35m depth
Source

Code Definition

Code	Canyon-40m
Definition	Canyon Lake at 40m depth
Source

Code Definition

Code	Canyon-45m
Definition	Canyon Lake at 45m depth
Source

Code Definition

Code	Canyon-50m
Definition	Canyon Lake at 50m depth
Source

Code Definition

Code	Canyon-5m
Definition	Canyon Lake at 5m depth
Source

Code Definition

Code	cap-siphon
Definition	metadata_not_provided
Source

Code Definition

Code	cap @ 7th st
Definition	Cap Canal at 7th St.
Source

Code Definition

Code	cap @ 7th st dup
Definition	Cap Canal at 7th St. duplicate sample
Source

Code Definition

Code	cap @ x con
Definition	CAP Canal at Cross-connect
Source

Code Definition

Code	deer valley-treated
Definition	Deer Valley WTP treated water
Source

Code Definition

Code	Glen In
Definition	Glendale WTP Inlet
Source

Code Definition

Code	Glen Out
Definition	Glendale WTP Treated
Source

Code Definition

Code	Green In
Definition	Greenway WTP Inlet
Source

Code Definition

Code	Green Out
Definition	Greenway WTP Treated
Source

Code Definition

Code	Havasu 1
Definition	Lake Havasu Site 1
Source

Code Definition

Code	Havasu 2
Definition	Lake Havasu Site 2
Source

Code Definition

Code	head of tempe canal
Definition	Head of Tempe Canal
Source

Code Definition

Code	North plant inlet
Definition	Tempe North WTP Inlet
Source

Code Definition

Code	north plant outlet
Definition	Tempe North WTP Treated
Source

Code Definition

Code	pleasant
Definition	Lake Pleasant
Source

Code Definition

Code	pleasant-0m
Definition	Lake Pleasant at surface
Source

Code Definition

Code	pleasant-10m
Definition	Lake Pleasant at 10m depth
Source

Code Definition

Code	pleasant-15m
Definition	Lake Pleasant at 15m depth
Source

Code Definition

Code	pleasant-20m
Definition	Lake Pleasant at 20m depth
Source

Code Definition

Code	pleasant-25m
Definition	Lake Pleasant at 25m depth
Source

Code Definition

Code	pleasant-30m
Definition	Lake Pleasant at 30m depth
Source

Code Definition

Code	pleasant-35m
Definition	Lake Pleasant at 35m depth
Source

Code Definition

Code	pleasant-40m
Definition	Lake Pleasant at 40m depth
Source

Code Definition

Code	pleasant-45m
Definition	Lake Pleasant at 45m depth
Source

Code Definition

Code	pleasant-50m
Definition	Lake Pleasant at 50m depth
Source

Code Definition

Code	pleasant-55m
Definition	Lake Pleasant at 55m depth
Source

Code Definition

Code	pleasant-5m
Definition	Lake Pleasant at 5m depth
Source

Code Definition

Code	Roos-0m
Definition	Roosevelt Lake at surface
Source

Code Definition

Code	Roos-10m
Definition	Roosevelt Lake at 10m depth
Source

Code Definition

Code	Roos-15m
Definition	Roosevelt Lake at 15m depth
Source

Code Definition

Code	Roos-20m
Definition	Roosevelt Lake at 20m depth
Source

Code Definition

Code	Roos-25m
Definition	Roosevelt Lake at 25m depth
Source

Code Definition

Code	Roos-30m
Definition	Roosevelt Lake at 30m depth
Source

Code Definition

Code	Roos-35m
Definition	Roosevelt Lake at 35m depth
Source

Code Definition

Code	Roos-40m
Definition	Roosevelt Lake at 40m depth
Source

Code Definition

Code	Roos-45m
Definition	Roosevelt Lake at 45m depth
Source

Code Definition

Code	Roos-50m
Definition	Roosevelt Lake at 50m depth
Source

Code Definition

Code	Roos-5m
Definition	Roosevelt Lake at 5m depth
Source

Code Definition

Code	Roosevelt-0m
Definition	Roosevelt Lake at surface
Source

Code Definition

Code	Roosevelt-10m
Definition	Roosevelt Lake at 10m depth
Source

Code Definition

Code	Roosevelt-15m
Definition	Roosevelt Lake at 15m depth
Source

Code Definition

Code	Roosevelt-20m
Definition	Roosevelt Lake at 20m depth
Source

Code Definition

Code	Roosevelt-25m
Definition	Roosevelt Lake at 25m depth
Source

Code Definition

Code	Roosevelt-30m
Definition	Roosevelt Lake at 30m depth
Source

Code Definition

Code	Roosevelt-35m
Definition	Roosevelt Lake at 35m depth
Source

Code Definition

Code	Roosevelt-40m
Definition	Roosevelt Lake at 40m depth
Source

Code Definition

Code	Roosevelt-45m
Definition	Roosevelt Lake at 45m depth
Source

Code Definition

Code	Roosevelt-50m
Definition	Roosevelt Lake at 50m depth
Source

Code Definition

Code	Roosevelt-5m
Definition	Roosevelt Lake at 5m depth
Source

Code Definition

Code	s canal @ val vista
Definition	South Canal at Val Vista WTP
Source

Code Definition

Code	saguaro-0m
Definition	Saguaro Lake at surface
Source

Code Definition

Code	saguaro-10m
Definition	Saguaro Lake at 10m depth
Source

Code Definition

Code	saguaro-15m
Definition	Saguaro Lake at 15m depth
Source

Code Definition

Code	saguaro-20m
Definition	Saguaro Lake at 20m depth
Source

Code Definition

Code	saguaro-25m
Definition	Saguaro Lake at 25m depth
Source

Code Definition

Code	saguaro-30m
Definition	Saguaro Lake at 30m depth
Source

Code Definition

Code	saguaro-35m
Definition	Saguaro Lake at 35m depth
Source

Code Definition

Code	saguaro-40m
Definition	Saguaro Lake at 40m depth
Source

Code Definition

Code	saguaro-45m
Definition	Saguaro Lake at 45m depth
Source

Code Definition

Code	saguaro-50m
Definition	Saguaro Lake at 50m depth
Source

Code Definition

Code	saguaro-55m
Definition	Saguaro Lake at 55m depth
Source

Code Definition

Code	saguaro-5m
Definition	Saguaro Lake at 5m depth
Source

Code Definition

Code	salt abv saguaro
Definition	Salt River inlet to Saguaro Lake
Source

Code Definition

Code	salt blw saguaro
Definition	Salt River below Saguaro (Blue Point Bridge)
Source

Code Definition

Code	South canal below CAP
Definition	South Canal below CAP Cross-connect
Source

Code Definition

Code	squaw peak-treated
Definition	Squaw Peak WTP treated water
Source

Code Definition

Code	STP In
Definition	Tempe Canal - Inlet to Tempe's South Plant
Source

Code Definition

Code	STP Out
Definition	Tempe's South Plant treated water
Source

Code Definition

Code	Union Hills Inlet
Definition	Union Hills WTP Inlet
Source

Code Definition

Code	Union Hills Outlet
Definition	Union Hills WTP Treated
Source

Code Definition

Code	val vista-treated
Definition	Val Vista WTP treated water
Source

Code Definition

Code	verde @ beeline
Definition	verde river at beeline highway
Source

Code Definition

Code	verde abv bartlett
Definition	Verde River btwn Horseshoe and Bartlett
Source

Code Definition

Code	verde abv horseshoe
Definition	Verde River at Tangle
Source

Code Definition

Code	verde blw barlett
Definition	Verde River below Bartlett Reservoir
Source

Code Definition

Code	waddell canal
Definition	Waddell Canal
Source

Format	YYYY-MM-DD
Precision

Unit	meter
Type	real
Min	-0.1
Max	161.9

Unit	celsius
Type	real
Min	1.7
Max	232.2

Unit	milligramsPerLiter
Type	real
Min	0
Max	922

Unit	dimensionless
Type	real
Min	1
Max	805

Unit	meter
Type	real
Min	0.15
Max	8.625

Definition

types of analyses for which samples were collected

Definition

comment(s) about site conditions or sampling details

Missing Value Code:

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/knb-lter-cap/617/6/56600bf1a186fc8f144523a6e9f7a4ce
Name:	617_microbial_7a331250b6c16318285bb1d355dffc95.csv
Description:	E. coli, Coliform, and Mycobacterium colony counts in canals and reservoirs
Number of Records:	910
Number of Columns:	10

Table Structure

Object Name:

617_microbial_7a331250b6c16318285bb1d355dffc95.csv

Size:

88038 bytes

Authentication:

7a331250b6c16318285bb1d355dffc95 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Column Name:

site number

site location

cluster

site acronym

date

e_coli

coliform

mycobacterium

mycobacterium_flag

Comments

Definition:

site number or name (A designates epilimnion, B hypolimnion)

site location description

source water

site number or name (A designates epilimnion, B hypolimnion)

sample collection date

number of E coli colonies per 100mL of sample

number of Coliform colonies per 100mL of sample

number of Mycobacterium colonies per 100mL of sample

sampling, analysis, or processing flag for Mycobacterium sample

comment(s) about site conditions or sampling details

Storage Type:

string

date

float

string

Measurement Type:

nominal

dateTime

ratio

nominal

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	HOC
Definition	Head of the Consolidated canal
Source

Code Definition

Code	HTC
Definition	Head of the Tempe Canal
Source

Code Definition

Code	Hwy 87
Definition	AZ Canal at Highway 87
Source

Code Definition

Code	MOC
Definition	Middle of the Consolidated canal
Source

Code Definition

Code	Pima
Definition	AZ Canal at Pima Rd
Source

Code Definition

Code	R11
Definition	CAP Canal at Cross-connect
Source

Code Definition

Code	R12
Definition	AZ Canal above CAP Cross-connect
Source

Code Definition

Code	R13
Definition	AZ Canal below CAP Cross-connect
Source

Code Definition

Code	R21
Definition	AZ Canal - Central Avenue
Source

Code Definition

Code	R22
Definition	AZ Canal at 56th
Source

Code Definition

Code	R25
Definition	Verde River at Beeline
Source

Code Definition

Code	R3
Definition	Waddell Canal
Source

Code Definition

Code	SOCA
Definition	South Canal below CAP Cross-connect
Source

Definition

site location description

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	cap
Definition	Central Arizona Project canal
Source

Code Definition

Code	srp
Definition	Salt River Project canal
Source

Code Definition

Code	tempe
Definition	Tempe, AZ area canal
Source

Code Definition

Code	verde
Definition	Verde River
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	az canal @ 56th st.
Definition	AZ Canal at 56th Street
Source

Code Definition

Code	az canal @ central ave.
Definition	AZ Canal at Central Avenue
Source

Code Definition

Code	az canal @ hwy 87
Definition	AZ Canal at Highway 87
Source

Code Definition

Code	az canal @ pima
Definition	AZ Canal at Pima Rd
Source

Code Definition

Code	az canal blw cap
Definition	AZ Canal below CAP Cross-connect
Source

Code Definition

Code	az canal inflow
Definition	AZ Canal above CAP Cross-connect
Source

Code Definition

Code	cap @ x con
Definition	CAP Canal at Cross-connect
Source

Code Definition

Code	head of tempe canal
Definition	Head of Tempe Canal
Source

Code Definition

Code	Head of the Consolidated Canal
Definition	Head of the Consolidated canal
Source

Code Definition

Code	Middle of the Consolidated Canal
Definition	Middle of the Consolidated canal
Source

Code Definition

Code	South canal below CAP
Definition	South Canal below CAP Cross-connect
Source

Code Definition

Code	verde @ beeline
Definition	verde river at beeline highway
Source

Code Definition

Code	waddell canal
Definition	Waddell Canal
Source

Format	YYYY-MM-DD
Precision

Unit	coloniesPer100milliliter
Type	whole
Min	0
Max	2580

Unit	coloniesPer100milliliter
Type	natural
Min	23
Max	2560

Unit	coloniesPer100milliliter
Type	whole
Min	0
Max	408

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	CONT
Definition	Not Countable Due to Contamination
Source

Code Definition

Code	NCDC
Definition	Not Countable Due to Contamination
Source

Code Definition

Code	ND
Definition	absent/too few to count
Source

Code Definition

Code	TFTC
Definition	Too Few to Count
Source

Code Definition

Code	TNTC
Definition	Too Numerous to Count
Source

Definition

comment(s) about site conditions or sampling details

Missing Value Code:

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/knb-lter-cap/617/6/a2a3bf6e3711dd4822a99f385ecc0cfb
Name:	617_nutrients_a32dafb7546f4adc6404c987eff0ddcc.csv
Description:	concentration of algal by-products in canals and reservoirs
Number of Records:	11436
Number of Columns:	14

Table Structure

Object Name:

617_nutrients_a32dafb7546f4adc6404c987eff0ddcc.csv

Size:

1190467 bytes

Authentication:

a32dafb7546f4adc6404c987eff0ddcc Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Column Name:

site number

site location

cluster

site acronym

date

sample type

total_nitrogen

total_dissolved_nitrogen

total_phosphorus

total_dissolved_phosphorus

nitrate_nitrogen

ammonium_nitrogen

dissolved_organic_nitrogen

nutrient comments

Definition:

site number or name (A designates epilimnion, B hypolimnion)

site location description

source water

site number or name

sample collection date

type of water sample collected (if not a field sample)

total nitrogen (<=0 are below MDL)

total dissolved nitrogen (<=0 are below MDL)

total phosphorus (<=0 are below MDL)

total dissolved phosphorus (<=0 are below MDL)

nitrate-nitrogen

ammonium-nitrogen

dissolved organic nitrogen

comment(s) about site conditions or sampling details

Storage Type:

string

date

string

float

string

Measurement Type:

nominal

dateTime

nominal

ratio

nominal

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	16th St.
Definition	AZ Canal at 16th Street
Source

Code Definition

Code	19th Av.
Definition	AZ Canal at 19th Avenue
Source

Code Definition

Code	An in
Definition	Anthem WTP Inlet
Source

Code Definition

Code	AN IN
Definition	Anthem WTP Inlet
Source

Code Definition

Code	An out
Definition	Anthem WTP Treated
Source

Code Definition

Code	AN OUT
Definition	Anthem WTP Treated
Source

Code Definition

Code	Anthem in
Definition	Anthem WTP Inlet
Source

Code Definition

Code	Anthem out
Definition	Anthem WTP Treated
Source

Code Definition

Code	Ch in
Definition	Chandler WTP Inlet
Source

Code Definition

Code	CH IN
Definition	Chandler WTP Inlet
Source

Code Definition

Code	Ch out
Definition	Chandler WTP Treated
Source

Code Definition

Code	CH OUT
Definition	Chandler WTP Treated
Source

Code Definition

Code	Chandler in
Definition	Chandler WTP Inlet
Source

Code Definition

Code	Chandler out
Definition	Chandler WTP Treated
Source

Code Definition

Code	DV-WR
Definition	Deer Valley WTP wash return
Source

Code Definition

Code	field_blank
Definition	Field blank
Source

Code Definition

Code	Gila Salt
Definition	Salt-Gila Pump Station
Source

Code Definition

Code	GL IN
Definition	Glendale WTP Inlet
Source

Code Definition

Code	GL OUT
Definition	Glendale WTP Treated
Source

Code Definition

Code	Glen In
Definition	Glendale WTP Inlet
Source

Code Definition

Code	Glen Out
Definition	Glendale WTP Treated
Source

Code Definition

Code	Glendale In
Definition	Glendale WTP Inlet
Source

Code Definition

Code	Glendale Out
Definition	Glendale WTP Treated
Source

Code Definition

Code	GR IN
Definition	Greenway WTP Inlet
Source

Code Definition

Code	GR OUT
Definition	Greenway WTP Treated
Source

Code Definition

Code	Green In
Definition	Greenway WTP Inlet
Source

Code Definition

Code	Green Out
Definition	Greenway WTP Treated
Source

Code Definition

Code	HAV
Definition	Lake Havasu
Source

Code Definition

Code	Havasu 1
Definition	Lake Havasu Site 1
Source

Code Definition

Code	Havasu 2
Definition	Lake Havasu Site 2
Source

Code Definition

Code	HOC
Definition	Head of the Consolidated canal
Source

Code Definition

Code	HTC
Definition	Head of the Tempe Canal
Source

Code Definition

Code	Hwy 87
Definition	AZ Canal at Highway 87
Source

Code Definition

Code	HWY 87
Definition	AZ Canal at Highway 87
Source

Code Definition

Code	lab_blank
Definition	Laboratory blank
Source

Code Definition

Code	Mesa
Definition	AZ Canal at Mesa Dr.
Source

Code Definition

Code	Mesa Turnout
Definition	Mesa Canal Turnout
Source

Code Definition

Code	MOC
Definition	Middle of the Consolidated canal
Source

Code Definition

Code	MTO
Definition	Mesa Canal Turnout
Source

Code Definition

Code	NP In
Definition	Tempe North WTP Inlet
Source

Code Definition

Code	NP IN
Definition	Tempe North WTP Inlet
Source

Code Definition

Code	NP Out
Definition	Tempe North WTP Treated
Source

Code Definition

Code	NP OUT
Definition	Tempe North WTP Treated
Source

Code Definition

Code	Pima
Definition	AZ Canal at Pima Rd
Source

Code Definition

Code	PIMA
Definition	AZ Canal at Pima Rd
Source

Code Definition

Code	R1
Definition	CAP canal above Waddell Canal
Source

Code Definition

Code	R10
Definition	Salt River below Saguaro (Blue Point Bridge)
Source

Code Definition

Code	R10rain
Definition	Salt River below Saguaro (Blue Point Bridge) rain sample
Source

Code Definition

Code	R11
Definition	CAP Canal at Cross-connect
Source

Code Definition

Code	R11rain
Definition	CAP Canal at Cross-connect rain sample
Source

Code Definition

Code	R12
Definition	AZ Canal above CAP Cross-connect
Source

Code Definition

Code	R13
Definition	AZ Canal below CAP Cross-connect
Source

Code Definition

Code	R14
Definition	AZ Canal - Inlet to Squaw Peak WTP
Source

Code Definition

Code	R15
Definition	Squaw Peak WTP treated water
Source

Code Definition

Code	R16
Definition	AZ Canal - Inlet to Deer Valley WTP
Source

Code Definition

Code	R17
Definition	Deer Valley WTP treated water
Source

Code Definition

Code	R18
Definition	South Canal at Val Vista WTP
Source

Code Definition

Code	R19
Definition	Val Vista WTP treated water
Source

Code Definition

Code	R20
Definition	Verde River at Tangle
Source

Code Definition

Code	R21
Definition	AZ Canal - Central Avenue
Source

Code Definition

Code	R21br
Definition	AZ Canal - Central Ave (N. of Northern) brush exp
Source

Code Definition

Code	R22
Definition	AZ Canal at 56th
Source

Code Definition

Code	R25
Definition	Verde River at Beeline
Source

Code Definition

Code	R25rain
Definition	Verde River at Beeline rain sample
Source

Code Definition

Code	R26
Definition	AZ Canal at 19th Avenue
Source

Code Definition

Code	R26br
Definition	AZ Canal - 19th avenue brush exp
Source

Code Definition

Code	R27br
Definition	AZ Canal - 29th Avenue brush exp
Source

Code Definition

Code	R2A
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	R2B
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	R3
Definition	Waddell Canal
Source

Code Definition

Code	R4
Definition	Cap Canal at 7th St.
Source

Code Definition

Code	R4-Dup
Definition	Cap Canal at 7th St. duplicate sample
Source

Code Definition

Code	R5
Definition	Verde River btwn Horseshoe and Bartlett
Source

Code Definition

Code	R5dup
Definition	Verde River btwn Horseshoe and Bartlett duplicate sample
Source

Code Definition

Code	R6A
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	R6B
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	R6C
Definition	Bartlett Lake near dock
Source

Code Definition

Code	R7
Definition	Verde River below Bartlett Reservoir
Source

Code Definition

Code	R8
Definition	Salt River inlet to Saguaro Lake
Source

Code Definition

Code	R9A
Definition	Saguaro Lake near inlet
Source

Code Definition

Code	R9A-Dup
Definition	Saguaro Lake near inlet duplicate sample
Source

Code Definition

Code	R9A-DUP
Definition	Saguaro Lake near inlet duplicate sample
Source

Code Definition

Code	R9B
Definition	Saguaro Lake near inlet
Source

Code Definition

Code	R9Bturbid
Definition	Saguaro Lake hypolimnion turbidity sample
Source

Code Definition

Code	R9C
Definition	Saguaro Lake near dock
Source

Code Definition

Code	Roos In
Definition	Salt River Inlet Near Roosevelt Lake
Source

Code Definition

Code	Roosvelt
Definition	SRP above Roosevelt Lake
Source

Code Definition

Code	Salt Gila
Definition	Salt-Gila Pump Station
Source

Code Definition

Code	Scotts
Definition	AZ Canal at Scottsdale Rd.
Source

Code Definition

Code	SGPS
Definition	Salt-Gila Pump Station
Source

Code Definition

Code	SOCA
Definition	South Canal below CAP Cross-connect
Source

Code Definition

Code	SP-WR
Definition	Squaw Peak WTP wash return extra sample
Source

Code Definition

Code	SPT In
Definition	Tempe South WTP Inlet
Source

Code Definition

Code	SPT IN
Definition	Tempe South WTP Inlet
Source

Code Definition

Code	SPT Out
Definition	Tempe South WP Treated
Source

Code Definition

Code	SPT OUT
Definition	Tempe South WP Treated
Source

Code Definition

Code	SRNR
Definition	Salt River Inlet Near Roosevelt Lake
Source

Code Definition

Code	UH In
Definition	Union Hills WTP Inlet
Source

Code Definition

Code	UH IN
Definition	Union Hills WTP Inlet
Source

Code Definition

Code	UH Out
Definition	Union Hills WTP Treated
Source

Code Definition

Code	UH OUT
Definition	Union Hills WTP Treated
Source

Code Definition

Code	VV West
Definition	Val Vista West Water Treatment Plant treated water
Source

Definition

site location description

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	az canal
Definition	Arizona canal
Source

Code Definition

Code	cap
Definition	Central Arizona Project canal
Source

Code Definition

Code	salt
Definition	Salt River
Source

Code Definition

Code	srp
Definition	Salt River Project canal
Source

Code Definition

Code	tempe
Definition	Tempe, AZ area canal
Source

Code Definition

Code	verde
Definition	Verde River
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	24th In
Definition	AZ Canal - Inlet to 24th St Water Treatment Plant
Source

Code Definition

Code	24th Out
Definition	24th St Water Treatment Plant treated water
Source

Code Definition

Code	Above Roosevelt
Definition	SRP above Roosevelt Lake
Source

Code Definition

Code	anthem
Definition	Anthem Water Treatment Plant
Source

Code Definition

Code	Anthem
Definition	Anthem Water Treatment Plant
Source

Code Definition

Code	az canal
Definition	AZ Canal
Source

Code Definition

Code	az canal @ 16th st.
Definition	AZ Canal at 16th Street
Source

Code Definition

Code	az canal @ 19 ave.
Definition	AZ Canal at 19th Avenue
Source

Code Definition

Code	az canal @ 19th av.
Definition	AZ Canal at 19th Avenue
Source

Code Definition

Code	az canal @ 29 ave.
Definition	AZ Canal at 29th Avenue
Source

Code Definition

Code	az canal @ 56th st.
Definition	AZ Canal at 56th Street
Source

Code Definition

Code	az canal @ central ave.
Definition	AZ Canal at Central Avenue
Source

Code Definition

Code	az canal @ deer valley
Definition	AZ Canal - Inlet to Deer Valley WTP
Source

Code Definition

Code	az canal @ hwy 87
Definition	AZ Canal at Highway 87
Source

Code Definition

Code	az canal @ Mesa
Definition	AZ Canal at Mesa Dr.
Source

Code Definition

Code	az canal @ pima
Definition	AZ Canal at Pima Rd
Source

Code Definition

Code	az canal @ scotts.
Definition	AZ Canal at Scottsdale Rd.
Source

Code Definition

Code	az canal @ squaw peak
Definition	AZ Canal - Inlet to Squaw Peak WTP
Source

Code Definition

Code	az canal blw cap
Definition	AZ Canal below CAP Cross-connect
Source

Code Definition

Code	az canal inflow
Definition	AZ Canal above CAP Cross-connect
Source

Code Definition

Code	bartlett-dock
Definition	Bartlett Lake dock sample
Source

Code Definition

Code	bartlett-epi
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	bartlett-hypo
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	cap-siphon
Definition	metadata_not_provided
Source

Code Definition

Code	cap @ 7th st
Definition	Cap Canal at 7th St.
Source

Code Definition

Code	cap @ 7th st dup
Definition	Cap Canal at 7th St. duplicate sample
Source

Code Definition

Code	cap @ x con
Definition	CAP Canal at Cross-connect
Source

Code Definition

Code	chandler
Definition	Chandler Water Treatment Plant
Source

Code Definition

Code	Chandler
Definition	Chandler Water Treatment Plant
Source

Code Definition

Code	deer valley-treated
Definition	Deer Valley WTP treated water
Source

Code Definition

Code	field
Definition	Field Blank
Source

Code Definition

Code	field blank
Definition	Field Blank
Source

Code Definition

Code	Glen In
Definition	Glendale WTP Inlet
Source

Code Definition

Code	Glen Out
Definition	Glendale WTP Treated
Source

Code Definition

Code	Glendale WTP Inlet
Definition	Glendale WTP Inlet
Source

Code Definition

Code	Glendale WTP Outlet
Definition	Glendale WTP Treated
Source

Code Definition

Code	Green In
Definition	Greenway WTP Inlet
Source

Code Definition

Code	Green Out
Definition	Greenway WTP Treated
Source

Code Definition

Code	Greenway WTP Inlet
Definition	Greenway WTP Inlet
Source

Code Definition

Code	Greenway WTP Outlet
Definition	Greenway WTP Treated
Source

Code Definition

Code	Havasu
Definition	Lake Havasu
Source

Code Definition

Code	Havasu 1
Definition	Lake Havasu Site 1
Source

Code Definition

Code	Havasu 2
Definition	Lake Havasu Site 2
Source

Code Definition

Code	head of tempe canal
Definition	Head of Tempe Canal
Source

Code Definition

Code	lab
Definition	Laboratory blank
Source

Code Definition

Code	Mesa Turnout
Definition	Mesa Canal Turnout
Source

Code Definition

Code	North plant inlet
Definition	Tempe North WTP Inlet
Source

Code Definition

Code	north plant outlet
Definition	Tempe North WTP Treated
Source

Code Definition

Code	pleasant-epi
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	pleasant-hypo
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	Roos In
Definition	Salt River Inlet Near Roosevelt Lake
Source

Code Definition

Code	s canal @ val vista
Definition	South Canal at Val Vista Water Treatment Plant
Source

Code Definition

Code	saguaro-dock
Definition	Saguaro Lake dock sample
Source

Code Definition

Code	saguaro-epi
Definition	Saguaro Lake Epilimnion
Source

Code Definition

Code	saguaro-epi dup
Definition	Saguaro Lake Epilimnion duplicate sample
Source

Code Definition

Code	saguaro-hypo
Definition	Saguaro Lake Hypolimnion
Source

Code Definition

Code	salt abv saguaro
Definition	Salt River inlet to Saguaro Lake
Source

Code Definition

Code	salt blw saguaro
Definition	Salt River below Saguaro (Blue Point Bridge)
Source

Code Definition

Code	Salt Gila
Definition	Salt-Gila Pump Station
Source

Code Definition

Code	saugaro-dock
Definition	Saguaro Lake dock sample
Source

Code Definition

Code	South canal below CAP
Definition	South Canal below CAP Cross-connect
Source

Code Definition

Code	squaw peak-treated
Definition	Squaw Peak WTP treated water
Source

Code Definition

Code	SRNR
Definition	Salt River Inlet Near Roosevelt Lake
Source

Code Definition

Code	STP In
Definition	Tempe Canal - Inlet to Tempe's South Plant
Source

Code Definition

Code	STP Out
Definition	Tempe's South Plant treated water
Source

Code Definition

Code	Union Hills Inlet
Definition	Union Hills WTP Inlet
Source

Code Definition

Code	Union Hills Outlet
Definition	Union Hills WTP Treated
Source

Code Definition

Code	val vista-treated
Definition	Val Vista WTP treated water
Source

Code Definition

Code	val vista WEST-treated
Definition	Val Vista Water Treatment Plant Treated Water - West
Source

Code Definition

Code	verde @ beeline
Definition	verde river at beeline highway
Source

Code Definition

Code	verde abv bartlett
Definition	Verde River btwn Horseshoe and Bartlett
Source

Code Definition

Code	verde abv horseshoe
Definition	Verde River at Tangle
Source

Code Definition

Code	verde blw barlett
Definition	Verde River below Bartlett Reservoir
Source

Code Definition

Code	waddell canal
Definition	Waddell Canal
Source

Format	YYYY-MM-DD
Precision

Definition

type of water sample collected (if not a field sample)

Unit	milligramsPerLiter
Type	real
Min	-0.00357
Max	2.484

Unit	milligramsPerLiter
Type	real
Min	-0.9267
Max	45.7

Unit	nanogramsPerLiter
Type	real
Min	0
Max	1173.7

Unit	nanogramsPerLiter
Type	real
Min	0
Max	161

Unit	milligramsPerLiter
Type	real
Min	0
Max	142

Unit	milligramsPerLiter
Type	real
Min	0
Max	3.9

Unit	milligramsPerLiter
Type	real
Min	-0.287
Max	3.715

Definition

comment(s) about site conditions or sampling details

Missing Value Code:

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/knb-lter-cap/617/6/af19e40cd5341fe05f8462292574828b
Name:	617_quarterly_lake_sampling_f0737c30552c0ab276c0d93483672fcb.csv
Description:	concentration of nutrients and algal by-products, and other water quality parameters measured in central-Arizona area lakes
Number of Records:	384
Number of Columns:	13

Table Structure

Object Name:

617_quarterly_lake_sampling_f0737c30552c0ab276c0d93483672fcb.csv

Size:

51014 bytes

Authentication:

f0737c30552c0ab276c0d93483672fcb Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Column Name:

site number

site location

cluster

site acronym

date

MIB (ng/L)

geosmin (ng/L)

TP (ug/L)

DOC (mg/L)

UVA (cm-1)

Suva(L/mg-m)

Conductance (us/cm)

TDN (mg/L)

Definition:

site number or name (A designates epilimnion, B hypolimnion)

site location description

source water

site number or name

sample collection

2-methylisoborneol

Geosmin

total phosphorus

dissolved organic carbon

UV absorbance measured at 254 nanometers

specific ultraviolet absorbance

specific conductance

total dissolved nitrogen

Storage Type:

string

date

float

Measurement Type:

nominal

dateTime

ratio

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	APA1A
Definition	Apache Lake Site 1 Epilimnion
Source

Code Definition

Code	APA1B
Definition	Apache Lake Site 1 Hypolimnion
Source

Code Definition

Code	APA2A
Definition	Apache Lake Site 2 Epilimnion
Source

Code Definition

Code	APA2B
Definition	Apache Lake Site 2 Hypolimnion
Source

Code Definition

Code	Can1A
Definition	Canyon Lake Site 1 Epilimnion
Source

Code Definition

Code	Can1B
Definition	Canyon Lake Site 1 Hypolimnion
Source

Code Definition

Code	Can2A
Definition	Canyon Lake Site 2 Epilimnion
Source

Code Definition

Code	Can2B
Definition	Canyon Lake Site 2 Hypolimnion
Source

Code Definition

Code	Roos1A
Definition	Roosevelt Lake Site 1 Epilimnion
Source

Code Definition

Code	Roos1B
Definition	Roosevelt Lake Site 1 Hypolimnion
Source

Code Definition

Code	Roos2A
Definition	Roosevelt Lake Site 2 Epilimnion
Source

Code Definition

Code	Roos2B
Definition	Roosevelt Lake Site 2 Hypolimnion
Source

Definition

site location description

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	srp
Definition	Salt River Project canal
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Apache, epi, lower
Definition	Apache Lake Site 2 Epilimnion
Source

Code Definition

Code	Apache, epi, upper
Definition	Apache Lake Site 1 Epilimnion
Source

Code Definition

Code	Apache, eppi, lower
Definition	Apache Lake Site 2 Epilimnion
Source

Code Definition

Code	Apache, eppi, upper
Definition	Apache Lake Site 1 Epilimnion
Source

Code Definition

Code	Apache, hypo, lower
Definition	Apache Lake Site 2 Hypolimnion
Source

Code Definition

Code	Apache, hypo, upper
Definition	Apache Lake Site 1 Hypolimnion
Source

Code Definition

Code	Canyon, epi, lower
Definition	Canyon Lake Site 2 Epilimnion
Source

Code Definition

Code	Canyon, epi, upper
Definition	Canyon Lake Site 1 Epilimnion
Source

Code Definition

Code	Canyon, eppi, lower
Definition	Canyon Lake Site 2 Epilimnion
Source

Code Definition

Code	Canyon, eppi, upper
Definition	Canyon Lake Site 1 Epilimnion
Source

Code Definition

Code	Canyon, hypo, lower
Definition	Canyon Lake Site 2 Hypolimnion
Source

Code Definition

Code	Canyon, hypo, upper
Definition	Canyon Lake Site 1 Hypolimnion
Source

Code Definition

Code	Roosevelt, epi, lower
Definition	Roosevelt Lake Site 2 Epilimnion
Source

Code Definition

Code	Roosevelt, epi, upper
Definition	Roosevelt Lake Site 1 Epilimnion
Source

Code Definition

Code	Roosevelt, eppi, lower
Definition	Roosevelt Lake Site 2 Epilimnion
Source

Code Definition

Code	Roosevelt, eppi, upper
Definition	Roosevelt Lake Site 1 Epilimnion
Source

Code Definition

Code	Roosevelt, hypo, lower
Definition	Roosevelt Lake Site 2 Hypolimnion
Source

Code Definition

Code	Roosevelt, hypo, upper
Definition	Roosevelt Lake Site 1 Hypolimnion
Source

Format	YYYY-MM-DD
Precision

Unit	nanogramsPerLiter
Type	real
Min	-0.852675
Max	56.8

Unit	nanogramsPerLiter
Type	real
Min	-2.380167
Max	73.793062

Unit	microgramsPerLiter
Type	real
Min	-0.1
Max	150

Unit	milligramsPerLiter
Type	real
Min	2.359
Max	14.27

Unit	perCentimeter
Type	real
Min	0.03
Max	0.8

Unit	literPerMilligramMeter
Type	real
Min	0.5
Max	3.98

Unit	microsiemensPerCentimeter
Type	natural
Min	930
Max	2300

Unit	milligramsPerLiter
Type	real
Min	0
Max	1.381

Missing Value Code:

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/knb-lter-cap/617/6/eea90ebecd7f08e4489db9134ec383f6
Name:	617_quarterly_metals_7f32c206f2d47401a024067c57de94b3.csv
Description:	concentration of dissolved metals measured in central-Arizona area lakes and canals
Number of Records:	401
Number of Columns:	31

Table Structure

Object Name:

617_quarterly_metals_7f32c206f2d47401a024067c57de94b3.csv

Size:

87224 bytes

Authentication:

7f32c206f2d47401a024067c57de94b3 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Column Name:

site number

site location

cluster

site acronym

date

7Li

9Be

23Na

24Mg

27Al

39K

44Ca

51V

52Cr

55Mn

56Fe

59Co

60Ni

65Cu

66Zn

75As

82Se

88Sr

95Mo

107Ag

111Cd

121Sb

138Ba

202Hg

208Pb

238U

Definition:

site number or name (A designates epilimnion, B hypolimnion)

site location description

source water

site number or name

sample collection date

Lithium measurement by ICP-MS

Beryllium measurement by ICP-MS

Sodium measurement by ICP-MS

Magnesium measurement by ICP-MS

Aluminum measurement by ICP-MS

Potassium measurement by ICP-MS

Calcium measurement by ICP-MS

Vanadium measurement by ICP-MS

Chromium measurement by ICP-MS

Manganese measurement by ICP-MS

Iron measurement by ICP-MS

Cobalt measurement by ICP-MS

Nickel measurement by ICP-MS

Copper measurement by ICP-MS

Zinc measurement by ICP-MS

Arsenic measurement by ICP-MS

Selenium measurement by ICP-MS

Strontium measurement by ICP-MS

Molybdenum measurement by ICP-MS

Silver measurement by ICP-MS

Cadmium measurement by ICP-MS

Antimony measurement by ICP-MS

Barium measurement by ICP-MS

Mercury measurement by ICP-MS

Lead measurement by ICP-MS

Uranium measurement by ICP-MS

Storage Type:

string

date

float

Measurement Type:

nominal

dateTime

ratio

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	APA1A
Definition	Apache Lake Site 1 Epilimnion
Source

Code Definition

Code	APA1B
Definition	Apache Lake Site 1 Hypolimnion
Source

Code Definition

Code	APA2A
Definition	Apache Lake Site 2 Epilimnion
Source

Code Definition

Code	APA2B
Definition	Apache Lake Site 2 Hypolimnion
Source

Code Definition

Code	Can1A
Definition	Canyon Lake Site 1 Epilimnion
Source

Code Definition

Code	Can1B
Definition	Canyon Lake Site 1 Hypolimnion
Source

Code Definition

Code	Can2A
Definition	Canyon Lake Site 2 Epilimnion
Source

Code Definition

Code	Can2B
Definition	Canyon Lake Site 2 Hypolimnion
Source

Code Definition

Code	Hav
Definition	Lake Havasu
Source

Code Definition

Code	R10
Definition	Salt River below Saguaro (Blue Point Bridge)
Source

Code Definition

Code	R25
Definition	Verde River at Beeline
Source

Code Definition

Code	R2A
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	R3
Definition	Waddell Canal
Source

Code Definition

Code	Roos1A
Definition	Roosevelt Lake Site 1 Epilimnion
Source

Code Definition

Code	Roos1B
Definition	Roosevelt Lake Site 1 Hypolimnion
Source

Code Definition

Code	Roos2A
Definition	Roosevelt Lake Site 2 Epilimnion
Source

Code Definition

Code	Roos2B
Definition	Roosevelt Lake Site 2 Hypolimnion
Source

Definition

site location description

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	cap
Definition	Central Arizona Project canal
Source

Code Definition

Code	salt
Definition	Salt River
Source

Code Definition

Code	srp
Definition	Salt River Project canal
Source

Code Definition

Code	verde
Definition	Verde River
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Apache, eppi, lower
Definition	Apache Lake Site 2 Epilimnion
Source

Code Definition

Code	Apache, eppi, upper
Definition	Apache Lake Site 1 Epilimnion
Source

Code Definition

Code	Apache, hypo, lower
Definition	Apache Lake Site 2 Hypolimnion
Source

Code Definition

Code	Apache, hypo, upper
Definition	Apache Lake Site 1 Hypolimnion
Source

Code Definition

Code	Canyon, eppi, lower
Definition	Canyon Lake Site 2 Epilimnion
Source

Code Definition

Code	Canyon, eppi, upper
Definition	Canyon Lake Site 1 Epilimnion
Source

Code Definition

Code	Canyon, hypo, lower
Definition	Canyon Lake Site 2 Hypolimnion
Source

Code Definition

Code	Canyon, hypo, upper
Definition	Canyon Lake Site 1 Hypolimnion
Source

Code Definition

Code	Havasu
Definition	Lake Havasu
Source

Code Definition

Code	pleasant-epi
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	Roosevelt, eppi, lower
Definition	Roosevelt Lake Site 2 Epilimnion
Source

Code Definition

Code	Roosevelt, eppi, upper
Definition	Roosevelt Lake Site 1 Epilimnion
Source

Code Definition

Code	Roosevelt, hypo, lower
Definition	Roosevelt Lake Site 2 Hypolimnion
Source

Code Definition

Code	Roosevelt, hypo, upper
Definition	Roosevelt Lake Site 1 Hypolimnion
Source

Code Definition

Code	salt blw saguaro
Definition	Salt River below Saguaro (Blue Point Bridge)
Source

Code Definition

Code	verde @ beeline
Definition	verde river at beeline highway
Source

Code Definition

Code	waddell canal
Definition	Waddell Canal
Source

Format	YYYY-MM-DD
Precision

Unit	microgramsPerLiter
Type	real
Min	9.909
Max	196.8

Unit	microgramsPerLiter
Type	real
Min	-0.051
Max	0.398

Unit	microgramsPerLiter
Type	natural
Min	12440
Max	278900

Unit	microgramsPerLiter
Type	natural
Min	8994
Max	29900

Unit	microgramsPerLiter
Type	real
Min	-3.141
Max	1385

Unit	microgramsPerLiter
Type	natural
Min	1811
Max	14420

Unit	microgramsPerLiter
Type	natural
Min	21180
Max	104600

Unit	microgramsPerLiter
Type	real
Min	1.091
Max	8.879

Unit	microgramsPerLiter
Type	real
Min	-0.214
Max	5.566

Unit	microgramsPerLiter
Type	real
Min	0.013
Max	443.1

Unit	microgramsPerLiter
Type	real
Min	-1.916
Max	1217

Unit	microgramsPerLiter
Type	real
Min	-0.059
Max	1.068

Unit	microgramsPerLiter
Type	real
Min	-9.656
Max	3.676

Unit	microgramsPerLiter
Type	real
Min	-2.519
Max	84.52

Unit	microgramsPerLiter
Type	real
Min	-545.4
Max	83.33

Unit	microgramsPerLiter
Type	real
Min	1.93
Max	18.35

Unit	microgramsPerLiter
Type	real
Min	-2.522
Max	178.6

Unit	microgramsPerLiter
Type	real
Min	293.7
Max	1428

Unit	microgramsPerLiter
Type	real
Min	0.648
Max	8.292

Unit	microgramsPerLiter
Type	real
Min	-0.088
Max	2.709

Unit	microgramsPerLiter
Type	real
Min	-0.029
Max	2.597

Unit	microgramsPerLiter
Type	real
Min	0.034
Max	1.564

Unit	microgramsPerLiter
Type	real
Min	32.44
Max	296.6

Unit	microgramsPerLiter
Type	real
Min	-0.045
Max	3.431

Unit	microgramsPerLiter
Type	real
Min	-0.793
Max	2.073

Unit	microgramsPerLiter
Type	real
Min	0.218
Max	5.798

Missing Value Code:

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/knb-lter-cap/617/6/9d4364f1d2a3911a7edcf4ed802d4de6
Name:	617_sampling_locations_46042e79c58446e438b4879dac011e84.csv
Description:	latitude, longitude, and elevation of select canal, lake, and river water-quality sampling locations
Number of Records:	32
Number of Columns:	8

Table Structure

Object Name:

617_sampling_locations_46042e79c58446e438b4879dac011e84.csv

Size:

3256 bytes

Authentication:

46042e79c58446e438b4879dac011e84 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Column Name:

site number

site location

cluster

site acronym

date

longitude

latitude

altitude (ft)

Definition:

site number or name (A designates epilimnion, B hypolimnion)

site location description

source water

site number or name

GPS collection date

longitude

latitude

altitude

Storage Type:

string

date

float

Measurement Type:

nominal

dateTime

ratio

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Hav
Definition	Lake Havasu
Source

Code Definition

Code	HOC
Definition	Head of the Consolidated canal
Source

Code Definition

Code	HTC
Definition	Head of the Tempe Canal
Source

Code Definition

Code	MOC
Definition	Middle of the Consolidated canal
Source

Code Definition

Code	Pima
Definition	AZ Canal at Pima Rd
Source

Code Definition

Code	R1
Definition	CAP canal above Waddell Canal
Source

Code Definition

Code	R10
Definition	Salt River below Saguaro (Blue Point Bridge)
Source

Code Definition

Code	R11
Definition	CAP Canal at Cross-connect
Source

Code Definition

Code	R12
Definition	AZ Canal above CAP Cross-connect
Source

Code Definition

Code	R13
Definition	AZ Canal below CAP Cross-connect
Source

Code Definition

Code	R14
Definition	AZ Canal - Inlet to Squaw Peak WTP
Source

Code Definition

Code	R15
Definition	Squaw Peak WTP treated water
Source

Code Definition

Code	R16
Definition	AZ Canal - Inlet to Deer Valley WTP
Source

Code Definition

Code	R17
Definition	Deer Valley WTP treated water
Source

Code Definition

Code	R18
Definition	South Canal at Val Vista WTP
Source

Code Definition

Code	R19
Definition	Val Vista WTP treated water
Source

Code Definition

Code	R20
Definition	Verde River at Tangle
Source

Code Definition

Code	R21
Definition	AZ Canal - Central Avenue
Source

Code Definition

Code	R22
Definition	AZ Canal at 56th
Source

Code Definition

Code	R25
Definition	Verde River at Beeline
Source

Code Definition

Code	R2A
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	R2B
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	R3
Definition	Waddell Canal
Source

Code Definition

Code	R4
Definition	Cap Canal at 7th St.
Source

Code Definition

Code	R5
Definition	Verde River btwn Horseshoe and Bartlett
Source

Code Definition

Code	R6A
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	R6B
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	R7
Definition	Verde River below Bartlett Reservoir
Source

Code Definition

Code	R8
Definition	Salt River inlet to Saguaro Lake
Source

Code Definition

Code	R9A
Definition	Saguaro Lake near inlet
Source

Code Definition

Code	R9B
Definition	Saguaro Lake near inlet
Source

Code Definition

Code	SOCA
Definition	South Canal below CAP Cross-connect
Source

Definition

site location description

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	az canal
Definition	Arizona canal
Source

Code Definition

Code	cap
Definition	Central Arizona Project canal
Source

Code Definition

Code	reservoir
Definition	metadata_not_provided
Source

Code Definition

Code	salt
Definition	Salt River
Source

Code Definition

Code	srp
Definition	Salt River Project canal
Source

Code Definition

Code	tempe
Definition	Tempe, AZ area canal
Source

Code Definition

Code	verde
Definition	Verde River
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	az canal- head of the consolidated canal
Definition	Head of the Consolidated canal
Source

Code Definition

Code	az canal - 56th st
Definition	AZ Canal at 56th Street
Source

Code Definition

Code	az canal - cent
Definition	AZ Canal at Central Avenue
Source

Code Definition

Code	az canal - middle of the consolidated canal
Definition	Middle of the Consolidated canal
Source

Code Definition

Code	az canal - pima
Definition	AZ Canal at Pima Rd
Source

Code Definition

Code	az canal - verde river @ beeline
Definition	verde river at beeline highway
Source

Code Definition

Code	az canal @ deer valley
Definition	AZ Canal - Inlet to Deer Valley WTP
Source

Code Definition

Code	az canal @ squaw peak
Definition	AZ Canal - Inlet to Squaw Peak WTP
Source

Code Definition

Code	az canal blw cap
Definition	AZ Canal below CAP Cross-connect
Source

Code Definition

Code	az canal inflow
Definition	AZ Canal above CAP Cross-connect
Source

Code Definition

Code	bartlett-epi
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	bartlett-hypo
Definition	Bartlett Reservoir near outlet
Source

Code Definition

Code	cap-siphon
Definition	metadata_not_provided
Source

Code Definition

Code	cap @ 7th st
Definition	Cap Canal at 7th St.
Source

Code Definition

Code	cap @ x con
Definition	CAP Canal at Cross-connect
Source

Code Definition

Code	deer valley-treated
Definition	Deer Valley WTP treated water
Source

Code Definition

Code	lake havasu
Definition	Lake Havasu
Source

Code Definition

Code	pleasant-epi
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	pleasant-hypo
Definition	Lake Pleasant integrated sample
Source

Code Definition

Code	s canal @ val vista
Definition	South Canal at Val Vista WTP
Source

Code Definition

Code	saguaro-epi
Definition	Saguaro Lake Epilimnion
Source

Code Definition

Code	saguaro-hypo
Definition	Saguaro Lake Hypolimnion
Source

Code Definition

Code	salt abv saguaro
Definition	Salt River inlet to Saguaro Lake
Source

Code Definition

Code	salt blw saguaro
Definition	Salt River below Saguaro (Blue Point Bridge)
Source

Code Definition

Code	south tempe canals - below CAP Cross-connect
Definition	South Canal below CAP Cross-connect
Source

Code Definition

Code	south tempe canals - head of the tempe canal
Definition	Head of the Tempe Canal
Source

Code Definition

Code	squaw peak-treated
Definition	Squaw Peak WTP treated water
Source

Code Definition

Code	val vista-treated
Definition	Val Vista WTP treated water
Source

Code Definition

Code	verde abv bartlett
Definition	Verde River btwn Horseshoe and Bartlett
Source

Code Definition

Code	verde abv horseshoe
Definition	Verde River at Tangle
Source

Code Definition

Code	verde blw barlett
Definition	Verde River below Bartlett Reservoir
Source

Code Definition

Code	waddell canal
Definition	Waddell Canal
Source

Format	YYYY-MM-DD
Precision

Unit	degree
Type	real
Min	111.09375
Max	112.286233

Unit	degree
Type	real
Min	0
Max	34

Unit	meter
Type	natural
Min	1493
Max	2000

Missing Value Code:

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Code	NA
Expl	missing value

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Package Usage Rights

This data package is released to the "public domain" under Creative Commons CC0 1.0 "No Rights Reserved" (see: https://creativecommons.org/publicdomain/zero/1.0/). The consumer of these data ("Data User" herein) has an ethical obligation 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 coauthorship 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:
LTER controlled vocabulary	urban, dissolved organic carbon, chlorophyll, nutrients, total phosphorus, total nitrogen, total dissolved nitrogen, water properties, water quality
LTER core areas	water and fluxes, disturbance patterns, movement of organic matter, movement of inorganic matter
Creator Defined Keyword Set	total dissolved phosphorus, geosmin, canal, water treatment
CAPLTER Keyword Set List	cap lter, cap, caplter, central arizona phoenix long term ecological research, arizona, az, arid land

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:

Regional Water Quality Sampling =============================== Overview -------- Grab water samples were collected for analysis from canals and water treatment plants in headspace-free, amber glass containers. Water samples for metals analysis were collected in centrifuge tubes and acidified with nitric acid for stability. Lake samples were obtained from the epilimnion and hypolimnion by way of a Kemmerer sampler. All samples were kept on ice in the field and stored at 4 degrees Celsius until analyzed. Nutrient samples that could not be analyzed within 24 hours were frozen. Field measurements for dissolved oxygen, pH, and temperature were made using a portable meter. Water clarity for lake samples was measured using a Secchi Disk. Taste and odor compounds were measured using solid phase micro extraction and injected onto a GC-MS/MS. Total nutrients were obtained by way of persulfate digestion and then analysis on a continuous flow colorimetric analyzer. Metals data were obtained by ICP-MS. Purpose ------- The regional water quality sampling project began in 1999 with an EPA order for various municipalities in the Phoenix metropolitan area to address taste and odor issues that were plaguing the regional water supply. The compounds of concern were identified as 2-methylisoborneol (MIB) which causes as musty odor, and Geosmin which causes an earthy taste. Both compounds are released by algae that grows in the reservoirs and canals that compose the region’s surface water supply, especially during summer when abundant sunshine and warm temperatures promote algal blooms. Complaints from water utility users were so numerous that the issue had to be addressed. Although these compounds do not cause any health problems, they create foul odor and taste which causes users to lose faith in their water utilities and question the reliability of the treatment process. Both chemicals can be detected in concentrations as low as 10 ng/L and during peak summer algal blooms this concentration is regularly exceeded. The project has been ongoing since 1999, providing valuable data to the region’s water utilities about the water supply. The project data has been used in a variety of other projects examining topics ranging from disinfection by-product formation to invasive species infestation. Initially managed by the Westerhoff Group at Arizona State University, today the project is run by Dr. Peter Fox and Dr. Morteza Abbaszadegan. What Parameters Do We Test? --------------------------- As part of the Regional Water Quality Sampling Project the following tests are performed: - UV254 Absorbance to look for natural organic matter - DOC (Dissolved Organic Carbon) - E. coli and fecal coliform count - Mycobacterium count - TDN (Total Dissolved Nitrogen) - MIB (Methyl Isoborneol) and Geosmin - Turbidity and Conductivity - ICPMS to look for trace metals. This is done during quarterly sampling. - Dissolved Oxygen and Temperature Sampling Locations ------------------ Here are written descriptions of the location of each site and anything else you should know about them: - PIMA (AZ Canal at Pima Road) – Located at the canal crossing with Pima Road 1 mile north of McDonald Drive on the west side of the road near the bridge. There is a pull out near the golf course. - 56th- (AZ Canal at 56th Street) – Located at the northeast corner of 56th St. and Indian School Road. Take the sample near the pipe. - CENT (AZ Canal at Central Avenue) – Located at Central Avenue and Orchid Lane (north of Northern Ave 2 miles). There is a pull off for the bike path on the west side of the road. - UH IN/OUT (Union Hills WTP Inlet and Treated)- Deer Valley Road and 21st St. (West of Cave Creek Road). Take In sample from Raw Water Influent tap, take Out sample from Ent Point Distribution System tap, both located in the operators lab in Building 9. - AN IN/OUT (Anthem WTP Inlet and Treated) – Located at Gavilan Peak Pkwy and King Drive (off Daisy Mountain Dr. Exit of I 17). Influent sample taken from raw water screen. Effluent sample taken from the permeate room. - R3 (Waddell Canal) – Located off Carefree Highway Rt. 74 exit of I 17 west of Lake Pleasant Parkway. From Highway 74 take a left onto Lake Pleasant Parkway and then turn right onto Old Highway 74 near the glider school. The site is on the right hand side of the road before the crossing. - GR IN/OUT (Greenway WTP Inlet and Treated) – Located at 75th Avenue and Greenway Road. Take In sample from Raw Water, take Out sample from Filt Eff. Be sure to collect this sample by 10 AM to avoid arriving while the system is down (they flush on Monday mornings around 11 AM). - GL IN/OUT (Glendale WTP Inlet and Treated) – Located at Cholla Street and 49th Avenue. Take In sample from Raw Influent, take Out sample from BVS, both in the operators lab. - NP IN/OUT (Tempe North WTP Inlet and Treated) – Located at 68th Street and Marigold Lane, take the inlet sample from the canal flowing into the treatment plant and the effluent sample from the blue pipe located near the canal. - SPT IN/OUT (Tempe South WTP Inlet and Treated) – Located Off of 101 south of Guadalupe. Take the samples from the operators lab. - CH IN/OUT (Chandler WTP Inlet and Treated) – Located off of Pecos Road and 124th St. Take the samples from the operators lab. - MOC (Middle of Consolidated Canal) – Located at Lindsay Road north of Juniper Avenue. There is a pull off of Lindsay Road on the Right Side where the canal crosses the road. - HTC (Head of Tempe Canal) - Located east of Mesa Dr. and Brown Road. Turn onto the canal service road and take the sample midway along the canal. - HOC (Head of Consolidated Canal) - Located West of Horne and north of Brown Road. Take the sample just past the turn in the canal. - R10 (Salt River at Blue Pt. Bridge) – This sample is taken at the Blue Point Recreation Site on Bush Highway (east of Usery Pass Rd.) - R11 (CAP Canal at Cross Connect)- Bush Highway and Granite Reef Dam Road. Use your Key to open this gate. - SOCA (South Canal below CAP Cross Connect) – Located in the Granite Reef area at the vehicle bridge over the South Canal before crossing the wash. You will need Jeff to unlock the gate to get access to this site. - R12 (AZ Canal Above CAP Cross-Connect)- Granite Reef area, just west of waterfall area with high voltage signs at guard rail (just thru gate). You will need Jeff to unlock the gate to get access to this site. - R13 (AZ Canal Below CAP Cross-Connect) - Granite Reef area, boat launch ramp area west of R12. You will need Jeff to unlock the gate to get access to this site. - HWY 87 (AZ Canal at Highway 87) - Located on canal service road east of HWY 87 at boat ramp east of val vista drive. You will need Jeff to unlock the gate to get access to this site. - R20- Pick up from USGS (SE-corner 52nd St. and University) monthly - R25 (Verde River at Beeline Highway) - Verde River north of HWY 87 east of Fort McDowell Rd. Watch out for the pitbull and the cows. - HAV/R2A/R2B/SGPS/MTO - Pick up monthly from CAP (7th St. N of Pinnacle Peak Road) - R6A/R6B/R9A/R9A-Dup/R9B – Pick up Monthly from GWC 673 Cold Room. Marisa Collects these. - ISTB4- Take a sample from the tap in the sink next to bench - ROOS/APA/CAN- Pick up from Marisa in GWC 673 cold room (quarterly samples) Preparation ----------- ### Ashing Glassware/DOC Vials/Filters Prior to use in sample analysis, any materials used for carbon and organics procedures must be ashed to remove any trace carbon present. This is completed by placing the materials into a furnace and heating to 600 Celsius, which burns off any carbon present. This allows us to be certain that any carbon detected during total organic carbon analysis or UV 254 analysis was introduced from the environment and not some other source of contamination. Objects that should be ashed include 40 mL vials, DOC vials for the TOC analyzer, and Glass Filters for sample processing. To ash your materials: 1. Wrap the materials in aluminum foil. Make sure that everything is completely covered so that it will not become contaminated after removal from the furnace. Filters can be ashed by placing 50 or so in an envelope made by folding aluminum foil (they do not have to be individually placed). 2. Place wrapped materials into the furnace located in the LER. Ensure that the door is able to close without obstruction. Close the door and lock into place by turning the handle 3. Press the run button once. You should see a program pop up. Press the run button again. You will hear a click. The furnace will automatically heat to 600 Celsius and cool off. Do not open the furnace door if the internal temperature is more than 100 Celsius. This will result in glassware shattering due to rapid temperature change. 4. Once materials have cooled bring them back to the lab and place them in a safe place. ### Autoclaving Microbial Bottles Bottles used for microbial samples must be autoclaved prior to use in order to sterilize them. This ensures that all microbial colonies detected during sampling are actually coming from the sample and not just from contamination in the bottles. The autoclave is located in ISTB4 Lab 321. To autoclave the bottles follow this procedure: 1. Check to make sure that what you are autoclaving is actually autoclavable. Using non-autoclavable bottles will result in them melting and possibly damaging the autoclave. 2. Loosen caps on the bottles so that they are only tightened a quarter turn. If the caps are too tight the change in pressure in the autoclave will result in rupturing of the bottles. 3. Place a strip of autoclave tape over the top of the bottle/cap to ensure that the cap does not fall off the bottle. The autoclave tape will turn black upon completion to help you verify that the proper temperature for sterilization did actually occur. 4. Check to make sure autoclave is at proper water levels. There should be water inside the bottom of the autoclave and the water tank should have a level between low and high. 5. Place bottles in the basket and place inside autoclave. Secure the lid by locking the latch. 6. Select solid mode and ensure that temperature is set for 121 C and time is set for 15 minutes. Autoclaving takes approximately 1.5 hours. 7. Remove objects from autoclave and secure lids. Store in a place where no one will mistakenly steal sterilized bottles. ### Preparation of Microbial Media We need to make two types of media – Brilliance for coliform and E. coli detection and 7H11 for mycobacterium detection. Each plate should have 15-20 mL of media in it to avoid drying out during incubation. #### To make Brilliance media: 1. Figure out how much media you will be making. You can make up to 2 months of media at a time. Each site where microbial measurements are taken (Pima, 56th, Cent, R3, HOC, HTC, MOC, R11, R12, R13, HWY 87, and R25) needs its own plate. 2. Measure out the required volume of water. You will need to use DI water. 3. Pour water into a flask place on hotplate and begin heating. Add a magnetic stirrer and mix. 4. Measure out the media (the side of the bottle has the required ratio of media to water). 5. Add the media and cover the flask with aluminum foil. 6. Once the solution is boiling and clears up turn off the heat. 7. Cool the media down to 50 C (approximately when you can touch the glass without burning your hand). 8. Turn on a Bunsen burner and allow it to run. Using a 25 mL serological pipette fill each plate with 15ish mL of liquid media. Allow media to cool on benchtop. 9. Once media is cool and has solidified place the plates in a bag and label with your name, media type and date. Store lid side down in the fridge until use is required. #### To make 7H11 media: 1. Figure out how much media you will be making. You can make up to 2 months of media at a time. You will need 1 plate for every 2 sampling sites. 2. Measure out the required volume of water. You will need to use DI water. 3. Pour water into a flask place on hotplate and begin heating. Add a magnetic stirrer and mix. 4. Measure out the media (the side of the bottle has the required ratio of media to water). 5. Add the media and 1 mL of 50% glyceryl solution for every 100 mL of solution and cover the flask with aluminum foil. 6. Once the solution is boiling and clears up turn off the heat. 7. Take the solution along with another flask filled with 100 mL DI water to the autoclave and autoclave on the 15 min liquid default cycle. 8. Once autoclave is complete bring the solution back to the lab and place it on a mixer. Add 10 mL of OADC growth supplement (kept in the fridge) for every 100 mL of solution. Transfer 10 mL of autoclaved DI water into 1 vial of Panta BBL Antibiotic (also kept in fridge) mix and add to solution for every 100 mL of solution. Mix thoroughly 9. Turn on a Bunsen burner and allow it to run. Using a 25 mL serological pipette fill each plate with 15ish mL of liquid media. Allow media to cool on benchtop. 10. Once media is cool and has solidified place the plates in a bag and label with your name, media type and date. Store lid side down in the fridge until use is required. Analysis -------- ### Membrane Filtration for E. coli and Fecal Coliforms Within 24 hours of sample collection you will need to filter the microbial samples to quantify coliforms and E. coli. Samples should be refrigerated from collection until membrane filtration. To perform membrane filtration: 1. Gather required supplies for membrane filtration (forceps, Bunsen burner and propane, Millipore membrane filters, ethyl alcohol, lighter, autoclaved filtration cups). 2. Check the level of the pump oil and fill to the line if necessary. 3. Remove the cap from one of the vacuums on the filtration unit. Spray with ethyl alcohol solution and light with Bunsen burner. This will sterilize the surface. 4. Flame the forceps in the Bunsen burner. Pick up a Millipore filter and place on the vacuum. 5. Place a filtration cup over the vacuum. Pour the sample up to 100 mL line on the filtration cup. 6. Turn on the vacuum pump and twist the valve to open the vacuum to filter the samples. 7. Once all of the sample has drained through the vacuum close the valve and shut off the pump. 8. Flame the forceps, remove the filtration cup, and pick up the filter from the vacuum. Place on top of the Brilliance media plate (hatched side up) being careful not to trap any air bubbles under the filter. 9. Repeat the process until all samples have been filtered. Place all plates in the incubator lid side down. Incubate 18-24 hours and count. Coliform colonies are purple/pink while E. coli colonies are blue. Be sure to dump the filtered water in the flask after you perform membrane filtration as part of clean up. If you cannot count the samples right away place them in the fridge lid side down. You have a few days before the plates will no longer be countable. ### Membrane Filtration for Mycobacterium Mycobacterium is the other microbe that we look for. Samples must be filtered within 2 weeks of collection (mycobacterium is a much hardier organism than coliforms). Samples should be refrigerated from collection until membrane filtration. To perform membrane filtration: 1. Gather required supplies for membrane filtration (forceps, Bunsen burner and propane, Millipore membrane filters, ethyl alcohol, lighter, autoclaved filtration cups). 2. Check the level of the pump oil and fill to the line if necessary. 3. Remove the cap from one of the vacuums on the filtration unit. Spray with ethyl alcohol solution and light with Bunsen burner. This will sterilize the surface. 4. Flame the forceps in the Bunsen burner. Pick up a Millipore filter and place on the vacuum. 5. Place a filtration cup over the vacuum. Pour the sample up to 100 mL line on the filtration cup. 6. Turn on the vacuum pump and twist the valve to open the vacuum to filter the samples. Drain the sample down to approximately 5 mL and close the valve (shut off the pump). 7. Add 5 mL of 4% NaOH solution. Cover the filtration cup with aluminum foil and let it sit for 30 minutes. 8. After 30 minutes add 5 mL of 3% HCl solution. Allow the sample to sit for 1 minute to neutralize. Turn on the pump and drain the remaining sample. 9. Once all of the sample has drained through the vacuum close the valve and shut off the pump. 9. Flame the forceps, remove the filtration cup, and pick up the filter from the vacuum. Place on top of the 7H11 media plate (hatched side up) being careful not to trap any air bubbles under the filter. 10. Repeat the process until all samples have been filtered. Place all plates in the incubator lid side down. Incubate for 2 weeks and count. Due to the expense of the 7H11 media we generally put 2 filters on each plate. If you cannot count the samples right away place them in the fridge lid side down. You have a few days before the plates will no longer be countable. ### Sample Filtration for UV254/DOC Collected samples will need to be filtered through ashed 0.45 micron glass filters to remove particles to ensure that the only carbon remaining is dissolved carbon (the difference between DOC – Dissolved Organic Carbon and TOC- Total Organic Carbon). To filter these samples follow the following procedure: 1. Make sure that you have ashed the 0.45 micron glass filters before filtration 2. Using a gloved hand place 1 filter inside the filter tip for the 60 mL syringe. 3. Attach the filter tip to the 60 mL syringe once the plunger has been removed. 4. Pour 20-30 mL of your sample from the 250 mL amber bottle into the syringe, swirl and dump out to rinse the syringe. 5. Fill the 60 mL syringe all the way full of your sample. Place the syringe over the 40 mL vial, insert the plunger and flush sample through the filter down to the 40 mL mark on the syringe. 6. Dump the vial out to rinse it. 7. Filter the remaining 40 mL from the syringe into the 40 mL vial and cap. 8. Move on to the next sample. ### UV254 To run UV254 follow this procedure: 1. Turn on the Hach DR 5000 by flicking the power switch back panel on the upper left side. 2. System will perform self check 3. Select single wavelength, confirm that 254 is the wavelength selected 4. Insert cuvette filled with nanopure and select zero 5. Dump the nanopure and fill with your sample sample then press read, it will display the absorbance value. 6. Record the absorbance value, dump your sample and refill the cuvette with the next sample. 7. Once all samples have been run flick the power switch to turn off the machine. In between samples you may spill on the cuvette. Use a kimwipe to clean off the surface of the cuvette without scratching it. Make sure that you are using a quartz cuvette. The plastic cuvettes will not give you accurate results. ### DOC Once you have filtered your samples into the 40 mL amber vials you can run DOC (Dissolved Organic Carbon). The tool we use for this is the Shimadzu TOC-5000A Total Organic Carbon Analyzer. To operate the TOC-5000A complete the following procedure: 1. Turn on the gas cylinder by turning the metal valve on top of the cylinder in a counterclockwise direction 1 turn. You should see the indicators on the regulator turn to indicate the pressure of the cylinder and the pressure of the gas flowing through the line. The right indicator is the pressure of the cylinder, which should be about 2000 psi when full. This pressure will slowly decrease over time as you run samples until it reaches 500 psi, in which case the cylinder pressure will be too low to continue operation and a new cylinder will have to be ordered. The indicator on the left is the pressure of the gas flowing through the line, which should be adjusted to 90 psi by turning the dial on the regulator. 2. Turn on the TOC Analyzer by flipping the switch located on the bottom rear of the left side panel of the machine. It will begin to power on. Press F5 for the ASI Initial Option, which will begin to start up the machine. The autosampler will begin to rotate and toggle the needles back and forth as part of a self check. Once home position is found the machine will be turned on. Press F1 for next. 3. Use the arrows on the control panel to select option 3 General Conditions. Press Enter to select. Scroll down to Furnace On/Off and press 1 to turn it to TOC mode. This will begin to heat the furnace of the TOC Analyzer. Return to the main menu by selecting F2. 4. Scroll down to 6 Monitor to observe the conditions of the machine. There are 5 characteristics here to ensure that the machine is operating correctly: TC Furnace Temperature (Should be 680 C for proper operation), Dehumidifier Temperature (Should be 0.5-2 C for proper operation), Baseline Position (should be at the middle of the screen near 0 on the plot), Baseline Fluctuation (should be smooth without any waves), and Baseline Noise (should not have bumps in the baseline). Once everything is ready it will say OK next to each parameter and if things are not ready they will say NG. The Green light will come on next to Ready on the front panel once the machine is ready to run samples. You can check the carrier gas in the machine (next to sparge gas) and adjust to 150 ml/min for proper operation. Sparge gas should be adjusted to 90 ml/min when sparging. You generally want to run a steady baseline for a few hours prior to initiating a sample run. 5. Load your samples and standards into the autosampler. Number a piece of paper with the numbers of the vials on the autosampler. Begin by loading blanks (nanopure water) into the first 3 vials. Pour your filtered samples from the 40 mL vials into the DOC vials and place them in position, noting the vial number on your piece of paper. 3 Blanks should be run every 10-12 vials to validate accuracy of the TOC analysis. Blanks should be within +/- 0.5 mg/L of 0 mg/L to ensure accurate data. 6. Perform a final check of the machine prior to beginning your run. Ensure that all of the samples and standards have been properly loaded. Ensure that the lid of the autosampler is properly on. Ensure that the nanopure rinse water and humidifier water levels are appropriately full. Ensure that there is enough printout paper loaded in the top of the machine. Address these issues before beginning sample run. 7. Return to the main menu and select 9 Auto Sampler to set up your sample run. Under Type make sure that NPOC is selected. For IS, which means initial sample, type the number of the initial vial you would like to run from the autosampler. For FS, which means final sample, type the number of the final vial you would like to run from the autosampler. Under C1 click enter to select the calibration curve. Using CAL Curve F1 you will see the 1st Standard as 10 mg/L in vial S4, 2nd Standard as 5 mg/L in vial S3, 3rd Standard as 1 mg/L in vial S2, and 4th Standard as 0 mg/L in vial S1. You should select an injection volume of 53 microliters, 3 injections with a maximum of 5, an SD of 200, and a CV of 2.0%. Sparge time should be set to 5 minutes. Make sure shift to origin and acid addition are both off. Press F2 to return. 8. Ensure that your sample volume is set to 53 microliters, 3 injections with a maximum of 5, 200 SD, 2.0% CV, and 2 SP (sparge time) for your samples. Once this is complete press F1 for next. Ensure that Rinse is turned on, 2 needle washes and 2 flow line washes are selected. Press F2 for next. Press Start and your samples will begin to run. The autosampler will allow for your samples to run on their own without any additional effort from you. Samples can be run overnight. It generally takes between 18-24 hours to run an entire month’s worth of samples. Once you return to see that all the samples have finished running you can power down the machine if it has cooled. The machine will tell you whether it is ok to power down or whether you should allow it to stay on for 30 minutes to prevent overheating. To power down the machine flick the power switch and turn off the gas cylinder. ### TDN TDN is run by the Goldwater Environmental Lab.

People and Organizations

Publishers:

Organization:

Central Arizona–Phoenix LTER

Address:

Arizona State University,

Global Institute of Sustainability,

Tempe, AZ 85287-5402 USA

Creators:

Individual:

Peter Fox

Organization:

Arizona State University

Email Address:

peter.fox@asu.edu

Individual:

Morteza Abbaszadegan

Organization:

Arizona State University

Email Address:

Abbaszadegan@asu.edu

Contacts:

Organization:

Central Arizona–Phoenix LTER

Position:

Information Manager

Address:

Arizona State University,

Global Institute of Sustainability,

Tempe, AZ 85287-5402 USA

Email Address:

caplter.data@asu.edu

Web Address:

https://sustainability.asu.edu/caplter/

Associated Parties:

Individual:

Paul Westerhoff

Organization:

Arizona State University

Email Address:

p.westerhoff@asu.edu

Role:

former associate of project

Individual:	Milton Sommerfeld
Organization:	Arizona State University, Polytechnic campus
Role:	former associate of project

Metadata Providers:

Individual:

Marisa Masles

Organization:

Arizona State University

Email Address:

Marisa.Masles@asu.edu

Temporal, Geographic and Taxonomic Coverage

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

Time Period

Begin:

1999-08-16

End:

2020-07-23

Geographic Region:

Description:

canals, water treatment plants, and reservoirs in the greater phoenix metropolitan area

Bounding Coordinates:

Northern:	33.49	Southern:	33.2917
Western:	-111.125	Eastern:	-111.1235

Project

Parent Project Information:

Title:

Central Arizona–Phoenix Long-Term Ecological Research Project

Personnel:

Individual:

Daniel Childers

Organization:

Arizona State University

Email Address:

dan.childers@asu.edu

Id:

https://orcid.org/0000-0003-3904-0803

Role:

Principal Investigator

Individual:

Nancy Grimm

Organization:

Arizona State University

Email Address:

nbgrimm@asu.edu

Id:

https://orcid.org/0000-0001-9374-660X

Role:

Co-principal Investigator

Individual:

Sharon Hall

Organization:

Arizona State University

Email Address:

sharonjhall@asu.edu

Id:

https://orcid.org/0000-0002-8859-6691

Role:

Co-principal Investigator

Individual:

Billie Turner II

Organization:

Arizona State University

Email Address:

Billie.L.Turner@asu.edu

Id:

https://orcid.org/0000-0002-6507-521X

Role:

Co-principal Investigator

Individual:

Abigail York

Organization:

Arizona State University

Email Address:

Abigail.York@asu.edu

Id:

https://orcid.org/0000-0002-2313-9262

Role:

Co-principal Investigator

Abstract:

Phase IV of the Central Arizona-Phoenix LTER (CAP) continues to focus on the question: How do the ecosystem services provided by urban ecological infrastructure (UEI) affect human outcomes and behavior, and how do human actions affect patterns of urban ecosystem structure and function and, ultimately, urban sustainability and resilience? The overarching goal is to foster social-ecological urban research aimed at understanding these complex systems using a holistic, ecology of cities perspective while contributing to an ecology for cities that enhances urban sustainability and resilience. This goal is being met through four broad programmatic objectives: (1) use long-term observations and datasets to articulate and answer new questions requiring a long-term perspective; (2) develop and use predictive models and future-looking scenarios to help answer research questions; (3) employ existing urban ecological theory while articulating new theory; and (4) build transdisciplinary partnerships to foster resilience and enhance sustainability in urban ecosystems while educating urban dwellers of all ages and experiences. CAP IV research is organized around eight interdisciplinary questions and ten long-term datasets and experiments, and researchers are organized into eight Interdisciplinary Research Themes to pursue these long-term research questions.

Funding:

NSF Awards: CAP I: DEB-9714833, CAP II: DEB-0423704, CAP III: DEB-1026865, CAP IV: DEB-1832016

Additional Award Information:

Funder:

National Science Foundation

Funder ID:

https://ror.org/021nxhr62

Number:

1832016

Title:

LTER: CAP IV - Investigating urban ecology and sustainability through the lens of Urban Ecological Infrastructure

URL:

https://nsf.gov/awardsearch/showAward?AWD_ID=1832016&HistoricalAwards=false

Other Metadata

Additional Metadata

additionalMetadata
        |___text '\n    '
        |___element 'metadata'
        |     |___text '\n      '
        |     |___element 'unitList'
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'microsiemenPerCentimeter'
        |     |     |     |  \___attribute 'multiplierToSI' = '0.000001'
        |     |     |     |  \___attribute 'name' = 'microsiemenPerCentimeter'
        |     |     |     |  \___attribute 'parentSI' = 'siemen'
        |     |     |     |  \___attribute 'unitType' = 'conductance'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'electric conductance of lake water in the units of microsiemenPerCentimeter'
        |     |     |     |___text '\n        '
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'perCentimeter'
        |     |     |     |  \___attribute 'multiplierToSI' = 'unknown'
        |     |     |     |  \___attribute 'name' = 'perCentimeter'
        |     |     |     |  \___attribute 'parentSI' = 'unknown'
        |     |     |     |  \___attribute 'unitType' = 'unknown'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'absorbance per centimeter of path length at 254 nm'
        |     |     |     |___text '\n        '
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'literPerMilligramMeter'
        |     |     |     |  \___attribute 'multiplierToSI' = 'unknown'
        |     |     |     |  \___attribute 'name' = 'literPerMilligramMeter'
        |     |     |     |  \___attribute 'parentSI' = 'unknown'
        |     |     |     |  \___attribute 'unitType' = 'unknown'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'the UV absorbance at 254 nanometers measured in inverse meters divided by the DOC concentration measured in milligrams per liter'
        |     |     |     |___text '\n        '
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'nanogramsPerLiter'
        |     |     |     |  \___attribute 'multiplierToSI' = '0.000001'
        |     |     |     |  \___attribute 'name' = 'nanogramsPerLiter'
        |     |     |     |  \___attribute 'parentSI' = 'kilogram/cubic meter'
        |     |     |     |  \___attribute 'unitType' = 'amountOfSubstanceConcentration'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'nanograms of material per liter of solute'
        |     |     |     |___text '\n        '
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'coloniesPer100milliliter'
        |     |     |     |  \___attribute 'multiplierToSI' = 'unknown'
        |     |     |     |  \___attribute 'name' = 'coloniesPer100milliliter'
        |     |     |     |  \___attribute 'parentSI' = 'unknown'
        |     |     |     |  \___attribute 'unitType' = 'unknown'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'number of bacterial colonies formed per 100 millileters of water'
        |     |     |     |___text '\n        '
        |     |     |___text '\n      '
        |     |___text '\n    '
        |___text '\n  '

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:

Data Package Metadata View Summary

Regional drinking water quality monitoring program: long-term monitoring of water quality in select canals, reservoirs, and treatment plants of the greater Phoenix, Arizona metropolitan area drinking water system, ongoing since 1998

Data Entities

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Package Usage Rights

Keywords

Methods and Protocols

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

People and Organizations

Temporal, Geographic and Taxonomic Coverage

Project

Parent Project Information:

Additional Metadata

Recently Added

Recently Updated

Data Package Metadata View Summary

Regional drinking water quality monitoring program: long-term monitoring of water quality in select canals, reservoirs, and treatment plants of the greater Phoenix, Arizona metropolitan area drinking water system, ongoing since 1998

+/- Data Entities

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

+/- Data Package Usage Rights

+/- Keywords

+/- Methods and Protocols

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

+/- People and Organizations

+/- Temporal, Geographic and Taxonomic Coverage

+/- Project

Parent Project Information:

+/- Additional Metadata

Data Entities

Data Package Usage Rights

Keywords

Methods and Protocols

People and Organizations

Temporal, Geographic and Taxonomic Coverage

Project

Additional Metadata