Dataset: Surface Water Quality Monitoring Data

About this Dataset

Surface Water Quality Monitoring Data

The Big Sioux River has the following designated beneficial uses established by the State of South Dakota: Domestic Water Supply, Warm water Semi-permanent Fish Life, Warm water Marginal Fish Life, Immersion Recreation, Limited Contact Recreation, Fish and Wildlife Propagation, and Irrigation. The State of South Dakota has established Water Quality Criteria (WQC) to protect this water body for these designated uses. Skunk Creek is a major contributor to the flow and overall character to the water quality of the Big Sioux River in Sioux Falls, however, the Skunk Creek does not have the same designated uses as the Big Sioux River. The Public Works Environmental Division monitors the conditions along the Big Sioux River as well as Skunk Creek in the Sioux Falls area. Monitoring data for Dissolved Oxygen (DO), Escherichia Coli bacteria (E. Coli), and Total Suspended Solids (TSS) is available for public review. The water quality criteria for each of these parameters are outlined on the City's Environmental Division website. To view data on each segment of the river that is monitored, find the parameter of interest and then select either historic data or recent month’s data.
Organization: City of Sioux Falls
Last updated: 2024-04-01T20:48:56.087616
Tags: big-sioux-river, community, environmental, lincoln, minnehaha, monitoring, river, sd, sioux-falls, skunk-creek, south-dakota, surface-water-quality

Tables

Table 1

@usgov.city_of_sioux_falls_surface_water_quality_monitoring_data.table_1

293.08 KB
4120 rows
20 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "sampledate" TIMESTAMP,
  "location" VARCHAR,
  "ph" DOUBLE,
  "temperature" DOUBLE,
  "dissolvedoxygen" DOUBLE,
  "conductivity" DOUBLE,
  "biologicaloxygendemand" DOUBLE,
  "totalsuspendedsolids" DOUBLE,
  "ecoli" DOUBLE,
  "ammonia" DOUBLE,
  "nitrate" DOUBLE,
  "weather" VARCHAR,
  "r_humidity" DOUBLE,
  "windspeed" DOUBLE,
  "windgust" DOUBLE,
  "frozenover" VARCHAR,
  "comments" VARCHAR,
  "locationid" VARCHAR,
  "globalid" VARCHAR
);