About this Dataset

Municipal Stormwater Permit Outfall Data

Special Condition S8.D of the 2007-2012 Phase I Municipal Stormwater Permit required permittees to collect and analyze data to evaluate pollutant loadings of stormwater discharged from different land uses: high density (HD) residential, low density (LD) residential, commercial, and industrial.

To meet the S8.D requirement, Phase I Permittees collected water quality and flow data, sediment data, and toxicity information from stormwater discharges during storm events.
Organization: State of Washington
Last updated: 2020-11-10T17:20:25.380700
Tags: ecology, ms4, outfall, stormwater, water

Tables

Table 1

@usgov.state_of_washington_municipal_stormwater_permit_outfall_data.table_1

1.64 MB
48,062 rows
60 columns

CREATE TABLE table_1 (
  "parameter" VARCHAR,
  "plot_data" BOOLEAN,
  "paramstatus" VARCHAR,
  "paramclass" VARCHAR,
  "paramgroup" VARCHAR,
  "type" VARCHAR,
  "nondetect_flag" VARCHAR,
  "access_id" BIGINT,
  "new_result_value" DOUBLE,
  "new_result_units" VARCHAR,
  "new_fraction_analyzed" VARCHAR,
  "study_id" VARCHAR,
  "study_name" VARCHAR,
  "location_id" VARCHAR,
  "study_specific_location_id" VARCHAR,
  "location_name" VARCHAR,
  "field_collection_type" VARCHAR,
  "field_collector" VARCHAR,
  "field_collection_start_date" VARCHAR,
  "field_collection_start_time" VARCHAR,
  "field_collection_end_date" VARCHAR,
  "field_collection_end_time" VARCHAR,
  "field_collection_comment" VARCHAR,
  "sample_id" VARCHAR,
  "wetseason" BOOLEAN,
  "season" BIGINT,
  "sample_field_replicate_id" VARCHAR,
  "sample_replicate_flag" VARCHAR,
  "sample_sub_id" VARCHAR,
  "sample_composite_flag" VARCHAR,
  "storm_event_qualifier" VARCHAR,
  "sample_matrix" VARCHAR,
  "sample_source" VARCHAR,
  "sample_use" VARCHAR,
  "sample_collection_method" VARCHAR,
  "sample_collection_method_description" VARCHAR,
  "sample_preparation_method" VARCHAR,
  "sample_preparation_method_description" VARCHAR,
  "sample_method_other" VARCHAR,
  "sample_method_other_type" VARCHAR,
  "sample_method_other_description" VARCHAR,
  "sample_percent_sorted" VARCHAR,
  "original_eim_parameter_name" VARCHAR,
  "original_eim_parameter_cas" VARCHAR,
  "lab_analysis_date" VARCHAR,
  "lab_analysis_date_accuracy" VARCHAR,
  "lab_analysis_time" VARCHAR,
  "result_data_qualifier" VARCHAR,
  "original_eim_result_value" DOUBLE,
  "original_eim_units" VARCHAR,
  "fraction_analyzed" VARCHAR,
  "field_filtered_flag" VARCHAR,
  "result_basis" VARCHAR,
  "digestion_method" VARCHAR,
  "result_method" VARCHAR,
  "result_method_description" VARCHAR,
  "result_comment" VARCHAR,
  "result_additional_comment" VARCHAR,
  "result_lab_name" VARCHAR,
  "result_validation_level" VARCHAR
);