Skip to Content
Report an accessibility problem

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

Publication date: 2020-08-04

Author(s):

  • Peter Fox, Arizona State University
  • Morteza Abbaszadegan, Arizona State University
  • Paul Westerhoff
  • Milton Sommerfeld

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.

Keywords:


Temporal Coverage:

1999-08-16 to 2020-07-23

Geographic Coverage:

Geographic Description: canals, water treatment plants, and reservoirs in the greater phoenix metropolitan area
Bounding Coordinates:
Longitude:-111.125 to -111.1235
Latitude:33.49 to 33.2917

Contact:

Information Manager, Central Arizona–Phoenix LTER, 
Arizona State University,Global Institute of Sustainability,Tempe
 caplter.data@asu.edu

Methods used in producing this dataset: Show


Data Files (10) :

Tabular: 617_algae_49fa96bded7c86b3720d56a128efc5a7.csv

Description: algal characteristics (chlorophyll concentration, cell counts) and specific conductance in canals and reservoirs

Column Description Type Units
site number site number or name (A designates epilimnion, B hypolimnion)
string
Enumeration:
  • 16th St.: AZ Canal at 16th Street
  • 19th Av.: AZ Canal at 19th Avenue
  • AN IN: Anthem WTP Inlet
  • CH IN: Chandler WTP Inlet
  • Cons: Consolidated canal
  • field_blank: Field blank
  • Glendale In: Glendale WTP Inlet
  • Glendale Out: Glendale WTP Treated
  • Green In: Greenway WTP Inlet
  • Green Out: Greenway WTP Treated
  • Havasu 1: Lake Havasu Site 1
  • Havasu 2: Lake Havasu Site 2
  • HOC: Head of the Consolidated canal
  • HTC: Head of the Tempe Canal
  • Hwy 87: AZ Canal at Highway 87
  • lab_blank: Laboratory blank
  • Mesa: AZ Canal at Mesa Dr.
  • Mesa Turnout: Mesa Canal Turnout
  • MOC: Middle of the Consolidated canal
  • NP In: Tempe North WTP Inlet
  • NP Out: Tempe North WTP Treated
  • Pima: AZ Canal at Pima Rd
  • R1: CAP canal above Waddell Canal
  • R10: Salt River below Saguaro (Blue Point Bridge)
  • R11: CAP Canal at Cross-connect
  • R12: AZ Canal above CAP Cross-connect
  • R13: AZ Canal below CAP Cross-connect
  • R14: AZ Canal - Inlet to Squaw Peak WTP
  • R15: Squaw Peak WTP treated water
  • R16: AZ Canal - Inlet to Deer Valley WTP
  • R17: Deer Valley WTP treated water
  • R18: South Canal at Val Vista WTP
  • R19: Val Vista WTP treated water
  • R20: Verde River at Tangle
  • R21: AZ Canal - Central Avenue
  • R22: AZ Canal at 56th
  • R25: Verde River at Beeline
  • R26: Arizona Canal at 19th Ave.
  • R2A: Lake Pleasant integrated sample
  • R2B: Lake Pleasant integrated sample
  • R3: Waddell Canal
  • R4: Cap Canal at 7th St.
  • R4-Dup: Cap Canal at 7th St. Duplicate Sample
  • R5: Verde River btwn Horseshoe and Bartlett
  • R5dup: Verde River btwn Horseshoe and Bartlett Duplicate Sample
  • R6A: Bartlett Reservoir near outlet
  • R6B: Bartlett Reservoir near outlet
  • R7: Verde River below Bartlett Reservoir
  • R8: Salt River inlet to Saguaro Lake
  • R9A: Saguaro Lake near inlet
  • R9A-Dup: Saguaro Lake near inlet Duplicate Sample
  • R9B: Saguaro Lake near inlet
  • Roos In: Salt River Inlet Near Roosevelt Lake
  • Roosvelt: SRP above Roosevelt Lake
  • Salt Gila: Salt-Gila Pump Station
  • Scotts: AZ Canal at Scottsdale Rd.
  • SOCA: South Canal below CAP Cross-connect
  • SPT In: Tempe South WTP Inlet
  • SPT Out: Tempe South WP Treated
  • UH In: Union Hills WTP Inlet
  • UH Out: Union Hills WTP Treated
site location site location description
string
cluster source water
string
Enumeration:
  • az canal: Arizona canal
  • cap: Central Arizona Project canal
  • salt: Salt River
  • srp: Salt River Project canal
  • tempe: Tempe, AZ area canal
  • verde: Verde River
site acronym site number or name
string
Enumeration:
  • Above Roosevelt: metadata_not_provided
  • az canal: metadata_not_provided
  • az canal @ 16th st.: AZ Canal at 16th Street
  • az canal @ 19 ave.: AZ Canal at 19th Avenue
  • az canal @ 19th av.: AZ Canal at 19th Avenue
  • az canal @ 56th st.: AZ Canal at 56th Street
  • az canal @ central ave.: AZ Canal at Central Avenue
  • az canal @ deer valley: AZ Canal - Inlet to Deer Valley WTP
  • az canal @ hwy 87: AZ Canal at Highway 87
  • az canal @ Mesa: AZ Canal at Mesa Dr.
  • az canal @ pima: AZ Canal at Pima Rd
  • az canal @ scotts.: AZ Canal at Scottsdale Rd.
  • az canal @ squaw peak: AZ Canal - Inlet to Squaw Peak WTP
  • az canal blw cap: AZ Canal below CAP Cross-connect
  • az canal inflow: AZ Canal above CAP Cross-connect
  • bartlett-epi: Bartlett Reservoir near outlet
  • bartlett-hypo: Bartlett Reservoir near outlet
  • cap @ 7th st: Cap Canal at 7th St.
  • cap @ 7th st dup: Cap Canal at 7th St. Duplicate Sample
  • cap @ x con: CAP Canal at Cross-connect
  • cap-siphon: metadata_not_provided
  • deer valley-treated: Deer Valley WTP treated water
  • Glen In: Glendale WTP Inlet
  • Glen Out: Glendale WTP Treated
  • Green In: Greenway WTP Inlet
  • Green Out: Greenway WTP Treated
  • Havasu 1: Lake Havasu Site 1
  • Havasu 2: Lake Havasu Site 2
  • head of tempe canal: Head of Tempe Canal
  • HOC: Head of the Consolidated canal
  • MOC: Middle of the Consolidated canal
  • MTO: Mesa Canal Turnout
  • North plant inlet: Tempe North WTP Inlet
  • north plant outlet: Tempe North WTP Treated
  • pleasant-epi: Lake Pleasant integrated sample
  • pleasant-hypo: Lake Pleasant integrated sample
  • s canal @ val vista: South Canal at Val Vista WTP
  • saguaro-epi: Saguaro Lake Epilimnion
  • saguaro-epi dup: Saguaro Lake Epilimnion Duplicate Sample
  • saguaro-hypo: Saguaro Lake Hypolimnion
  • salt abv saguaro: Salt River inlet to Saguaro Lake
  • salt blw saguaro: Salt River below Saguaro (Blue Point Bridge)
  • SGPS: Salt Gila Pump Station
  • South canal below CAP: South Canal below CAP Cross-connect
  • squaw peak-treated: Squaw Peak WTP treated water
  • SRNR: Salt River Inlet Near Roosevelt Lake
  • STP In: Tempe Canal - Inlet to Tempe's South Plant
  • STP Out: Tempe's South Plant treated water
  • Union Hills Inlet: Union Hills WTP Inlet
  • Union Hills Outlet: Union Hills WTP Treated
  • val vista-treated: Val Vista WTP treated water
  • verde @ beeline: verde river at beeline highway
  • verde abv bartlett: Verde River btwn Horseshoe and Bartlett
  • verde abv horseshoe: Verde River at Tangle
  • verde blw barlett: Verde River below Bartlett Reservoir
  • waddell canal: Waddell Canal
date sample collection date
date Format: YYYY-MM-DD
sample type type of water sample collected (if not a field sample)
string
Enumeration:
  • field blank: Field blank
  • field duplicate: Field duplicate sample
  • had white ppt: metadata_not_provided
  • has white ppt: metadata_not_provided
  • lab blank: Laboratory blank
  • only field duplicate: metadata_not_provided
conductance (uS/cm) specific conductance
float microsiemensPerCentimeter
chl A (ug/L) chlorophyll A concentration
float microgramsPerLiter
phaeophytin (ug/L) phaeophytin concentration
float microgramsPerLiter
phaeophytin chl A (ug/L) chlorophyll A concentration corrected for phaeophytin
float microgramsPerLiter
chlorophyta (organisms/ml) Chlorophyta concentration
float numberPerMilliliter
cyanophyta (organisms/ml) Cyanophyta concentation
float numberPerMilliliter
bacillariophyta (organisms/ml) Bacillariophyta concentration
float numberPerMilliliter
total (organisms/ml) combined concentration of Chlorophyta, Cyanophyta, and Bacillariophyta
float numberPerMilliliter
algae comments comment(s) about site conditions or sampling details
string

Tabular: 617_algal_byproducts_d4765274e6268e53e82bfece5fabb7e3.csv

Description: concentration of algal by-products in canals and reservoirs

