Watershed Health data collected by Planning and Public Works Water Quality staff. Data is collected throughout the year and is based on the water year (October 1 -September 30). Water Quality Index scores are displayed. Water Quality Index allows different parameters to be compared regardless of the scales.
This dataset has the following 12 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Stream Name | stream_name | text | School House Creek Ohop Creek Fennel Creek Clover Creek Canyon Falls Creek view top 100 | |
Station Number | station_number | text | NI_TANW_7.45 CC_CLOV_6.87 CL_CLAR_0.70 CL_RODY_0.45 CL_SQUA_0.07 view top 100 | |
Year | wy | calendar_date | Water Year | 2014-12-31T00:00:00.000 2015-12-31T00:00:00.000 2016-12-31T00:00:00.000 2017-12-31T00:00:00.000 2018-12-31T00:00:00.000 view top 100 |
Bacteria | bacteria | number | 71 73 69 75 63 view top 100 | |
Dissolved Oxygen | dissolved_oxygen | number | 89 86 76 88 84 view top 100 | |
Total Phosphorus | total_phosphorus | number | 79 82 88 89 86 view top 100 | |
Temperature | temperature | number | 84 87 88 79 81 view top 100 | |
Station_Lattitude | station_lattitude | number | 46.75175 46.81301 46.87947 46.90453 46.91289 view top 100 | |
Station_Longitude | station_longitude | number | -122.62454 -122.79495 -122.78336 -122.76942 -122.76114 view top 100 | |
Program | program | text | Watershed Health Monitoring Clover Creek TMDL Alternative ERROR: #N/A view top 100 | |
New Georeferenced Column | geocoded_column | point | {"coordinates":[-122.42347999999998,47.12762],"type":"Point"} {"coordinates":[-122.17567000000001,47.08303],"type":"Point"} {"coordinates":[-122.65926,47.31871],"type":"Point"} {"coordinates":[-122.69877,47.389],"type":"Point"} {"coordinates":[-121.94100999999999,46.75175],"type":"Point"} view top 100 | |
WQI Average | wqi_average | number | Average of Temperature, Bacteria, Total Phosphorus, and Dissolved Oxygen. | 82.25 77 77.5 82.5 80.75 view top 100 |