Description

more
Most Municipal Separate Storm Sewer System (MS4) permittees in the State of Washington are a part of the Regional Stormwater Monitoring Program (RSMP). One part of the RSMP is the Source Identification Information Repository. Permittees may choose to enter their permit-required illicit discharge data into this dataset using a form, simplifying both their reporting processes and analyses for the RSMP.https://data.wa.gov/d/ikwr-f47zCreated: 2016-03-29Modified : 2016-11-23Update by syncSocrata script at: 2017-01-05 01:07:28.352000

Dataset Attributes

  • _1_jurisdiction_name
    Text
    {"value"=>"City of Federal Way", "count"=>40} (), {"value"=>"City of Auburn", "count"=>27} (), {"value"=>"City of Redmond", "count"=>4} (), {"value"=>"City of Issaquah", "count"=>4} (), {"value"=>"City of Anacortes", "count"=>3} (), {"value"=>"Redmond", "count"=>2} (), {"value"=>"CIty of Issaquah", "count"=>2} (), {"value"=>"City of Orting", "count"=>1} (), {"value"=>"City of Sammamish", "count"=>1} ()
  • _1a_email
    Text
    {"value"=>"cthorn@auburnwa.gov", "count"=>27} (), {"value"=>"Daniel.Smith@Cityoffederalway.com", "count"=>21} (), {"value"=>"daniel.smith@cityoffederalway.com", "count"=>19} (), {"value"=>"smcquary@redmond.gov", "count"=>6} (), {"value"=>"danaz@issaquahwa.gov", "count"=>4} (), {"value"=>"jeffb@cityofanacortes.org", "count"=>2} (), {"value"=>"danaz@Issaquahwa.gov", "count"=>2} (), {"value"=>"johnf@cityofanacortes.org", "count"=>1} (), {"value"=>"utility@cityoforting.org", "count"=>1} (), {"value"=>"djohnson@sammamish.us", "count"=>1} ()
  • _3_date_incident_initially_reported
    Date
    2011-06-02T00:00:00 to 2015-05-12T00:00:00
  • _4d_is_the_structure_mapped_inventoried
    Text
    {"value"=>"d5m6-uyei", "count"=>39} (), {"value"=>"irwy-wkph", "count"=>5} (), {"value"=>"cycn-nnqc", "count"=>2} ()
  • _14_correction_elimination_method
    Text
    {"value"=>"Other (explain in Field 16)", "count"=>25} (), {"value"=>"Enforcement", "count"=>17} (), {"value"=>"No Action Needed", "count"=>10} (), {"value"=>"Add or Improve Source Control BMP", "count"=>7} (), {"value"=>"Add or Improve Treatment BMP", "count"=>3} (), {"value"=>"Add or Improve Source Control BMP: Enforcement", "count"=>3} (), {"value"=>"Behavior/Operations Modification", "count"=>3} (), {"value"=>"Education/Technical Assistance: Enforcement", "count"=>2} (), {"value"=>"Behavior/Operations Modification: Enforcement", "count"=>1} (), {"value"=>"Problem Not Abated (explain in Field 16)", "count"=>1} ()
  • _5_weather_condition_at_time_of_report
    Text
    {"value"=>"k3yg-cd9g", "count"=>58} (), {"value"=>"gy9h-jvxa", "count"=>24} ()
  • _6_frequency
    Text
    {"value"=>"by8x-h42e", "count"=>43} (), {"value"=>"7kpq-r9q8", "count"=>22} (), {"value"=>"n4uh-5r55", "count"=>10} (), {"value"=>"mgwx-eh2t", "count"=>9} ()
  • _5a_temperature
    Text
    {"value"=>"55", "count"=>6} (), {"value"=>"45", "count"=>6} (), {"value"=>"65", "count"=>4} (), {"value"=>"50", "count"=>4} (), {"value"=>"85", "count"=>3} (), {"value"=>"80", "count"=>3} (), {"value"=>"75", "count"=>3} (), {"value"=>"60", "count"=>2} (), {"value"=>"40", "count"=>2} (), {"value"=>"38", "count"=>2} ()
  • _9_how_did_you_learn_about_the_problem
    Text
    {"value"=>"Staff Referral", "count"=>20} (), {"value"=>"Catch Basin or Manhole Inspection", "count"=>11} (), {"value"=>"Pollution Hotline", "count"=>8} (), {"value"=>"Business Inspection: Catch Basin or Manhole Inspection", "count"=>6} (), {"value"=>"Business Inspection", "count"=>5} (), {"value"=>"ERTS", "count"=>5} (), {"value"=>"ERTS: Citizen complaint ", "count"=>2} (), {"value"=>"Citizen complaint ", "count"=>2} (), {"value"=>"Other Field Screening", "count"=>2} (), {"value"=>"Lakehaven Utility District notified us of the issue", "count"=>2} ()
  • _16_field_notes_explanations_and_other_comments
    Text
    {"value"=>"None", "count"=>6} (), {"value"=>"N/A", "count"=>3} (), {"value"=>"Report of spill from vehicle collision. Found extremely small amount of non-recoverable sheen on pavement surface.", "count"=>2} (), {"value"=>"Technical assistance provided.", "count"=>2} (), {"value"=>"No illicit discharge or connection identified with further water quality sampling.", "count"=>2} (), {"value"=>"NRC Environmental Services conducted the cleanup on 2/12/14 with City oversight. Cream was contained and did not leave MS4.", "count"=>2} (), {"value"=>"Reported to Anacortes via ERTS. Reported address may have been inaccurate. Report was construction site dumping. No construction occurring anywhere near the reported site address. Walked the area around the site. No activity by any construction company. The reporter identified American Construction as the responsible party. Called American Construction, spoke to Rod Gowdy. American is not currently working in the area. They have been putting up boom cranes on a Port of Anacortes dock referred to as \"T Dock\" located in the Cap Sante Boat Basin. Port of Anacortes supplies all materials, basically the boom cranes. American uses a boom truck to install the cranes. Rod Gowdy reported that no work being performed in the last month. I can report that I personally observed the site when construction was ongoing, and can also report that I observed that construction materials are onsite but no activity has occurred at the site for quite some time. Not sure how long at it was a casual observation, not a part of any investigation.", "count"=>1} (), {"value"=>"Sediment and erosion associated with landscape activity with impacts to MS4. BMPs implemented day of occurrence. Water quality violation email sent to Northwest Landscape Services.", "count"=>1} (), {"value"=>"Complaints received of dried paint waste being powerwashed off of driveway curbs into on site stormwater system. Ecology ERTS # 652263. Follow up with inspections and requirements to properly mitigate waste materials.", "count"=>1} (), {"value"=>"Documented wastewater in CB behind restaurant during O&M inspection. Appears to be kitchen mop water. Sent Notice of Correction. Owner denies discharge during follow up telephone conversation. Will continue inspections for compliance.", "count"=>1} ()
  • _2a_new_or_edited_entry
    Text
    {"value"=>"teu2-yyg8", "count"=>65} (), {"value"=>"txqb-eux4", "count"=>19} ()
  • _7_threat_determination_and_g3_notification
    Text
    {"value"=>"xvv4-sj7z", "count"=>53} (), {"value"=>"b8u2-q78g", "count"=>29} ()
  • _2_unique_identifier
    Text
    {"value"=>"S-0911-0009", "count"=>4} (), {"value"=>"S-1013-0027", "count"=>3} (), {"value"=>"S-1214-0022", "count"=>2} (), {"value"=>"S-1214-0018", "count"=>2} (), {"value"=>"S-1214-0017", "count"=>2} (), {"value"=>"S-1214-0013", "count"=>2} (), {"value"=>"S-1214-0015", "count"=>2} (), {"value"=>"S-1214-0023", "count"=>2} (), {"value"=>"S-1214-0016", "count"=>2} (), {"value"=>"S-0153-0003", "count"=>2} ()
  • _8b_final_resolution_of_illicit_connection_within_6_months
    Text
    {"value"=>"zgnv-4qnh", "count"=>69} (), {"value"=>"vtrv-jfii", "count"=>9} (), {"value"=>"wf55-ejax", "count"=>2} ()
  • _11_indicator_testing
    Text
    {"value"=>"Visual indicators", "count"=>39} (), {"value"=>"Not Used", "count"=>15} (), {"value"=>"Odor: Visual indicators", "count"=>7} (), {"value"=>"Color: Visual indicators", "count"=>4} (), {"value"=>"Turbidity: Visual indicators", "count"=>3} (), {"value"=>"Flow: Visual indicators", "count"=>2} (), {"value"=>"Color", "count"=>2} (), {"value"=>"Color: Odor: Visual indicators", "count"=>2} (), {"value"=>"Ammonia: Color: pH: Detergent/Surfacants: Nitrate: fecal coliform", "count"=>2} (), {"value"=>"fecal coliform", "count"=>1} ()
  • _8_investigated_within_7_days_per_program_procedures
    Text
  • _15_final_resolution_date
    Date
    2013-09-26T00:00:00 to 2015-05-18T00:00:00
  • _4a_street_address
    Text
    {"value"=>"33125 15th Ave. S.", "count"=>4} (), {"value"=>"32065 Pacific Highway S.", "count"=>3} (), {"value"=>"33020 10th Ave SW", "count"=>2} (), {"value"=>"2211 S. Star Lake Road", "count"=>2} (), {"value"=>"31847 Pacific Highway S", "count"=>2} (), {"value"=>"ROW, SW 338th St. & 23rd Ave SW", "count"=>2} (), {"value"=>"32925 1st Ave S", "count"=>2} (), {"value"=>"801 S. 336th St", "count"=>2} (), {"value"=>"430 SW 356th St.", "count"=>2} (), {"value"=>"2012 S. 320th St", "count"=>2} ()
  • _12_pollutant_s_identified
    Text
    {"value"=>"Vehicle Fluids", "count"=>20} (), {"value"=>"Sewage/Septage", "count"=>7} (), {"value"=>"Soap/Detergent", "count"=>5} (), {"value"=>"None Found", "count"=>4} (), {"value"=>"Sediment/Soil", "count"=>3} (), {"value"=>"Restaurant Wastewater ", "count"=>3} (), {"value"=>"Paint", "count"=>3} (), {"value"=>"Not Identified", "count"=>3} (), {"value"=>"Food Waste/Oil: Restaurant Grease and Oil", "count"=>2} (), {"value"=>"Food Waste/Oil", "count"=>2} ()
  • _10_source_tracing_methods
    Text
    {"value"=>"Visual recon", "count"=>77} (), {"value"=>"Visual recon, Indicator Testing", "count"=>2} (), {"value"=>"sanitary pressure test", "count"=>1} (), {"value"=>"Septic System Inspection", "count"=>1} (), {"value"=>"Visual recon, Dye Testing, Indicator Testing, Smoke Testing, Video Inspection", "count"=>1} ()
  • _5b_precipitation_in_previous_24hrs
    Text
    {"value"=>"0", "count"=>18} (), {"value"=>"0.5", "count"=>5} (), {"value"=>"1", "count"=>4} (), {"value"=>"0.2", "count"=>3} (), {"value"=>"0.3", "count"=>2} (), {"value"=>"2.3", "count"=>1} (), {"value"=>"0.6", "count"=>1} (), {"value"=>"0.1", "count"=>1} (), {"value"=>"0.02", "count"=>1} ()
  • _7b_g3_notification
    Text
    {"value"=>"p94q-4zgg", "count"=>48} (), {"value"=>"yrcd-75aa", "count"=>32} (), {"value"=>"6i2z-utex", "count"=>3} ()
  • _4b_and_or_zip_code
    Text
    {"value"=>"98002", "count"=>8} (), {"value"=>"98092", "count"=>6} (), {"value"=>"98052", "count"=>6} (), {"value"=>"98027", "count"=>6} (), {"value"=>"98001", "count"=>6} (), {"value"=>"98221", "count"=>3} (), {"value"=>"Unknown", "count"=>1} (), {"value"=>"98405", "count"=>1} (), {"value"=>"98360", "count"=>1} (), {"value"=>"98074", "count"=>1} ()
  • _13_source_or_cause
    Text
    {"value"=>"Commercial", "count"=>31} (), {"value"=>"Vehicle", "count"=>16} (), {"value"=>"Residential", "count"=>5} (), {"value"=>"Source Not Identified", "count"=>5} (), {"value"=>"Multifamily", "count"=>3} (), {"value"=>"Industrial", "count"=>3} (), {"value"=>"Sanitary Overflow", "count"=>2} (), {"value"=>"Church", "count"=>1} (), {"value"=>"Clearing ", "count"=>1} (), {"value"=>"Poor BMPs", "count"=>1} ()
  • _8a_if_suspected_illicit_connection_investigated_within_21_days
    Text
    {"value"=>"kbr9-5paj", "count"=>78} (), {"value"=>"iu6x-dzud", "count"=>2} (), {"value"=>"i7qe-tzni", "count"=>1} ()
  • _7a_immediate_response
    Text
    {"value"=>"6t74-v456", "count"=>81} (), {"value"=>"masx-smv3", "count"=>2} (), {"value"=>"ppu4-c5z5", "count"=>1} ()
  • id
    Number

Related Datasets