Column Description Type Units
site number site number or name (A designates epilimnion, B hypolimnion)
string
Enumeration:
  • 16th St.: AZ Canal at 16th Street
  • 19th Av.: AZ Canal at 19th Avenue
  • 32nd St.: AZ Canal at 32nd Street
  • 44th St.: AZ Canal at 44th Street
  • 7th Av.: metadata_not_provided
  • 7th St.: AZ Canal at 7th Street
  • AN In: Anthem WTP Inlet
  • AN Out: Anthem WTP Treated
  • CH In: Chandler WTP Inlet
  • CH Out: Chandler WTP Treated
  • Cons: Consolidated canal
  • field_blank: Field blank
  • field_spike: Field spike
  • Glen In: Glendale WTP Inlet
  • Glen Out: Glendale WTP Treated
  • GR In: Greenway WTP Inlet
  • GR Out: Greenway WTP Treated
  • Green In: Greenway WTP Inlet
  • Green Out: Greenway WTP Treated
  • Havasu 1: Lake Havasu Site 1
  • Havasu 2: Lake Havasu Site 2
  • HOC: Head of the Consolidated canal
  • HTC: Head of the Tempe Canal
  • Hwy 87: AZ Canal at Highway 87
  • ISTB4: ISTB4 building drinking water
  • lab_blank: Laboratory blank
  • Mesa: AZ Canal at Mesa Dr.
  • Mesa Turnout: Mesa Canal Turnout
  • MOC: Middle of the Consolidated canal
  • Northern: AZ Canal at Northern Avenue
  • NP In: Tempe North WTP Inlet
  • NP Out: Tempe North WTP Treated
  • Pima: AZ Canal at Pima Rd
  • R1: CAP canal above Waddell Canal
  • R10: Salt River below Saguaro (Blue Point Bridge)
  • R10rain: Salt River below Saguaro (Blue Point Bridge) rain sample
  • R11: CAP Canal at Cross-connect
  • R11rain: CAP Canal at Cross-connect rain sample
  • R12: AZ Canal above CAP Cross-connect
  • R12rain: AZ Canal above CAP Cross-connect rain sample
  • R13: AZ Canal below CAP Cross-connect
  • R13rain: AZ Canal below CAP Cross-connect rain sample
  • R14: AZ Canal - Inlet to Squaw Peak WTP
  • R15: Squaw Peak WTP treated water
  • R16: AZ Canal - Inlet to Deer Valley WTP
  • R17: Deer Valley WTP treated water
  • R18: South Canal at Val Vista WTP
  • R18sediment: South Canal at Val Vista WTP sediment sample
  • R19: Val Vista WTP treated water
  • R20: Verde River at Tangle
  • R21: AZ Canal - Central Avenue
  • R22: AZ Canal at 56th
  • R23: metadata_not_provided
  • R24: metadata_not_provided
  • R25: Verde River at Beeline
  • R25ex: verde river at beeline highway extra sample
  • R25rain: verde river at beeline highway rain sample
  • R26: Arizona Canal at 19th Ave.
  • R2A: Lake Pleasant integrated sample
  • R2B: Lake Pleasant integrated sample
  • R3: Waddell Canal
  • R4: Cap Canal at 7th St.
  • R4-Dup: Cap Canal at 7th St. duplicate sample
  • R4dup: Cap Canal at 7th St. duplicate sample
  • R5: Verde River btwn Horseshoe and Bartlett
  • R5ex: Verde River btwn Horseshoe and Bartlett
  • R6A: Bartlett Reservoir near outlet
  • R6B: Bartlett Reservoir near outlet
  • R6C: Bartlett Lake near dock
  • R7: Verde River below Bartlett Reservoir
  • R8: Salt River inlet to Saguaro Lake
  • R9@10m: Saguaro Lake at 10m
  • R9A: Saguaro Lake near inlet
  • R9A-Dup: Saguaro Lake near inlet duplicate sample
  • R9Adup: Saguaro Lake near inlet duplicate sample
  • R9B: Saguaro Lake near inlet
  • R9Bturbid: Saguaro Lake hypolimnion turbidity sample
  • R9C: Saguaro Lake near dock
  • RA Dup: Saguaro Lake Epilimnion duplicate sample
  • Roos: Roosevelt Lake
  • Roos In: Salt River Inlet Near Roosevelt Lake
  • Roosvelt: SRP above Roosevelt Lake
  • Salt-Gila: Salt-Gila Pump Station
  • Scotts: AZ Canal at Scottsdale Rd.
  • SOCA: South Canal below CAP Cross-connect
  • SPT In: Tempe South WTP Inlet
  • SPT Out: Tempe South WP Treated
  • UH In: Union Hills WTP Inlet
  • UH Out: Union Hills WTP Treated
  • union hills: union hills water treatment plant impoundment
  • VV west: Val Vista West WTP treated water
site location site location description
string
cluster source water
string
Enumeration:
  • cap: Central Arizona Project canal
  • salt: Salt River
  • srp: Salt River Project canal
  • tempe: Tempe, AZ area canal
  • verde: Verde River
site acronym site number or name
string
Enumeration:
  • 24th St-treated: 24th St. Water Treatment Plant treated water
  • Above Roosevelt: SRP above Roosevelt Lake
  • Anthem In: Anthem WTP Inlet
  • Anthem Out: Anthem WTP Treated
  • az canal @ 16th st.: AZ Canal at 16th Street
  • az canal @ 19 ave.: AZ Canal at 19th Avenue
  • az canal @ 19th av.: AZ Canal at 19th Avenue
  • az canal @ 24th St: AZ Canal at 24th Street
  • az canal @ 32nd st.: AZ Canal at 32nd Street
  • az canal @ 44th st.: AZ Canal at 44th Street
  • az canal @ 48th st.: AZ Canal at 48th Street
  • az canal @ 56th st.: AZ Canal at 56th Street
  • az canal @ 7th av.: AZ Canal at 7th Avenue
  • az canal @ central ave.: ZA Canal at Central Avenue
  • az canal @ deer valley: AZ Canal - Inlet to Deer Valley WTP
  • az canal @ hwy 87: AZ Canal at Highway 87
  • az canal @ Mesa: metadata_not_provided
  • az canal @ northern: metadata_not_provided
  • az canal @ pima: AZ Canal at Pima Rd
  • az canal @ scotts.: metadata_not_provided
  • az canal @ squaw peak: AZ Canal - Inlet to Squaw Peak WTP
  • az canal blw cap: AZ Canal below CAP Cross-connect
  • az canal inflow: AZ Canal above CAP Cross-connect
  • bartlett-epi: Bartlett Reservoir near outlet
  • bartlett-hypo: Bartlett Reservoir near outlet
  • cap-siphon: metadata_not_provided
  • cap @ 7th st: Cap Canal at 7th St.
  • cap @ 7th st dup: Cap Canal at 7th St. duplicate sample
  • cap @ x con: CAP Canal at Cross-connect
  • central & griswold: metadata_not_provided
  • Chandler Inlet: Chandler WTP Inlet
  • Chandler Treated: Chandler WTP Treated
  • deer valley-treated: Deer Valley WTP treated water
  • Glen In: Glendale WTP Inlet
  • Glen out: Glendale WTP Treated
  • Glen Out: Glendale WTP Treated
  • Green In: Greenway WTP Inlet
  • Green Out: Greenway WTP Treated
  • Havasu 1: Lake Havasu Site 1
  • Havasu 2: Lake Havasu Site 2
  • head of tempe canal: Head of the Tempe Canal
  • Head of the Consolidated Canal: Head of the Consolidated canal
  • ISTB4: metadata_not_provided
  • Middle of the Consolidated Canal: Middle of the Consolidated canal
  • MTO: Mesa Canal Turnout
  • North plant inlet: Tempe North WTP inlet
  • north plant outlet: Tempe North WTP treated
  • pleasant-epi: Lake Pleasant integrated sample
  • pleasant-hypo: Lake Pleasant integrated sample
  • s canal @ val vista: South Canal at Val Vista WTP
  • saguaro-epi: Saguaro Lake Epilimnion
  • saguaro-epi dup: Saguaro Lake Epilimnion duplicate sample
  • saguaro-hypo: Saguaro Lake Hypolimnion
  • salt abv saguaro: Salt River inlet to Saguaro Lake
  • salt blw saguaro: Salt River below Saguaro (Blue Point Bridge)
  • SGPS: Salt Gila Pump Station
  • South canal below CAP: South Canal below CAP Cross-connect
  • squaw peak-treated: Squaw Peak WTP treated water
  • SRNR: Salt River Inlet Near Roosevelt Lake
  • STP In: Tempe Canal - Inlet to Tempe's South Plant
  • STP Out: Tempe's South Plant Treated water
  • union hills-impound: union hills water treatment plant impoundment
  • Union Hills Inlet: Union Hills WTP Inlet
  • Union Hills Outlet: Union Hills WTP Treated
  • val-vista west: Val Vista Water Treatment Plant Treated Water - West
  • val vista-treated: Val Vista WTP treated water
  • verde @ beeline: verde river at beeline highwy
  • verde above horseshoe: Verde River at Tangle
  • verde abv bartlett: Verde River btwn Horseshoe and Bartlett
  • verde abv horseshoe: Verde River at Tangle
  • verde blw barlett: Verde River below Bartlett Reservoir
  • waddell canal: Waddell Canal
date sample collection date
date Format: YYYY-MM-DD
sample type type of water sample collected (if not a field sample)
string
MIB (ng/L) ASU 2-methylisoborneol
float nanogramsPerLiter
geosmin (ng/L) ASU geosmin
float nanogramsPerLiter
beta-cyclocitral (ng/L) beta-Cyclocitral
float nanogramsPerLiter
IPMP recovery (%) recovery of 2-isopropyl-3-methoxy pyrazine (IPMP used as an internal standard)
float dimensionless
MIB (ng/L) Phoenix MIB as measured by City of Phoenix officials for methods comparison
float nanogramsPerLiter
geosmin (ng/L) Phoenix geosmin as measured by City of Phoenix officials for methods comparison
float nanogramsPerLiter
comments comment(s) about site conditions or sampling details
string

