King County WTD GIS
Combined Sewer Overflow Status Viewer
November 18, 2015
Peter Keum
peter.keum@kingcounty.gov
![](https://s3.amazonaws.com/media-p.slid.es/uploads/138029/images/1962242/GISday-banner.jpg)
Happy GIS Day 2015 !
![](https://s3.amazonaws.com/media-p.slid.es/uploads/138029/images/1962238/worldtoiletday2015.jpeg)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/138029/images/1962302/sanitation-logo.jpeg)
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
![](https://s3.amazonaws.com/media-p.slid.es/uploads/keump/images/1104903/combined-separated_notable.jpg)
- 38 KC CSO (combined Sewer Overflow) Outfalls
Combined Sewer Overflow
![](https://s3.amazonaws.com/media-p.slid.es/uploads/keump/images/1179391/cso-pic.jpg)
CSO = Stormwater (90%) + Sewer (10%)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/keump/images/1179404/CSO_Diagram1.jpg)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/138029/images/1956961/19thNYstreet.jpg)
1881 New York - 2.5 million pounds of horse manure per day
(not too) long time ago.... galaxy far away
![](https://s3.amazonaws.com/media-p.slid.es/uploads/keump/images/1087078/StarwarsNewHope.jpg)
Joseph Bazalgette
![](https://s3.amazonaws.com/media-p.slid.es/uploads/138029/images/1962100/joseph-baglette.jpeg)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/138029/images/1962102/london-sewer.jpg)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/138029/images/1962112/londonsewer_syt.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/138029/images/1956973/Sewage-installations-19th-century.jpg)
Modern Sewer Conveyance System
![](https://s3.amazonaws.com/media-p.slid.es/uploads/138029/images/1956962/cityStreet_sewr.jpg)
Combined Sewer Overflow (CSO)
Stormwater (90%) + Sewer (10%) = CSO
![](https://s3.amazonaws.com/media-p.slid.es/uploads/138029/images/1956978/CSO_diagram_US_EPA.png)
NPDES - National Pollutant Discharge Elimination System (NPDES) Permits
![](https://s3.amazonaws.com/media-p.slid.es/uploads/keump/images/1258134/Screen_Shot_2015-04-10_at_11.42.38_AM.png)
Why CSO Status Viewer?
Regulatory Requirement
Main Purpose is to Inform Public
WHAT
WHERE
WHEN
![](https://s3.amazonaws.com/media-p.slid.es/uploads/keump/images/1237032/CSO-zoomview.png)
- Non-Interactive
- Not Enough Information
- Can Not Zoom
- Hard to update Basemap
Meets the Purpose BUT ....
![](https://s3.amazonaws.com/media-p.slid.es/uploads/keump/images/1237036/Screen_Shot_2015-04-04_at_2.20.25_PM.png)
So 90s !
![](https://s3.amazonaws.com/media-p.slid.es/uploads/138029/images/1963037/so90s-pic.jpg)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/138029/images/1963042/so90s-pic2.jpg)
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)
- Using gh-page to customize and integrate Leaflet JS (Aaron's project)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/keump/images/444301/githublogo-300x195.jpg)
GitHub
![](https://s3.amazonaws.com/media-p.slid.es/uploads/138029/images/1926125/Screen_Shot_2015-11-08_at_9.32.33_PM.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/138029/images/1962851/github-screenshot.png)
GitHub site
![](https://s3.amazonaws.com/media-p.slid.es/uploads/keump/images/445742/realtime_github.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/keump/images/1086996/github-icon.jpg)
gh-page + Leaflet.js
![](https://s3.amazonaws.com/media-p.slid.es/uploads/138029/images/1780756/Screen_Shot_2015-09-30_at_3.40.27_PM.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/keump/images/1074742/github-icon.jpg)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/keump/images/1237036/Screen_Shot_2015-04-04_at_2.20.25_PM.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/138029/images/1869679/Screen_Shot_2015-10-23_at_10.19.39_PM.png)
Old
Current
Finished for now....
![](https://s3.amazonaws.com/media-p.slid.es/uploads/138029/images/1963103/csoviewer-phone.jpg)
CUGOS
Cascadia
Users
of
Geospatial
Open
Source
(Community)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/138029/images/1926167/Screen_Shot_2015-11-08_at_9.41.03_PM.png)
me
![](https://s3.amazonaws.com/media-p.slid.es/uploads/138029/images/1926158/Screen_Shot_2015-11-08_at_9.36.53_PM.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/138029/images/1926156/Screen_Shot_2015-11-08_at_9.37.46_PM.png)
irc #cugos
CUGOS-Sidecar
Thank You
peter.keum@kingcounty.gov
GIS center & SPU GIS -cso real-time viewer
By Peter Keum
GIS center & SPU GIS -cso real-time viewer
KC CSO status viewer project highlight for CUGOS presentation Nov 2015 meeting.
- 2,349