King County WTD GIS

Combined Sewer Overflow Status Viewer

November 18, 2015

Peter Keum

peter.keum@kingcounty.gov

Happy GIS Day 2015 !

WTD Mission:

  • Protect public health
  • Enhance environment by collecting and treating wastewater while recycling valuable resources for the Puget Sound Region.

KC Wastewater Treatment Division by numbers

  • 1.6 million people

  • 420 square miles

  • 391 miles sewer pipeline

  • 72 facilities (PS & RS)

  • 5 Treatment Plants: 180 MGD ~ Max. 900 MGD

  • 38 KC CSO (combined Sewer Overflow) Outfalls

Combined Sewer Overflow

CSO = Stormwater (90%) + Sewer (10%) 

1881 New York - 2.5 million pounds of horse manure  per day

(not too) long time ago.... galaxy far away

Joseph Bazalgette

Modern Sewer Conveyance System

Combined Sewer Overflow (CSO)

Stormwater (90%) + Sewer (10%) = CSO

NPDES - National Pollutant Discharge Elimination System (NPDES) Permits

Why CSO Status Viewer?

Regulatory Requirement

Main Purpose is to Inform Public 

WHAT

WHERE

WHEN

  • Non-Interactive
  • Not Enough Information
  • Can Not Zoom
  • Hard to update Basemap

Meets the Purpose BUT ....

So 90s !

Assembling Pieces

  • Python
  • GitHub
  • geoJSON
  • Leaftlet JS
  • Javascript
  • HTML

ETL

1. Extract - Python to take CSV status file from KC FTP site with KC and SPU data

  • Data is collected through SCADA (Supervisory Control and Data Acquisition)

 

2. Transform - Python to generate geoJSON file

 

3. Load - "push" newly created geoJSON file into GitHub repository

Extract Transform Load

GitHub

  • Ability to display geoJSON file/data automatically (June 2013)

 

GitHub

GitHub site

gh-page + Leaflet.js

Old

Current

Finished for now....

CUGOS

Cascadia 

Users

of 

Geospatial

Open 

Source

(Community)

me

irc #cugos

CUGOS-Sidecar

Thank You

 

peter.keum@kingcounty.gov