Tabular: 617_arsenic_18c9184205e943456921449878002c3a.csv

Description: arsenic and perchlorate concentrations in canals and reservoirs

Column Description Type Units
site number site number or name (A designates epilimnion, B hypolimnion)
string
Enumeration:
  • Glen In: Glendale WTP Inlet
  • Glen Out: Glendale WTP Treated
  • Green In: Greenway WTP Inlet
  • Green Out: Greenway WTP Treated
  • Havasu 1: Lake Havasu Site 1
  • Havasu 2: Lake Havasu Site 2
  • HTC: Head of the Tempe Canal
  • Hwy 87: AZ Canal at Highway 87
  • NP In: Tempe North WTP Inlet
  • NP Out: Tempe North WTP Treated
  • Pima: AZ Canal at Pima Rd
  • R10: Salt River below Saguaro (Blue Point Bridge)
  • R11: CAP Canal at Cross-connect
  • R12: AZ Canal above CAP Cross-connect
  • R13: AZ Canal below CAP Cross-connect
  • R14: AZ Canal - Inlet to Squaw Peak WTP
  • R15: Squaw Peak WTP treated water
  • R16: AZ Canal - Inlet to Deer Valley WTP
  • R17: Deer Valley WTP treated water
  • R18: South Canal at Val Vista WTP
  • R19: Val Vista WTP treated water
  • R20: Verde River at Tangle
  • R21: AZ Canal - Central Avenue
  • R22: AZ Canal at 56th
  • R25: Verde River at Beeline
  • R2A: Lake Pleasant integrated sample
  • R2B: Lake Pleasant integrated sample
  • R3: Waddell Canal
  • R6A: Bartlett Reservoir near outlet
  • R6B: Bartlett Reservoir near outlet
  • R9A: Saguaro Lake near inlet
  • R9A-Dup: Saguaro Lake near inlet
  • R9B: Saguaro Lake near inlet
  • SOCA: South Canal below CAP Cross-connect
  • SPT In: Tempe South WTP Inlet
  • SPT Out: Tempe South WP Treated
  • UH In: Union Hills WTP Inlet
  • UH Out: Union Hills WTP Treated
site location site location description
string
cluster source water
string
Enumeration:
  • cap: Central Arizona Project canal
  • salt: Salt River
  • srp: Salt River Project canal
  • tempe: Tempe, AZ area canal
  • verde: Verde River
site acronym site number or name
string
Enumeration:
  • az canal @ 56th st.: AZ Canal at 56th Street
  • az canal @ central ave.: AZ Canal at Central Avenue
  • az canal @ deer valley: AZ Canal - Inlet to Deer Valley WTP
  • az canal @ hwy 87: AZ Canal at Highway 87
  • az canal @ pima: AZ Canal at Pima Rd
  • az canal @ squaw peak: AZ Canal - Inlet to Squaw Peak WTP
  • az canal blw cap: AZ Canal below CAP Cross-connect
  • az canal inflow: AZ Canal above CAP Cross-connect
  • bartlett-epi: Bartlett Reservoir near outlet
  • bartlett-hypo: Bartlett Reservoir near outlet
  • cap @ x con: CAP Canal at Cross-connect
  • deer valley-treated: Deer Valley WTP treated water
  • Glen In: Glendale WTP Inlet
  • Glen Out: Glendale WTP Treated
  • Green In: Greenway WTP Inlet
  • Green Out: Greenway WTP Treated
  • Havasu 1: Lake Havasu Site 1
  • Havasu 2: Lake Havasu Site 2
  • head of tempe canal: Head of Tempe Canal
  • North plant inlet: Tempe North WTP Inlet
  • north plant outlet: Tempe North WTP Treated
  • pleasant-epi: Lake Pleasant integrated sample
  • pleasant-hypo: Lake Pleasant integrated sample
  • s canal @ val vista: South Canal at Val Vista WTP
  • saguaro-epi: Saguaro Lake Epilimnion
  • saguaro-epi dup: Saguaro Lake Epilimnion Duplicate Sample
  • saguaro-hypo: Saguaro Lake Hypolimnion
  • salt blw saguaro: Salt River below Saguaro (Blue Point Bridge)
  • South canal below CAP: South Canal below CAP Cross-connect
  • SPT In: Tempe South WTP Inlet
  • SPT Out: Tempe South WTP Treated
  • squaw peak-treated: Squaw Peak WTP treated water
  • STP In: Tempe Canal - Inlet to Tempe's South Plant
  • STP Out: Tempe's South Plant treated water
  • Union Hills Inlet: Union Hills WTP Inlet
  • Union Hills Outlet: Union Hills WTP Treated
  • val vista-treated: Val Vista WTP treated water
  • val vista-treated-West: Val Vista WTP treated water - west
  • verde @ beeline: verde river at beeline highway
  • verde abv horseshoe: Verde River at Tangle
  • waddell canal: Waddell Canal
arsenic (ug/L) arsenic concentration as determined by graphite furnace
float microgramsPerLiter
perchlorate (ug/L) perchlorate concentration as determined by ion chromatography
float microgramsPerLiter
date sample collection date
date Format: YYYY-MM-DD
BDL 1 = sample with arsenic concentration below detectable limit
string
Enumeration:
  • 1: 1 = below detectable limits

Tabular: 617_carbon_cc0e7f16f828061c7aa3dd325fa9f0ef.csv

Description: approximately monthly water carbon data in Phoenix-area canals and reservoirs

Column Description Type Units
site number site number or name (A designates epilimnion, B hypolimnion)
string
Enumeration:
  • 16th St.: AZ Canal at 16th Street
  • 19th Av.: AZ Canal at 19th Avenue
  • An in: Anthem WTP Inlet
  • AN in: Anthem WTP Inlet
  • AN IN: Anthem WTP Inlet
  • An out: Anthem WTP Treated
  • AN out: Anthem WTP Treated
  • AN OUT: Anthem WTP Treated
  • Ch in: Chandler WTP Inlet
  • CH in: Chandler WTP Inlet
  • CH IN: Chandler WTP Inlet
  • Ch out: Chandler WTP Treated
  • CH out: Chandler WTP Treated
  • CH OUT: Chandler WTP Treated
  • Cons: Consolidated Canal
  • field_blank: Field blank
  • Gila Salt: Salt-Gila Pump Station
  • GL IN: Glendale WTP Inlet
  • GL OUT: Glendale WTP Treated
  • Glen In: Glendale WTP Inlet
  • Glen Out: Glendale WTP Treated
  • GR IN: Greenway WTP Inlet
  • GR OUT: Greenway WTP Treated
  • Green In: Greenway WTP Inlet
  • Green Out: Greenway WTP Treated
  • HAV: Lake Havasu
  • Havasu 1: Lake Havasu Site 1
  • Havasu 2: Lake Havasu Site 2
  • HOC: Head of the Consolidated canal
  • HTC: Head of the Tempe Canal
  • Hwy 87: AZ Canal at Highway 87
  • HWY 87: AZ Canal at Highway 87
  • lab_blank: Laboratory blank
  • Mesa: AZ Canal at Mesa Dr.
  • Mesa Turnout: Mesa Canal Turnout
  • MOC: Middle of the Consolidated canal
  • MTO: Mesa Canal Turnout
  • NP In: Tempe North WTP Inlet
  • NP IN: Tempe North WTP Inlet
  • NP Out: Tempe North WTP Treated
  • NP OUT: Tempe North WTP Treated
  • Pima: AZ Canal at Pima Rd
  • PIMA: AZ Canal at Pima Rd
  • R1: CAP canal above Waddell Canal
  • R10: Salt River below Saguaro (Blue Point Bridge)
  • R11: CAP Canal at Cross-connect
  • R12: AZ Canal above CAP Cross-connect
  • R13: AZ Canal below CAP Cross-connect
  • R14: AZ Canal - Inlet to Squaw Peak WTP
  • R15: Squaw Peak WTP treated water
  • R16: AZ Canal - Inlet to Deer Valley WTP
  • R17: Deer Valley WTP treated water
  • R18: South Canal at Val Vista WTP
  • R19: Val Vista WTP treated water
  • R20: Verde River at Tangle
  • R20ex: Verde River at Tangle Creek extra sample
  • R21: AZ Canal - Central Avenue
  • R22: AZ Canal at 56th
  • R25: Verde River at Beeline
  • R26: AZ Canal at 19th Ave.
  • R2A: Lake Pleasant integrated sample
  • R2B: Lake Pleasant integrated sample
  • R3: Waddell Canal
  • R4: Cap Canal at 7th St.
  • R4-Dup: Cap Canal at 7th St. Duplicate Sample
  • R5: Verde River btwn Horseshoe and Bartlett
  • R5ex: Verde River btwn Horseshoe and Bartlett extra sample
  • R6A: Bartlett Reservoir near outlet
  • R6B: Bartlett Reservoir near outlet
  • R6C: Bartlett Lake near dock
  • R7: Verde River below Bartlett Reservoir
  • R7ex: Verde River below Bartlett Reservoir extra sample
  • R8: Salt River inlet to Saguaro Lake
  • R9A: Saguaro Lake near inlet
  • R9A-Dup: Saguaro Lake near inlet duplicate sample
  • R9A-DUP: Saguaro Lake near inlet duplicate sample
  • R9B: Saguaro Lake near inlet
  • R9C: Saguaro Lake near dock
  • Roos In: Salt River Inlet Near Roosevelt Lake
  • Roosvelt: SRP above Roosevelt Lake
  • Salt Gila: Salt-Gila Pump Station
  • Scotts: AZ Canal at Scottsdale Rd.
  • SGPS: Salt Gila Pump Station
  • SOCA: South Canal below CAP Cross-connect
  • SPT In: Tempe South WTP Inlet
  • SPT IN: Tempe South WTP Inlet
  • SPT Out: Tempe South WP Treated
  • SPT OUT: Tempe South WP Treated
  • SRNR: Salt River Inlet Near Roosevelt Lake
  • UH In: Union Hills WTP Inlet
  • UH IN: Union Hills WTP Inlet
  • UH Out: Union Hills WTP Treated
  • UH OUT: Union Hills WTP Treated
  • VV West: Val Vista West WTP treated water
