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)
- Using gh-page to customize and integrate Leaflet JS (Aaron's project)
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