Data Package: Long-term Discrete Water Quality Monitoring At Obed Wild And Scenic River (OBRI), 2013-2023

CREATE TABLE aphn_fielddata (
  "projectid" VARCHAR,
  "stationid" VARCHAR,
  "activitytype" VARCHAR,
  "park" VARCHAR,
  "aphn" VARCHAR,
  "site_loc" VARCHAR,
  "date" VARCHAR,
  "time" VARCHAR,
  "timezone" VARCHAR,
  "datetime" TIMESTAMP,
  "q" VARCHAR,
  "stage" VARCHAR,
  "ph" DOUBLE,
  "temp" DOUBLE,
  "spc" DOUBLE,
  "do" DOUBLE,
  "dosat" DOUBLE,
  "turbidity" DOUBLE
);

CREATE TABLE aphn_labdata (
  "projectid" VARCHAR,
  "stationid" VARCHAR,
  "activitytype" VARCHAR,
  "park" VARCHAR,
  "aphn" VARCHAR,
  "site_loc" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "timezone" VARCHAR,
  "datetime" TIMESTAMP,
  "anc_aphn" VARCHAR,
  "ecoli" DOUBLE,
  "total_coliform" DOUBLE,
  "turbidity_aphn" DOUBLE
);

CREATE TABLE utk_labdata (
  "project_id" VARCHAR,
  "stationid" VARCHAR,
  "activitytype" VARCHAR,
  "custodyid" VARCHAR,
  "activity_start_date" TIMESTAMP,
  "activity_start_time" VARCHAR,
  "start_time_zone" VARCHAR,
  "park" VARCHAR,
  "datetime" TIMESTAMP,
  "lab_ph_titrator" DOUBLE,
  "lab_conductivity_titrator" DOUBLE,
  "mg_l_chloride_ic" DOUBLE,
  "mg_l_nitrate_ic" DOUBLE,
  "mg_l_sulfate_ic" DOUBLE,
  "mg_l_nitrite_ic" DOUBLE,
  "mg_l_phosphate_ic" DOUBLE,
  "lab_nh4_ic" DOUBLE,
  "mg_l_sodium_icp" DOUBLE,
  "mg_l_potassium_icp" DOUBLE,
  "mg_l_magnesium_icp" DOUBLE,
  "mg_l_calcium_icp" DOUBLE,
  "mg_l_aluminum_icp" DOUBLE,
  "mg_l_copper_icp" DOUBLE,
  "mg_l_iron_icp" DOUBLE,
  "mg_l_manganese_icp" DOUBLE,
  "mg_l_silicon_icp" DOUBLE,
  "mg_l_zinc_icp" DOUBLE
);

CREATE TABLE field_sites (
  "stationid" VARCHAR,
  "stationname" VARCHAR,
  "stationtype" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "county" VARCHAR,
  "state" VARCHAR
);