site location site location description
string
cluster source water
string
Enumeration:
  • az canal: Arizona canal
  • cap: Central Arizona Project canal
  • chandler: metadata_not_provided
  • mesa turnout: metadata_not_provided
  • salt: Salt River
  • srp: Salt River Project canal
  • tempe: Tempe, AZ area canal
  • verde: Verde River
site acronym site number or name
string
Enumeration:
  • 24th In: AZ Canal - Inlet to 24th St Water Treatment Plant
  • 24th Out: 24th St Water Treatment Plant treated water
  • 24th St -treated: 24th St. Water Treatment Plant treated water
  • Above Roosevelt: SRP above Roosevelt Lake
  • anthem: Anthem Water Treatment Plant
  • anthem inlet: Anthem WTP Inlet
  • anthem treated: Anthem WTP Treated
  • az canal @ 16th st.: AZ Canal at 16th Street
  • az canal @ 19 ave.: AZ Canal at 19th Avenue
  • az canal @ 19th av.: AZ Canal at 19th Avenue
  • az canal @ 24th St: AZ Canal at 24th Street
  • az canal @ 56th st.: AZ Canal at 56th Street
  • az canal @ central ave.: AZ Canal at Central Avenue
  • az canal @ deer valley: AZ Canal - Inlet to Deer Valley WTP
  • az canal @ hwy 87: AZ Canal at Highway 87
  • az canal @ Mesa: AZ Canal at Mesa Dr.
  • az canal @ pima: AZ Canal at Pima Rd
  • az canal @ scotts.: AZ Canal at Scottsdale Rd.
  • az canal @ squaw peak: AZ Canal - Inlet to Squaw Peak WTP
  • az canal blw cap: AZ Canal below CAP Cross-connect
  • az canal inflow: AZ Canal above CAP Cross-connect
  • bartlett-dock: Bartlett Lake dock sample
  • bartlett-epi: Bartlett Reservoir near outlet
  • bartlett-hypo: Bartlett Reservoir near outlet
  • cap-siphon: metadata_not_provided
  • cap @ 7th st: Cap Canal at 7th St.
  • cap @ 7th st dup: Cap Canal at 7th St. Duplicate Sample
  • cap @ x con: CAP Canal at Cross-connect
  • chandler: Chandler WTP
  • chandler inlet: Chandler WTP Inlet
  • chandler treated: Chandler WTP Treated
  • deer valley-treated: Deer Valley WTP treated water
  • field: Field Blank
  • Glen In: Glendale WTP Inlet
  • Glen Out: Glendale WTP Treated
  • Green In: Greenway WTP Inlet
  • Green Out: Greenway WTP Treated
  • Havasu: Lake Havasu
  • Havasu 1: Lake Havasu Site 1
  • Havasu 2: Lake Havasu Site 2
  • head of tempe canal: Head of Tempe Canal
  • head of the consolidated canal: Head of the Consolidated canal
  • lab: Laboratory blank
  • Mesa Turnout: Mesa Canal Turnout
  • middle of the consolidated canal: Middle of the Consolidated canal
  • North plant inlet: Tempe North WTP Inlet
  • north plant outlet: Tempe North WTP Treated
  • pleasant-epi: Lake Pleasant integrated sample
  • pleasant-hypo: Lake Pleasant integrated sample
  • Roos In: Salt River Inlet Near Roosevelt Lake
  • s canal @ val vista: South Canal at Val Vista WTP
  • saguaro-epi: Saguaro Lake Epilimnion
  • saguaro-epi dup: Saguaro Lake Epilimnion Duplicate Sample
  • saguaro-hypo: Saguaro Lake Hypolimnion
  • salt abv saguaro: Salt River inlet to Saguaro Lake
  • salt blw saguaro: Salt River below Saguaro (Blue Point Bridge)
  • Salt Gila: Salt-Gila Pump Station
  • saugaro-dock: Saguaro Lake dock sample
  • South canal below CAP: South Canal below CAP Cross-connect
  • squaw peak-treated: Squaw Peak WTP treated water
  • SRNR: Salt River Inlet Near Roosevelt Lake
  • STP In: Tempe Canal - Inlet to Tempe's South Plant
  • STP Out: Tempe's South Plant treated water
  • Union Hills Inlet: Union Hills WTP Inlet
  • Union Hills Outlet: Union Hills WTP Treated
  • val vista-treated: Val Vista WTP treated water
  • val vista west-treated: Val Vista WTP treated water - west
  • verde @ beeline: verde river at beeline highway
  • verde abv bartlett: Verde River btwn Horseshoe and Bartlett
  • verde abv horseshoe: Verde River at Tangle
  • verde blw barlett: Verde River below Bartlett Reservoir
  • waddell canal: Waddell Canal
date sample collection date
date Format: YYYY-MM-DD
sample type type of water sample collected (if not a field sample)
string
Enumeration:
  • -: metadata_not_provided
  • extra sample: Extra sample collected
  • field blank: Field blank
  • field duplicate: Field duplicate sample
  • lab blank: Laboratory blank
  • no water: Dry, no water
  • not available: Not available
  • offline: Water treatment plant offline
  • Rain event: Rain event
TOC (mg/L) total organic carbon
float milligramsPerLiter
DOC (mg/L) dissolved organic carbon
float milligramsPerLiter
UVA (cm-1) UV absorbance measured at 254 nanometers
float perCentimeter
suva (L/mg-m) specific ultraviolet absorbance
float literPerMilligramMeter
peak int intensity of peak
float dimensionless
peak int WL wavelength at the highest peak intensity
float nanometer
int at 450 intensity at 450 nanometers
float dimensionless
int at 460 intensity at 460 nanometers
float dimensionless
int at 500 intensity at 500 nanometers
float dimensionless
FI (450/500) fluorescence ratio of 450/500
float dimensionless
docm comments comment(s) about site conditions or sampling details
string

Tabular: 617_field_measurements_61820cda981b4135b9b2efdc641bacc2.csv

Description: water quality parameters as measured in the field in canals and reservoirs

Column Description Type Units
site number site number or name (A designates epilimnion, B hypolimnion)
string
Enumeration:
  • 16th St.: AZ Canal at 16th Street
  • 19th Av.: AZ Canal at 19th Avenue
  • Apa-0: Apache Lake at surface
  • Apa-10: Apache Lake at 10m depth
  • Apa-15: Apache Lake at 15m depth
  • Apa-20: Apache Lake at 20m depth
  • Apa-25: Apache Lake at 25m depth
  • Apa-30: Apache Lake at 30m depth
  • Apa-35: Apache Lake at 35m depth
  • Apa-40: Apache Lake at 40m depth
  • Apa-45: Apache Lake at 45m depth
  • Apa-5: Apache Lake at 5m depth
  • Apa-50: Apache Lake at 50m depth
  • Apa-55: Apache Lake at 55m depth
  • Can-0: Canyon Lake at surface
  • Can-10: Canyon Lake at 10m depth
  • Can-15: Canyon Lake at 15m depth
  • Can-20: Canyon Lake at 20m depth
  • Can-25: Canyon Lake at 25m depth
  • Can-30: Canyon Lake at 30m depth
  • Can-35: Canyon Lake at 35m depth
  • Can-40: Canyon Lake at 40m depth
  • Can-45: Canyon Lake at 45m depth
  • Can-5: Canyon Lake at 5m depth
  • Can-50: Canyon Lake at 50m depth
  • Cons: Consolidated Canal
  • Glen In: Glendale WTP Inlet
  • Glen Out: Glendale WTP Treated
  • Green In: Greenway WTP Inlet
  • Green Out: Greenway WTP Treated
  • Havasu 1: Lake Havasu Site 1
  • Havasu 2: Lake Havasu Site 2
  • HTC: Head of Tempe Canal
  • Hwy 87: AZ Canal at Highway 87
  • Mesa: AZ Canal at Mesa Dr.
  • NP In: Tempe North WTP Inlet
  • NP Out: Tempe North WTP Treated
  • Pima: AZ Canal at Pima Rd
  • R1: CAP canal above Waddell Canal
  • R10: Salt River below Saguaro (Blue Point Bridge)
  • R11: CAP Canal at Cross-connect
  • R12: AZ Canal above CAP Cross-connect
  • R13: AZ Canal below CAP Cross-connect
  • R14: AZ Canal - Inlet to Squaw Peak WTP
  • R15: Squaw Peak WTP treated water
  • R16: AZ Canal - Inlet to Deer Valley WTP
  • R17: Deer Valley WTP treated water
  • R18: South Canal at Val Vista WTP
  • R19: Val Vista WTP treated water
  • R2: Lake Pleasant at surface
  • R2-10: Lake Pleasant at 10m depth
  • R2-15: Lake Pleasant at 15m depth
  • R2-20: Lake Pleasant at 20m depth
  • R2-25: Lake Pleasant at 25m depth
  • R2-30: Lake Pleasant at 30m depth
  • R2-35: Lake Pleasant at 35m depth
  • R2-40: Lake Pleasant at 40m depth
  • R2-45: Lake Pleasant at 45m depth
  • R2-5: Lake Pleasant at 5m depth
  • R2-50: Lake Pleasant at 50m depth
  • R2-55: Lake Pleasant at 55m depth
  • R20: Verde River at Tangle
  • R21: AZ Canal - Central Avenue
  • R22: AZ Canal at 56th
  • R25: Verde River at Beeline
  • R26: Arizona Canal at 19th Ave.
  • R2A: Lake Pleasant integrated sample
  • R3: Waddell Canal
  • R4: Cap Canal at 7th St.
  • R4-Dup: Cap Canal at 7th St. duplicate sample
  • R5: Verde River btwn Horseshoe and Bartlett
  • R6-10: Bartlett Lake at 10m depth
  • R6-15: Bartlett Lake at 15m depth
  • R6-20: Bartlett Lake at 20m depth
  • R6-25: Bartlett Lake at 25m depth
  • R6-30: Bartlett Lake at 30m depth
  • R6-35: Bartlett Lake at 35m depth
  • R6-40: Bartlett Lake at 40m depth
  • R6-45: Bartlett Lake at 45m depth
  • R6-5: Bartlett Lake at 5m depth
  • R6-50: Bartlett Lake at 50m depth
  • R6-55: Bartlett Lake at 55m depth
  • R6A: Bartlett Reservoir near outlet
  • R7: Verde River below Bartlett Reservoir
  • R8: Salt River inlet to Saguaro Lake
  • R9-10: Saguaro Lake at 10m depth
  • R9-15: Saguaro Lake at 15m depth
  • R9-20: Saguaro Lake at 20m depth
  • R9-25: Saguaro Lake at 25m depth
  • R9-30: Saguaro Lake at 30m depth
  • R9-35: Saguaro Lake at 35m depth
  • R9-40: Saguaro Lake at 40m depth
  • R9-45: Saguaro Lake at 45m depth
  • R9-5: Saguaro Lake at 5m depth
  • R9-50: Saguaro Lake at 50m depth
  • R9-55: Saguaro Lake at 55m depth
  • R9A: Saguaro Lake near inlet
  • Roos-0: Roosevelt Lake at surface
  • Roos-10: Roosevelt Lake at 10m depth
  • Roos-15: Roosevelt Lake at 15m depth
  • Roos-20: Roosevelt Lake at 20m depth
  • Roos-25: Roosevelt Lake at 25m depth
  • Roos-30: Roosevelt Lake at 30m depth
  • Roos-35: Roosevelt Lake at 35m depth
  • Roos-40: Roosevelt Lake at 40m depth
  • Roos-45: Roosevelt Lake at 45m depth
  • Roos-5: Roosevelt Lake at 5m depth
  • Roos-50: Roosevelt Lake at 50m depth
  • Roosvelt: SRP above Roosevelt Lake
  • Scotts: AZ Canal at Scottsdale Rd.
  • SOCA: South Canal below CAP Cross-connect
  • SPT In: Tempe South WTP Inlet
  • SPT Out: Tempe South WP Treated
  • UH In: Union Hills WTP Inlet
  • UH Out: Union Hills WTP Treated
