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.
This dataset has the following 60 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Parameter | parameter | text | Name of the parameter reported for the result. Parameters are most often thought of as chemical analytes, but also include things like temperature, fish weight, flow, etc. | Copper - Water - Total Total Suspended Solids - Water - Total Chlorpyrifos - Water - Total Diazinon - Water - Total Malathion - Water - Total view top 100 |
| plot_data | plot_data | text | A true/false flag used in coding R plots | TRUE FALSE view top 100 |
| paramStatus | paramstatus | text | A flag used in coding R analysis; include or omit | Include Omit view top 100 |
| paramClass | paramclass | text | A class of Parameters that are related at a high level, such as inorganic and organic contaminants, or measurements. | Organic Inorganic Measurement view top 100 |
| paramGroup | paramgroup | text | A group of Parameters that are related in some way, such as metals analytes, pesticide compounds, or PCBs. This allows rapid searching for related Parameters. | Metal Pesticide Phthalate Conventional HPAH and cPAH view top 100 |
| Type | type | text | Land use type or precipitation measurement. Land use types are either commercial (COM), industrial (IND), low density residential (LDR), or high density residential (HDR). | COM HDR LDR IND Precip view top 100 |
| nonDetect_Flag | nondetect_flag | text | A true/false flag as to whether the data is non-detect | FALSE TRUE WARNING view top 100 |
| Access_ID | access_id | number | Not Used. | 200119 200295 200345 200354 200325 view top 100 |
| new_Result_Value | new_result_value | number | Final results column following data compilation | 0.1 1 0.5 0.05 0.2 view top 100 |
| new_Result_Units | new_result_units | text | Final units column following data compilation | ug/L ug/Kg % m3 uS/cm view top 100 |
| new_Fraction_Analyzed | new_fraction_analyzed | text | Final fraction column following data compilation | Dissolved dissolved view top 100 |
| Study_ID | study_id | text | UNIQUE ID to identify the Study in EIM. | WAR044502_S8D WAR044003_S8D WAR044503_S8D WAR044501_S8D WAR044001_S8D view top 100 |
| Study_Name | study_name | text | UNIQUE title that describes the study. | Snohomish County Phase I Municipal Stormwater Permit City of Tacoma Phase I Municipal Stormwater Permit City of Seattle Phase I Municipal Stormwater Permit King County Phase I Municipal Stormwater Permit Clark County Phase I Municipal Stormwater Permit view top 100 |
| Location_ID | location_id | text | UNIQUE ID to identify the field location in EIM. | POSOUTFALL_6057 SNO_LDR TFWFD1 SNO_COM SNO_HDR view top 100 |
| Study_Specific_Location_ID | study_specific_location_id | text | Unique ID to identify the field location within a particular Study. | WAR044701_POSOutfall_6057 LDR FD1/OF237B COM HDR view top 100 |
| Location_Name | location_name | text | UNIQUE descriptive name for a field Location. | WAR044701_POSOUTFALL_6057 SNOCO SWC LOW DENSITY RESIDENTIAL FD1 DRAIN 237B SEDIMENT TRAP STATION SNOCO SWC COMMERICAL SNOCO SWC HIGH DENSITY RESIDENTIAL view top 100 |
| Field_Collection_Type | field_collection_type | text | General type of data collection conducted in field. | Sample Measurement view top 100 |
| Field_Collector | field_collector | text | Name or type of organization that collected the data. | Government, Misc Local Consultant, Professional view top 100 |
| Field_Collection_Start_Date | field_collection_start_date | calendar_date | Date that field collection began. | 2011-11-16T00:00:00.000 2011-10-28T00:00:00.000 2011-02-12T00:00:00.000 2011-11-02T00:00:00.000 2011-05-25T00:00:00.000 view top 100 |
| Field_Collection_Start_Time | field_collection_start_time | text | Time that field data collection began, in local time. | 1/0/1900 view top 100 |
| Field_Collection_End_Date | field_collection_end_date | calendar_date | The date that data collection in the field ended. | 2011-10-28T00:00:00.000 2010-11-30T00:00:00.000 2011-11-17T00:00:00.000 2011-02-12T00:00:00.000 2009-09-19T00:00:00.000 view top 100 |
| Field_Collection_End_Time | field_collection_end_time | text | Time that field data collection ended, in local time. | 1/0/1900 view top 100 |
| Field_Collection_Comment | field_collection_comment | text | Comments or descriptive information about the collection of data in the field. | Sample location was in a confined space therefore a pole was used to hold a stainless steel beaker that was used to collect the sample and transfer it to the sample bottle. Associated Storm: WY2010 Storm 12 Associated Storm: WY2011 Storm 7 Associated Storm: WY2012 Storm 3 Associated Storm: WY2010 Storm 11 view top 100 |
| Sample_ID | sample_id | text | Primary ID to identify a sample. May be selected by the sampler or assigned by the lab. | COMM LORES I1 C1 R1 view top 100 |
| WetSeason | wetseason | text | Wet season is October 1 through April 30 | TRUE FALSE view top 100 |
| Season | season | number | Winter=1; spring=2; summer=3; fall=4 | 1 4 2 3 view top 100 |
| Sample_Field_Replicate_ID | sample_field_replicate_id | text | Secondary ID to identify a field replicate sample. Field replicates are separate samples identically collected as close as possible to the same point in space and time as the original sample. They are stored in separate containers, each of which is identically processed and analyzed. Field replicates provide insight into field and laboratory procedure variability (and in some cases contaminant distribution). | FDS view top 100 |
| Sample_Replicate_Flag | sample_replicate_flag | text | Indicates that the sample is a field replicate. Field replicates are separate samples identically collected as close as possible to the same point in space and time as the original sample. They are stored in separate containers, each of which is identically processed and analyzed. Field replicates provide insight into field and laboratory procedure variability (and in some cases contaminant distribution). | U N Y view top 100 |
| Sample_Sub_ID | sample_sub_id | text | Secondary ID to identify a set of field split samples. Mostly used for sediment data. For split samples with the same Sample ID or with different Sample IDs. | view top 100 |
| Sample_Composite_Flag | sample_composite_flag | text | Indicates that the sample is a composite created by combining two or more discrete samples collected spatially and/or temporally. | Y N U view top 100 |
| Storm_Event_Qualifier | storm_event_qualifier | text | Codes such as NQ1, NQ2 | NQ5 NQ2 Q NQ1 NQC view top 100 |
| Sample_Matrix | sample_matrix | text | Describes the environmental medium which was measured or from which a sample was taken. | Water water Solid/Sediment WATER solid/sediment view top 100 |
| Sample_Source | sample_source | text | Describes the environmental resource which was measured or from which a sample was taken. More specific than Sample Matrix. | Stormwater, outfall Stormwater, in-line conveyance or drainage Stormwater Catch Basin Fresh/Surface Water Precipitation view top 100 |
| Sample_Use | sample_use | text | Indicates that the sample was collected for a specific purpose, namely background, reference, or test. Commonly used for sediment data. | view top 100 |
| Sample_Collection_Method | sample_collection_method | text | Code assigned to a procedure or method used to collect a sample. | COMP-CV-CFVI SEDTRAP COMP-CT-VPFVI COMP-CT-CV HANDGRAB view top 100 |
| Sample_Collection_Method_Description | sample_collection_method_description | text | Description of a procedure or method used to collect a sample. | Composite sample, constant volume/constant flow volume increment. Samples of equal volume are taken at equal increments of flow volume and composited. Sediment (suspended particulate matter) trap, type undifferentiated Composite sample, constant time/volume proportional to flow volume increment. Samples are taken at equal increments of time and are composited proportional to the volume of flow since the last sample was taken. Composite sample, constant time/constant volume. Samples of equal volume are taken at equal increments of time and composited to make time-composite an average sample. Hand grab view top 100 |
| Sample_Preparation_Method | sample_preparation_method | text | Code assigned to procedure or method used to prepare a sample. | FILTER.45M view top 100 |
| Sample_Preparation_Method_Description | sample_preparation_method_description | text | Description of procedure or method used to prepare a sample. | Water sample field filtered at time of collection - .45 micron filter (material unspecified) view top 100 |
| Sample_Method_Other | sample_method_other | text | Additional data input field for collection, preparation, or preservation method. | view top 100 |
| Sample_Method_Other_Type | sample_method_other_type | text | Additional data input field for collection, preparation, or preservation method. | view top 100 |
| Sample_Method_Other_Description | sample_method_other_description | text | Additional data input field for collection, preparation, or preservation method. | view top 100 |
| Sample_Percent_Sorted | sample_percent_sorted | text | Percent of sample that is sorted. For benthic macroinvertebrate and periphyton count data. | view top 100 |
| Original_EIM_Parameter_Name | original_eim_parameter_name | text | Name of the parameter reported for the result. Parameters are most often thought of as chemical analytes, but also include things like temperature, fish weight, flow, etc. | Copper Zinc Lead Cadmium Mercury view top 100 |
| Original_EIM_Parameter_CAS | original_eim_parameter_cas | text | A unique number assigned by the Chemical Abstracts Service (CAS) Division of the American Chemical Society to each distinct chemical substance recorded in the Chemical Registry System. | 7440-50-8 7440-66-6 7439-92-1 7440-43-9 7439-97-6 view top 100 |
| Lab_Analysis_Date | lab_analysis_date | calendar_date | The analysis date reported by the lab. | 2011-11-23T00:00:00.000 2011-11-21T00:00:00.000 2011-05-09T00:00:00.000 2011-11-09T00:00:00.000 2011-02-22T00:00:00.000 view top 100 |
| Lab_Analysis_Date_Accuracy | lab_analysis_date_accuracy | text | Indicates if the Lab Analysis Date is accurate to the day, week, month, year or unknown. Except for historical data, most cases are Day. | D M W view top 100 |
| Lab_Analysis_Time | lab_analysis_time | text | The analysis time reported by the lab. | 1/0/1900 view top 100 |
| Result_Data_Qualifier | result_data_qualifier | text | Standard annotations for documenting issues with Result Values, such as non-detects or estimates. | U J UJ C JT view top 100 |
| Original_EIM_Result_Value | original_eim_result_value | number | The Results associated with a particular Study or field Location. Results represent specific information about an environmental Parameter. Results are determined by field measurements, physical observations, or analytical procedures performed on samples. Results are the basis for the analysis of environmental conditions. | 0.1 1 0.05 0.5 0.2 view top 100 |
| Original_EIM_Units | original_eim_units | text | Units of measure associated with a Result Value. | ug/L mg/L ug/Kg % ft3 view top 100 |
| Fraction_Analyzed | fraction_analyzed | text | Indicates the fraction (total, dissolved, or suspended) of an aqueous sample that was analyzed. | Total Dissolved Tot Recoverable DISSOLVED view top 100 |
| Field_Filtered_Flag | field_filtered_flag | text | Indicates if a sample was filtered in the field (not the lab). | N view top 100 |
| Result_Basis | result_basis | text | Physical state in which the analyte concentration was reported - either as the sample was received by the lab (wet weight) or adjusted to remove moisture (dry weight). | WET Dry Wet DRY view top 100 |
| Digestion_Method | digestion_method | text | Indicates the degree of digestion or breakdown performed on a solid sample prior to analysis. | Total view top 100 |
| Result_Method | result_method | text | Code assigned to a procedure or method used to derive a result. Includes lab (analytical), field (measurement), and derivation methods. | SW8270D EPA200.8 SW8270DSIM SW8270CSIM SW8270 view top 100 |
| Result_Method_Description | result_method_description | text | Description of a procedure or method used to derive a result. Includes lab (analytical), field (measurement), and derivation methods. | Semivolatile Organic Compounds by Gas Chromatography/Mass Spectrometry (GC/MS), Revision 4 Metals and Trace Elements in Waters by ICP-MS Semivolatile Organic Compounds by Gas Chromatography/Mass Spectrometry (GC/MS), Selective Ion Monitoring, Revision 4 Semivolatile Organic Compounds by Gas Chromatography/Mass Spectrometry (GC/MS), Selective Ion Monitoring (SIM), Revision 3, modified Semivolatile Organic Compounds by Gas Chromatography/Mass Spectrometry (GC/MS), Selective Ion Monitoring, Revision 4, Modified view top 100 |
| Result_Comment | result_comment | text | Comments about the Result Value | KC Qual: <MDL The analyte was analyzed for, but was not detected at a level above the Method Detection Level (MDL) The analyte was analyzed for, but was not detected at a level above the Method Detection Level NQ1, NQ5 Contamination in field QAQC blanks view top 100 |
| Result_Additional_Comment | result_additional_comment | text | Additional comments about the Result Value | RATING view top 100 |
| Result_Lab_Name | result_lab_name | text | Name of lab that analyzed the sample. | Analytical Resources Inc (ARI), Seattle WA Tacoma Environmental Services Laboratory, Tacoma WA AmTest Laboratories, Kirkland WA King County Environmental Laboratory, Seattle WA Spectra Laboratories, Tacoma WA view top 100 |
| Result_Validation_Level | result_validation_level | text | Third-party or independent expert data validation following the most updated versions of USEPA guidance and national functional guidelines. Pre-August 2013 data follows older guidance. | view top 100 |