site location site location description
string
cluster source water
string
Enumeration:
  • cap: Central Arizona Project canal
  • salt: Salt River
  • srp: Salt River Project canal
  • tempe: Tempe, AZ area canal
  • verde: Verde River
site acronym site number or name
string
Enumeration:
  • Above Roosevelt: metadata_not_provided
  • Apa-0m: Apache Lake at surface
  • Apa-10m: Apache Lake at 10m depth
  • Apa-15m: Apache Lake at 15m depth
  • Apa-20m: Apache Lake at 20m depth
  • Apa-25m: Apache Lake at 25m depth
  • Apa-30m: Apache Lake at 30m depth
  • Apa-35m: Apache Lake at 35m depth
  • Apa-40m: Apache Lake at 40m depth
  • Apa-45m: Apache Lake at 45m depth
  • Apa-50m: Apache Lake at 50m depth
  • Apa-55m: Apache Lake at 55m depth
  • Apa-5m: Apache Lake at 5m depth
  • Apache-0m: Apache Lake at surface
  • Apache-10m: Apache Lake at 10m depth
  • Apache-15m: Apache Lake at 15m depth
  • Apache-20m: Apache Lake at 20m depth
  • Apache-25m: Apache Lake at 25m depth
  • Apache-30m: Apache Lake at 30m depth
  • Apache-35m: Apache Lake at 35m depth
  • Apache-40m: Apache Lake at 40m depth
  • Apache-45m: Apache Lake at 45m depth
  • Apache-50m: Apache Lake at 50m depth
  • Apache-5m: Apache Lake at 5m depth
  • az canal @ 16th st.: AZ Canal at 16th Street
  • az canal @ 19 ave.: AZ Canal at 19th Avenue
  • az canal @ 19th av.: AZ Canal at 19th Avenue
  • az canal @ 56th st.: AZ Canal at 56th Street
  • az canal @ central ave.: AZ Canal at Central Avenue
  • az canal @ deer valley: AZ Canal - Inlet to Deer Valley WTP
  • az canal @ hwy 87: AZ Canal at Highway 87
  • az canal @ Mesa: AZ Canal at Mesa Dr.
  • az canal @ pima: AZ Canal at Pima Rd
  • az canal @ scotts.: AZ Canal at Scottsdale Rd.
  • az canal @ squaw peak: AZ Canal - Inlet to Squaw Peak WTP
  • az canal blw cap: AZ Canal below CAP Cross-connect
  • az canal inflow: AZ Canal above CAP Cross-connect
  • bartlett-0m: Bartlett Lake at surface
  • bartlett-10m: Bartlett Lake at 10m depth
  • bartlett-15m: Bartlett Lake at 15m depth
  • bartlett-20m: Bartlett Lake at 20m depth
  • bartlett-25m: Bartlett Lake at 25m depth
  • bartlett-30m: Bartlett Lake at 30m depth
  • bartlett-35m: Bartlett Lake at 35m depth
  • bartlett-40m: Bartlett Lake at 40m depth
  • bartlett-45m: Bartlett Lake at 45m depth
  • bartlett-50m: Bartlett Lake at 50m depth
  • bartlett-55m: Bartlett Lake at 55m depth
  • bartlett-5m: Bartlett Lake at 5m depth
  • Can-0m: Canyon Lake at surface
  • Can-10m: Canyon Lake at 10m depth
  • Can-15m: Canyon Lake at 15m depth
  • Can-20m: Canyon Lake at 20m depth
  • Can-25m: Canyon Lake at 25m depth
  • Can-30m: Canyon Lake at 30m depth
  • Can-35m: Canyon Lake at 35m depth
  • Can-40m: Canyon Lake at 40m depth
  • Can-45m: Canyon Lake at 45m depth
  • Can-50m: Canyon Lake at 50m depth
  • Can-5m: Canyon Lake at 5m depth
  • Canyon-0m: Canyon Lake at surface
  • Canyon-10m: Canyon Lake at 10m depth
  • Canyon-15m: Canyon Lake at 15m depth
  • Canyon-20m: Canyon Lake at 20m depth
  • Canyon-25m: Canyon Lake at 25m depth
  • Canyon-30m: Canyon Lake at 30m depth
  • Canyon-35m: Canyon Lake at 35m depth
  • Canyon-40m: Canyon Lake at 40m depth
  • Canyon-45m: Canyon Lake at 45m depth
  • Canyon-50m: Canyon Lake at 50m depth
  • Canyon-5m: Canyon Lake at 5m depth
  • cap-siphon: metadata_not_provided
  • cap @ 7th st: Cap Canal at 7th St.
  • cap @ 7th st dup: Cap Canal at 7th St. duplicate sample
  • cap @ x con: CAP Canal at Cross-connect
  • deer valley-treated: Deer Valley WTP treated water
  • Glen In: Glendale WTP Inlet
  • Glen Out: Glendale WTP Treated
  • Green In: Greenway WTP Inlet
  • Green Out: Greenway WTP Treated
  • Havasu 1: Lake Havasu Site 1
  • Havasu 2: Lake Havasu Site 2
  • head of tempe canal: Head of Tempe Canal
  • North plant inlet: Tempe North WTP Inlet
  • north plant outlet: Tempe North WTP Treated
  • pleasant: Lake Pleasant
  • pleasant-0m: Lake Pleasant at surface
  • pleasant-10m: Lake Pleasant at 10m depth
  • pleasant-15m: Lake Pleasant at 15m depth
  • pleasant-20m: Lake Pleasant at 20m depth
  • pleasant-25m: Lake Pleasant at 25m depth
  • pleasant-30m: Lake Pleasant at 30m depth
  • pleasant-35m: Lake Pleasant at 35m depth
  • pleasant-40m: Lake Pleasant at 40m depth
  • pleasant-45m: Lake Pleasant at 45m depth
  • pleasant-50m: Lake Pleasant at 50m depth
  • pleasant-55m: Lake Pleasant at 55m depth
  • pleasant-5m: Lake Pleasant at 5m depth
  • Roos-0m: Roosevelt Lake at surface
  • Roos-10m: Roosevelt Lake at 10m depth
  • Roos-15m: Roosevelt Lake at 15m depth
  • Roos-20m: Roosevelt Lake at 20m depth
  • Roos-25m: Roosevelt Lake at 25m depth
  • Roos-30m: Roosevelt Lake at 30m depth
  • Roos-35m: Roosevelt Lake at 35m depth
  • Roos-40m: Roosevelt Lake at 40m depth
  • Roos-45m: Roosevelt Lake at 45m depth
  • Roos-50m: Roosevelt Lake at 50m depth
  • Roos-5m: Roosevelt Lake at 5m depth
  • Roosevelt-0m: Roosevelt Lake at surface
  • Roosevelt-10m: Roosevelt Lake at 10m depth
  • Roosevelt-15m: Roosevelt Lake at 15m depth
  • Roosevelt-20m: Roosevelt Lake at 20m depth
  • Roosevelt-25m: Roosevelt Lake at 25m depth
  • Roosevelt-30m: Roosevelt Lake at 30m depth
  • Roosevelt-35m: Roosevelt Lake at 35m depth
  • Roosevelt-40m: Roosevelt Lake at 40m depth
  • Roosevelt-45m: Roosevelt Lake at 45m depth
  • Roosevelt-50m: Roosevelt Lake at 50m depth
  • Roosevelt-5m: Roosevelt Lake at 5m depth
  • s canal @ val vista: South Canal at Val Vista WTP
  • saguaro-0m: Saguaro Lake at surface
  • saguaro-10m: Saguaro Lake at 10m depth
  • saguaro-15m: Saguaro Lake at 15m depth
  • saguaro-20m: Saguaro Lake at 20m depth
  • saguaro-25m: Saguaro Lake at 25m depth
  • saguaro-30m: Saguaro Lake at 30m depth
  • saguaro-35m: Saguaro Lake at 35m depth
  • saguaro-40m: Saguaro Lake at 40m depth
  • saguaro-45m: Saguaro Lake at 45m depth
  • saguaro-50m: Saguaro Lake at 50m depth
  • saguaro-55m: Saguaro Lake at 55m depth
  • saguaro-5m: Saguaro Lake at 5m depth
  • salt abv saguaro: Salt River inlet to Saguaro Lake
  • salt blw saguaro: Salt River below Saguaro (Blue Point Bridge)
  • South canal below CAP: South Canal below CAP Cross-connect
  • squaw peak-treated: Squaw Peak WTP treated water
  • STP In: Tempe Canal - Inlet to Tempe's South Plant
  • STP Out: Tempe's South Plant treated water
  • Union Hills Inlet: Union Hills WTP Inlet
  • Union Hills Outlet: Union Hills WTP Treated
  • val vista-treated: Val Vista WTP treated water
  • verde @ beeline: verde river at beeline highway
  • verde abv bartlett: Verde River btwn Horseshoe and Bartlett
  • verde abv horseshoe: Verde River at Tangle
  • verde blw barlett: Verde River below Bartlett Reservoir
  • waddell canal: Waddell Canal
date sample collection date
date Format: YYYY-MM-DD
depth (m) water depth where measurement was taken (0 designates just below surface)
float meter
T (C) water temperature
float celsius
DO (mg/l) dissolved oxygen
float milligramsPerLiter
pH pH
float dimensionless
Secchi disk (m) water transparency measurement as measured from side of boat
float meter
samples collected types of analyses for which samples were collected
string
comments comment(s) about site conditions or sampling details
string

Tabular: 617_microbial_7a331250b6c16318285bb1d355dffc95.csv

Description: E. coli, Coliform, and Mycobacterium colony counts in canals and reservoirs

Column Description Type Units
site number site number or name (A designates epilimnion, B hypolimnion)
string
Enumeration:
  • HOC: Head of the Consolidated canal
  • HTC: Head of the Tempe Canal
  • Hwy 87: AZ Canal at Highway 87
  • MOC: Middle of the Consolidated canal
  • Pima: AZ Canal at Pima Rd
  • R11: CAP Canal at Cross-connect
  • R12: AZ Canal above CAP Cross-connect
  • R13: AZ Canal below CAP Cross-connect
  • R21: AZ Canal - Central Avenue
  • R22: AZ Canal at 56th
  • R25: Verde River at Beeline
  • R3: Waddell Canal
  • SOCA: South Canal below CAP Cross-connect
site location site location description
string
cluster source water
string
Enumeration:
  • cap: Central Arizona Project canal
  • srp: Salt River Project canal
  • tempe: Tempe, AZ area canal
  • verde: Verde River
site acronym site number or name (A designates epilimnion, B hypolimnion)
string
Enumeration:
  • az canal @ 56th st.: AZ Canal at 56th Street
  • az canal @ central ave.: AZ Canal at Central Avenue
  • az canal @ hwy 87: AZ Canal at Highway 87
  • az canal @ pima: AZ Canal at Pima Rd
  • az canal blw cap: AZ Canal below CAP Cross-connect
  • az canal inflow: AZ Canal above CAP Cross-connect
  • cap @ x con: CAP Canal at Cross-connect
  • head of tempe canal: Head of Tempe Canal
  • Head of the Consolidated Canal: Head of the Consolidated canal
  • Middle of the Consolidated Canal: Middle of the Consolidated canal
  • South canal below CAP: South Canal below CAP Cross-connect
  • verde @ beeline: verde river at beeline highway
  • waddell canal: Waddell Canal
date sample collection date
date Format: YYYY-MM-DD
e_coli number of E coli colonies per 100mL of sample
float coloniesPer100milliliter
coliform number of Coliform colonies per 100mL of sample
float coloniesPer100milliliter
mycobacterium number of Mycobacterium colonies per 100mL of sample
float coloniesPer100milliliter
mycobacterium_flag sampling, analysis, or processing flag for Mycobacterium sample
string
Enumeration:
  • CONT: Not Countable Due to Contamination
  • NCDC: Not Countable Due to Contamination
  • ND: absent/too few to count
  • TFTC: Too Few to Count
  • TNTC: Too Numerous to Count
Comments comment(s) about site conditions or sampling details
string

Tabular: 617_nutrients_a32dafb7546f4adc6404c987eff0ddcc.csv

Description: concentration of algal by-products in canals and reservoirs

Column Description Type Units
site number site number or name (A designates epilimnion, B hypolimnion)
string
Enumeration:
  • 16th St.: AZ Canal at 16th Street
  • 19th Av.: AZ Canal at 19th Avenue
  • An in: Anthem WTP Inlet
  • AN IN: Anthem WTP Inlet
  • An out: Anthem WTP Treated
  • AN OUT: Anthem WTP Treated
  • Anthem in: Anthem WTP Inlet
  • Anthem out: Anthem WTP Treated
  • Ch in: Chandler WTP Inlet
  • CH IN: Chandler WTP Inlet
  • Ch out: Chandler WTP Treated
  • CH OUT: Chandler WTP Treated
  • Chandler in: Chandler WTP Inlet
  • Chandler out: Chandler WTP Treated
  • DV-WR: Deer Valley WTP wash return
  • field_blank: Field blank
  • Gila Salt: Salt-Gila Pump Station
  • GL IN: Glendale WTP Inlet
  • GL OUT: Glendale WTP Treated
  • Glen In: Glendale WTP Inlet
  • Glen Out: Glendale WTP Treated
  • Glendale In: Glendale WTP Inlet
  • Glendale Out: Glendale WTP Treated
  • GR IN: Greenway WTP Inlet
  • GR OUT: Greenway WTP Treated
  • Green In: Greenway WTP Inlet
  • Green Out: Greenway WTP Treated
  • HAV: Lake Havasu
  • Havasu 1: Lake Havasu Site 1
  • Havasu 2: Lake Havasu Site 2
  • HOC: Head of the Consolidated canal
  • HTC: Head of the Tempe Canal
  • Hwy 87: AZ Canal at Highway 87
  • HWY 87: AZ Canal at Highway 87
  • lab_blank: Laboratory blank
  • Mesa: AZ Canal at Mesa Dr.
  • Mesa Turnout: Mesa Canal Turnout
  • MOC: Middle of the Consolidated canal
  • MTO: Mesa Canal Turnout
  • NP In: Tempe North WTP Inlet
  • NP IN: Tempe North WTP Inlet
  • NP Out: Tempe North WTP Treated
  • NP OUT: Tempe North WTP Treated
  • Pima: AZ Canal at Pima Rd
  • PIMA: AZ Canal at Pima Rd
  • R1: CAP canal above Waddell Canal
  • R10: Salt River below Saguaro (Blue Point Bridge)
  • R10rain: Salt River below Saguaro (Blue Point Bridge) rain sample
  • R11: CAP Canal at Cross-connect
  • R11rain: CAP Canal at Cross-connect rain sample
  • R12: AZ Canal above CAP Cross-connect
  • R13: AZ Canal below CAP Cross-connect
  • R14: AZ Canal - Inlet to Squaw Peak WTP
  • R15: Squaw Peak WTP treated water
  • R16: AZ Canal - Inlet to Deer Valley WTP
  • R17: Deer Valley WTP treated water
  • R18: South Canal at Val Vista WTP
  • R19: Val Vista WTP treated water
  • R20: Verde River at Tangle
  • R21: AZ Canal - Central Avenue
  • R21br: AZ Canal - Central Ave (N. of Northern) brush exp
  • R22: AZ Canal at 56th
  • R25: Verde River at Beeline
  • R25rain: Verde River at Beeline rain sample
  • R26: AZ Canal at 19th Avenue
  • R26br: AZ Canal - 19th avenue brush exp
  • R27br: AZ Canal - 29th Avenue brush exp
  • R2A: Lake Pleasant integrated sample
  • R2B: Lake Pleasant integrated sample
  • R3: Waddell Canal
  • R4: Cap Canal at 7th St.
  • R4-Dup: Cap Canal at 7th St. duplicate sample
  • R5: Verde River btwn Horseshoe and Bartlett
  • R5dup: Verde River btwn Horseshoe and Bartlett duplicate sample
  • R6A: Bartlett Reservoir near outlet
  • R6B: Bartlett Reservoir near outlet
  • R6C: Bartlett Lake near dock
  • R7: Verde River below Bartlett Reservoir
  • R8: Salt River inlet to Saguaro Lake
  • R9A: Saguaro Lake near inlet
  • R9A-Dup: Saguaro Lake near inlet duplicate sample
  • R9A-DUP: Saguaro Lake near inlet duplicate sample
  • R9B: Saguaro Lake near inlet
  • R9Bturbid: Saguaro Lake hypolimnion turbidity sample
  • R9C: Saguaro Lake near dock
  • Roos In: Salt River Inlet Near Roosevelt Lake
  • Roosvelt: SRP above Roosevelt Lake
  • Salt Gila: Salt-Gila Pump Station
  • Scotts: AZ Canal at Scottsdale Rd.
  • SGPS: Salt-Gila Pump Station
  • SOCA: South Canal below CAP Cross-connect
  • SP-WR: Squaw Peak WTP wash return extra sample
  • SPT In: Tempe South WTP Inlet
  • SPT IN: Tempe South WTP Inlet
  • SPT Out: Tempe South WP Treated
  • SPT OUT: Tempe South WP Treated
  • SRNR: Salt River Inlet Near Roosevelt Lake
  • UH In: Union Hills WTP Inlet
  • UH IN: Union Hills WTP Inlet
  • UH Out: Union Hills WTP Treated
  • UH OUT: Union Hills WTP Treated
  • VV West: Val Vista West Water Treatment Plant treated water
site location site location description
string
cluster source water
string
Enumeration:
  • az canal: Arizona canal
  • cap: Central Arizona Project canal
  • salt: Salt River
  • srp: Salt River Project canal
  • tempe: Tempe, AZ area canal
  • verde: Verde River
site acronym site number or name
string
Enumeration:
  • 24th In: AZ Canal - Inlet to 24th St Water Treatment Plant
  • 24th Out: 24th St Water Treatment Plant treated water
  • Above Roosevelt: SRP above Roosevelt Lake
  • anthem: Anthem Water Treatment Plant
  • Anthem: Anthem Water Treatment Plant
  • az canal: AZ Canal
  • az canal @ 16th st.: AZ Canal at 16th Street
  • az canal @ 19 ave.: AZ Canal at 19th Avenue
  • az canal @ 19th av.: AZ Canal at 19th Avenue
  • az canal @ 29 ave.: AZ Canal at 29th Avenue
  • az canal @ 56th st.: AZ Canal at 56th Street
  • az canal @ central ave.: AZ Canal at Central Avenue
  • az canal @ deer valley: AZ Canal - Inlet to Deer Valley WTP
  • az canal @ hwy 87: AZ Canal at Highway 87
  • az canal @ Mesa: AZ Canal at Mesa Dr.
  • az canal @ pima: AZ Canal at Pima Rd
  • az canal @ scotts.: AZ Canal at Scottsdale Rd.
  • az canal @ squaw peak: AZ Canal - Inlet to Squaw Peak WTP
  • az canal blw cap: AZ Canal below CAP Cross-connect
  • az canal inflow: AZ Canal above CAP Cross-connect
  • bartlett-dock: Bartlett Lake dock sample
  • bartlett-epi: Bartlett Reservoir near outlet
  • bartlett-hypo: Bartlett Reservoir near outlet
  • cap-siphon: metadata_not_provided
  • cap @ 7th st: Cap Canal at 7th St.
  • cap @ 7th st dup: Cap Canal at 7th St. duplicate sample
  • cap @ x con: CAP Canal at Cross-connect
  • chandler: Chandler Water Treatment Plant
  • Chandler: Chandler Water Treatment Plant
  • deer valley-treated: Deer Valley WTP treated water
  • field: Field Blank
  • field blank: Field Blank
  • Glen In: Glendale WTP Inlet
  • Glen Out: Glendale WTP Treated
  • Glendale WTP Inlet: Glendale WTP Inlet
  • Glendale WTP Outlet: Glendale WTP Treated
  • Green In: Greenway WTP Inlet
  • Green Out: Greenway WTP Treated
  • Greenway WTP Inlet: Greenway WTP Inlet
  • Greenway WTP Outlet: Greenway WTP Treated
  • Havasu: Lake Havasu
  • Havasu 1: Lake Havasu Site 1
  • Havasu 2: Lake Havasu Site 2
  • head of tempe canal: Head of Tempe Canal
  • lab: Laboratory blank
  • Mesa Turnout: Mesa Canal Turnout
  • North plant inlet: Tempe North WTP Inlet
  • north plant outlet: Tempe North WTP Treated
  • pleasant-epi: Lake Pleasant integrated sample
  • pleasant-hypo: Lake Pleasant integrated sample
  • Roos In: Salt River Inlet Near Roosevelt Lake
  • s canal @ val vista: South Canal at Val Vista Water Treatment Plant
  • saguaro-dock: Saguaro Lake dock sample
  • saguaro-epi: Saguaro Lake Epilimnion
  • saguaro-epi dup: Saguaro Lake Epilimnion duplicate sample
  • saguaro-hypo: Saguaro Lake Hypolimnion
  • salt abv saguaro: Salt River inlet to Saguaro Lake
  • salt blw saguaro: Salt River below Saguaro (Blue Point Bridge)
  • Salt Gila: Salt-Gila Pump Station
  • saugaro-dock: Saguaro Lake dock sample
  • South canal below CAP: South Canal below CAP Cross-connect
  • squaw peak-treated: Squaw Peak WTP treated water
  • SRNR: Salt River Inlet Near Roosevelt Lake
  • STP In: Tempe Canal - Inlet to Tempe's South Plant
  • STP Out: Tempe's South Plant treated water
  • Union Hills Inlet: Union Hills WTP Inlet
  • Union Hills Outlet: Union Hills WTP Treated
  • val vista-treated: Val Vista WTP treated water
  • val vista WEST-treated: Val Vista Water Treatment Plant Treated Water - West
  • verde @ beeline: verde river at beeline highway
  • verde abv bartlett: Verde River btwn Horseshoe and Bartlett
  • verde abv horseshoe: Verde River at Tangle
  • verde blw barlett: Verde River below Bartlett Reservoir
  • waddell canal: Waddell Canal
date sample collection date
date Format: YYYY-MM-DD
sample type type of water sample collected (if not a field sample)
string
total_nitrogen total nitrogen (<=0 are below MDL)
float milligramsPerLiter
total_dissolved_nitrogen total dissolved nitrogen (<=0 are below MDL)
float milligramsPerLiter
total_phosphorus total phosphorus (<=0 are below MDL)
float nanogramsPerLiter
total_dissolved_phosphorus total dissolved phosphorus (<=0 are below MDL)
float nanogramsPerLiter
nitrate_nitrogen nitrate-nitrogen
float milligramsPerLiter
ammonium_nitrogen ammonium-nitrogen
float milligramsPerLiter
dissolved_organic_nitrogen dissolved organic nitrogen
float milligramsPerLiter
nutrient comments comment(s) about site conditions or sampling details
string

Tabular: 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

Column Description Type Units
site number site number or name (A designates epilimnion, B hypolimnion)
string
Enumeration:
  • APA1A: Apache Lake Site 1 Epilimnion
  • APA1B: Apache Lake Site 1 Hypolimnion
  • APA2A: Apache Lake Site 2 Epilimnion
  • APA2B: Apache Lake Site 2 Hypolimnion
  • Can1A: Canyon Lake Site 1 Epilimnion
  • Can1B: Canyon Lake Site 1 Hypolimnion
  • Can2A: Canyon Lake Site 2 Epilimnion
  • Can2B: Canyon Lake Site 2 Hypolimnion
  • Roos1A: Roosevelt Lake Site 1 Epilimnion
  • Roos1B: Roosevelt Lake Site 1 Hypolimnion
  • Roos2A: Roosevelt Lake Site 2 Epilimnion
  • Roos2B: Roosevelt Lake Site 2 Hypolimnion
site location site location description
string
cluster source water
string
Enumeration:
  • srp: Salt River Project canal
site acronym site number or name
string
Enumeration:
  • Apache, epi, lower: Apache Lake Site 2 Epilimnion
  • Apache, epi, upper: Apache Lake Site 1 Epilimnion
  • Apache, eppi, lower: Apache Lake Site 2 Epilimnion
  • Apache, eppi, upper: Apache Lake Site 1 Epilimnion
  • Apache, hypo, lower: Apache Lake Site 2 Hypolimnion
  • Apache, hypo, upper: Apache Lake Site 1 Hypolimnion
  • Canyon, epi, lower: Canyon Lake Site 2 Epilimnion
  • Canyon, epi, upper: Canyon Lake Site 1 Epilimnion
  • Canyon, eppi, lower: Canyon Lake Site 2 Epilimnion
  • Canyon, eppi, upper: Canyon Lake Site 1 Epilimnion
  • Canyon, hypo, lower: Canyon Lake Site 2 Hypolimnion
  • Canyon, hypo, upper: Canyon Lake Site 1 Hypolimnion
  • Roosevelt, epi, lower: Roosevelt Lake Site 2 Epilimnion
  • Roosevelt, epi, upper: Roosevelt Lake Site 1 Epilimnion
  • Roosevelt, eppi, lower: Roosevelt Lake Site 2 Epilimnion
  • Roosevelt, eppi, upper: Roosevelt Lake Site 1 Epilimnion
  • Roosevelt, hypo, lower: Roosevelt Lake Site 2 Hypolimnion
  • Roosevelt, hypo, upper: Roosevelt Lake Site 1 Hypolimnion
date sample collection
date Format: YYYY-MM-DD
MIB (ng/L) 2-methylisoborneol
float nanogramsPerLiter
geosmin (ng/L) Geosmin
float nanogramsPerLiter
TP (ug/L) total phosphorus
float microgramsPerLiter
DOC (mg/L) dissolved organic carbon
float milligramsPerLiter
UVA (cm-1) UV absorbance measured at 254 nanometers
float perCentimeter
Suva(L/mg-m) specific ultraviolet absorbance
float literPerMilligramMeter
Conductance (us/cm) specific conductance
float microsiemensPerCentimeter
TDN (mg/L) total dissolved nitrogen
float milligramsPerLiter

Tabular: 617_quarterly_metals_7f32c206f2d47401a024067c57de94b3.csv

Description: concentration of dissolved metals measured in central-Arizona area lakes and canals

Column Description Type Units
site number site number or name (A designates epilimnion, B hypolimnion)
string
Enumeration:
  • APA1A: Apache Lake Site 1 Epilimnion
  • APA1B: Apache Lake Site 1 Hypolimnion
  • APA2A: Apache Lake Site 2 Epilimnion
  • APA2B: Apache Lake Site 2 Hypolimnion
  • Can1A: Canyon Lake Site 1 Epilimnion
  • Can1B: Canyon Lake Site 1 Hypolimnion
  • Can2A: Canyon Lake Site 2 Epilimnion
  • Can2B: Canyon Lake Site 2 Hypolimnion
  • Hav: Lake Havasu
  • R10: Salt River below Saguaro (Blue Point Bridge)
  • R25: Verde River at Beeline
  • R2A: Lake Pleasant integrated sample
  • R3: Waddell Canal
  • Roos1A: Roosevelt Lake Site 1 Epilimnion
  • Roos1B: Roosevelt Lake Site 1 Hypolimnion
  • Roos2A: Roosevelt Lake Site 2 Epilimnion
  • Roos2B: Roosevelt Lake Site 2 Hypolimnion
site location site location description
string
cluster source water
string
Enumeration:
  • cap: Central Arizona Project canal
  • salt: Salt River
  • srp: Salt River Project canal
  • verde: Verde River
site acronym site number or name
string
Enumeration:
  • Apache, eppi, lower: Apache Lake Site 2 Epilimnion
  • Apache, eppi, upper: Apache Lake Site 1 Epilimnion
  • Apache, hypo, lower: Apache Lake Site 2 Hypolimnion
  • Apache, hypo, upper: Apache Lake Site 1 Hypolimnion
  • Canyon, eppi, lower: Canyon Lake Site 2 Epilimnion
  • Canyon, eppi, upper: Canyon Lake Site 1 Epilimnion
  • Canyon, hypo, lower: Canyon Lake Site 2 Hypolimnion
  • Canyon, hypo, upper: Canyon Lake Site 1 Hypolimnion
  • Havasu: Lake Havasu
  • pleasant-epi: Lake Pleasant integrated sample
  • Roosevelt, eppi, lower: Roosevelt Lake Site 2 Epilimnion
  • Roosevelt, eppi, upper: Roosevelt Lake Site 1 Epilimnion
  • Roosevelt, hypo, lower: Roosevelt Lake Site 2 Hypolimnion
  • Roosevelt, hypo, upper: Roosevelt Lake Site 1 Hypolimnion
  • salt blw saguaro: Salt River below Saguaro (Blue Point Bridge)
  • verde @ beeline: verde river at beeline highway
  • waddell canal: Waddell Canal
date sample collection date
date Format: YYYY-MM-DD
7Li Lithium measurement by ICP-MS
float microgramsPerLiter
9Be Beryllium measurement by ICP-MS
float microgramsPerLiter
23Na Sodium measurement by ICP-MS
float microgramsPerLiter
24Mg Magnesium measurement by ICP-MS
float microgramsPerLiter
27Al Aluminum measurement by ICP-MS
float microgramsPerLiter
39K Potassium measurement by ICP-MS
float microgramsPerLiter
44Ca Calcium measurement by ICP-MS
float microgramsPerLiter
51V Vanadium measurement by ICP-MS
float microgramsPerLiter
52Cr Chromium measurement by ICP-MS
float microgramsPerLiter
55Mn Manganese measurement by ICP-MS
float microgramsPerLiter
56Fe Iron measurement by ICP-MS
float microgramsPerLiter
59Co Cobalt measurement by ICP-MS
float microgramsPerLiter
60Ni Nickel measurement by ICP-MS
float microgramsPerLiter
65Cu Copper measurement by ICP-MS
float microgramsPerLiter
66Zn Zinc measurement by ICP-MS
float microgramsPerLiter
75As Arsenic measurement by ICP-MS
float microgramsPerLiter
82Se Selenium measurement by ICP-MS
float microgramsPerLiter
88Sr Strontium measurement by ICP-MS
float microgramsPerLiter
95Mo Molybdenum measurement by ICP-MS
float microgramsPerLiter
107Ag Silver measurement by ICP-MS
float microgramsPerLiter
111Cd Cadmium measurement by ICP-MS
float microgramsPerLiter
121Sb Antimony measurement by ICP-MS
float microgramsPerLiter
138Ba Barium measurement by ICP-MS
float microgramsPerLiter
202Hg Mercury measurement by ICP-MS
float microgramsPerLiter
208Pb Lead measurement by ICP-MS
float microgramsPerLiter
238U Uranium measurement by ICP-MS
float microgramsPerLiter

Tabular: 617_sampling_locations_46042e79c58446e438b4879dac011e84.csv

Description: latitude, longitude, and elevation of select canal, lake, and river water-quality sampling locations

Column Description Type Units
site number site number or name (A designates epilimnion, B hypolimnion)
string
Enumeration:
  • Hav: Lake Havasu
  • HOC: Head of the Consolidated canal
  • HTC: Head of the Tempe Canal
  • MOC: Middle of the Consolidated canal
  • Pima: AZ Canal at Pima Rd
  • R1: CAP canal above Waddell Canal
  • R10: Salt River below Saguaro (Blue Point Bridge)
  • R11: CAP Canal at Cross-connect
  • R12: AZ Canal above CAP Cross-connect
  • R13: AZ Canal below CAP Cross-connect
  • R14: AZ Canal - Inlet to Squaw Peak WTP
  • R15: Squaw Peak WTP treated water
  • R16: AZ Canal - Inlet to Deer Valley WTP
  • R17: Deer Valley WTP treated water
  • R18: South Canal at Val Vista WTP
  • R19: Val Vista WTP treated water
  • R20: Verde River at Tangle
  • R21: AZ Canal - Central Avenue
  • R22: AZ Canal at 56th
  • R25: Verde River at Beeline
  • R2A: Lake Pleasant integrated sample
  • R2B: Lake Pleasant integrated sample
  • R3: Waddell Canal
  • R4: Cap Canal at 7th St.
  • R5: Verde River btwn Horseshoe and Bartlett
  • R6A: Bartlett Reservoir near outlet
  • R6B: Bartlett Reservoir near outlet
  • R7: Verde River below Bartlett Reservoir
  • R8: Salt River inlet to Saguaro Lake
  • R9A: Saguaro Lake near inlet
  • R9B: Saguaro Lake near inlet
  • SOCA: South Canal below CAP Cross-connect
site location site location description
string
cluster source water
string
Enumeration:
  • az canal: Arizona canal
  • cap: Central Arizona Project canal
  • reservoir: metadata_not_provided
  • salt: Salt River
  • srp: Salt River Project canal
  • tempe: Tempe, AZ area canal
  • verde: Verde River
site acronym site number or name
string
Enumeration:
  • az canal- head of the consolidated canal: Head of the Consolidated canal
  • az canal - 56th st: AZ Canal at 56th Street
  • az canal - cent: AZ Canal at Central Avenue
  • az canal - middle of the consolidated canal: Middle of the Consolidated canal
  • az canal - pima: AZ Canal at Pima Rd
  • az canal - verde river @ beeline: verde river at beeline highway
  • az canal @ deer valley: AZ Canal - Inlet to Deer Valley WTP
  • az canal @ squaw peak: AZ Canal - Inlet to Squaw Peak WTP
  • az canal blw cap: AZ Canal below CAP Cross-connect
  • az canal inflow: AZ Canal above CAP Cross-connect
  • bartlett-epi: Bartlett Reservoir near outlet
  • bartlett-hypo: Bartlett Reservoir near outlet
  • cap-siphon: metadata_not_provided
  • cap @ 7th st: Cap Canal at 7th St.
  • cap @ x con: CAP Canal at Cross-connect
  • deer valley-treated: Deer Valley WTP treated water
  • lake havasu: Lake Havasu
  • pleasant-epi: Lake Pleasant integrated sample
  • pleasant-hypo: Lake Pleasant integrated sample
  • s canal @ val vista: South Canal at Val Vista WTP
  • saguaro-epi: Saguaro Lake Epilimnion
  • saguaro-hypo: Saguaro Lake Hypolimnion
  • salt abv saguaro: Salt River inlet to Saguaro Lake
  • salt blw saguaro: Salt River below Saguaro (Blue Point Bridge)
  • south tempe canals - below CAP Cross-connect: South Canal below CAP Cross-connect
  • south tempe canals - head of the tempe canal: Head of the Tempe Canal
  • squaw peak-treated: Squaw Peak WTP treated water
  • val vista-treated: Val Vista WTP treated water
  • verde abv bartlett: Verde River btwn Horseshoe and Bartlett
  • verde abv horseshoe: Verde River at Tangle
  • verde blw barlett: Verde River below Bartlett Reservoir
  • waddell canal: Waddell Canal
date GPS collection date
date Format: YYYY-MM-DD
longitude longitude
float degree
latitude latitude
float degree
altitude (ft) altitude
float meter

Download EML Metadata for this data package